Posted on July 8, 2020 by satyaramesh
This blog post first appeared on SQLMaestros If you want to find the top ‘n’ queries that are currently in the cache, which are consuming more CPU, then you are at …
Read More »
Posted on July 7, 2020 by satyaramesh
This blog post first appeared on SQLMaestros If you want to identify non parameterized queries that are hogging your SQL Server plan cache then you are at the right place. sys.dm_exec_query_stats …
Read More »
Posted on July 6, 2020 by satyaramesh
This blog post first appeared on SQLMaestros In our previous blog posts, we have seen how to find fragmented indexes in a database and how to defrag them by using rebuild/reorganize. …
Read More »
Posted on July 3, 2020 by satyaramesh
This blog post first appeared on SQLMaestros In our previous blog post, we got to know, how to find out all fragmented indexes in a database. Now we will see how …
Read More »
Posted on July 2, 2020 by satyaramesh
This blog post first appeared on SQLMaestros We do create indexes to improve the search performance of our queries. But over a period of time, because of DML operations (inserts/deletes/updates), the …
Read More »
Posted on July 1, 2020 by satyaramesh
This blog post first appeared on SQLMaestros Before we start fine tuning SQL Server, it is good to make sure all basic best practices are in place. One such best practice …
Read More »
