Tagged Questions
5
votes
1answer
344 views
SQL Server 2008 R2 DMV Question
I have a query to retrieve the Top 10 queries based on total logical reads from the dm_exec_query_stats DMV.
SELECT TOP 10
SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE ...