SQL Server Performance

TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 14, 2008.

  1. Anonymous New Member

    DMVs are most helpful to find instant information on SQL instance without causing further delays, in any performance degradation time you can execute following TSQL to get top 10 queries that are generating lots of I/O on the server: SELECT TOP 10 total_logical_reads, total_logical_writes, execution_count, total_logical_reads+total_logical_writes AS [IO_total], st.text AS query_text, db_name(st.dbid) AS database_name, st.objectid AS object_id FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(sql_handle)...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/07/14/4581.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4581" width="1" height="1">

Share This Page