Welcome to Techsapphire


Finding expensive queries in SQL Server and performance optimization

Finding expensive queries can be challenging on SQL Server, this tutorial will help you in finding expensive queries on production. Using below DMVs: SYS.DM_EXEC_QUERY_STATS SYS.DM_EXEC_SQL_TEXT SYS.DM_EXEC_CACHED_PLANS SYS.DM_EXEC_TEXT_QUERY_PLAN First is using average logical reads, execution count and total worker time. But still people can use other combinations as well. I have also explained how missing index […]