Thursday, April 10, 2008

Top Queries in SQL Server 2005

Top Queries in SQL Server 2005


In SQL Server 2005 we could query dynamic management views such as dm_exec_query_stats and dm_exec_sql_text to find the TOP queries based on Average CPU and Average I/O.

No comments: