HOME

Monday, August 6, 2012

KNOWING SQL SERVER 2005 PERFOMANCE AND STATISTICS



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