Database Recovery

How to Improve SQL Server Database Performance Globally

Microsoft's SQL Server is a DBA friendly product. Nevertheless, at certain times it might not be fast enough which will result in customer escalations. In such situations "Performance Tuning" is the only solution but many DBA's are neither aware of it nor know where to start. In this article, we will learn how to improve database performance at a global level. Performance improvement Any experienced DBA would have the ability to solve an issue and identify the root cause that affected the...

Read more »

How to Read SQL Server Configuration and Installation Information from Registry

Many DBAs rely on Windows Registry search to get info about SQL Server Instances. It is not necessary to go through the registry for fetching SQL Server information. In this article, we will learn how to use TSQL and retrieve SQL Server information from Windows Registry. Get the permission: Before running the script, user account or the SQL Service account that would be running this script should have view server state permission on all servers from which data would be collected. If you run...

Read more »

How to Prevent SQL Server Jobs from Getting Executed during Maintenance

In a big SQL environment, it is very common to see servers rebooted during maintenance. Though we might inform the users about the server maintenance, many DBAs miss taking care of their SQL Server agent jobs. In this article, we will learn how to identify SQL Server Agent jobs that are scheduled to run at a specific time. We can then disable jobs whose schedule collide with the maintenance window. No notification: You might have set up SQL Server jobs to send out failure notifications or...

Read more »