HOME

Saturday, July 14, 2012

how find SQL SERVER 2005 statistics and perfomance


SELECT *
FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st ORDER BY total_logical_reads DESC;

No comments:

Post a Comment