SQL Server - How to show most 50 heavy query (come visualizzare le 50 query più pesanti - Sql Server)... very nice SQL Script to discover slow NAV Sessions !!SQL SCRIPTSELECT TOP 50 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,((CASE qs.statement_end_offsetWHEN -1 THEN DATALENGTH(qt.TEXT)ELSE qs.statement_end_offsetEND - qs.statement_start_offset)/2)+1),qs.execution_count,qs.total_logical_reads, qs.last_logical_reads,qs.total_logical_writes, qs.last_logical_writes,qs.total_worker_time 
Leggi tutto il post...