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

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">