List expensive tsql queries (sys.dm_exec_query_stats)
List expensive queries [bs url=http://gallery.technet.microsoft.com/scriptcenter/List-expensive-queries-f6d63ac6] This Transact-SQL script returns the values from DMV sys.dm_exec_query_stats to rate SQL statements by their costs. These “costs” can be “Average CPU execution time “Average logical operations” or the total values of these measures
DECLARE @MinExecutions int; SET @MinExecutions = 5…
View On WordPress










