Database Recovery

How to Keep Your SQL Server CPU Healthy and Avoid Bottleneck

In this article, we will discuss different methods to detect and resolve CPU bottlenecking, factors which ultimately leads to it, handling of inefficient query compilations and dealing with incapable query plans. Whenever we talk about maintaining large SQL Server schemas, the issue that arises the most is the throughput of the SQL Server CPU because as the schema objects of the database increases the time complexity of queries and database operations also increases. If these things are not...

Read more »

How to Find SQL Server Instances Using Discontinued Trace Flags

With the help of Trace Flags we can control specific SQL Server characteristics. Unless there is a very good reason, many expert DBAs never set trace flags for entire instance. If you miss to remove discontinued trace flags from SQL Server's startup parameters, you will see error messages in SQL Server Logs. In this article we will learn how to identify SQL instances that are still using discontinued trace flags. Collect flags Execute Script 1 from your central server. For each server name...

Read more »

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 »