How many times have we heard that SQL Server is running slow from end-user, but can’t track down why? Or what happened? In this post
Tag: DMF – sys.dm_exec_query_plan
Finding All Plans/SQL Statements that executed in Parallel
References: #21 Statement copied from The Rambling DBA: Jonathan Kehayias Blog
Get Top 50 SQL Statements/Query Plans
Finding out what statements causing grief on SQL Server has become significantly easier with SQL Server 2005+. I am using some of the DMV/DMF to