Query Malefiche

La seguente query SQL individua le ultime query effettuate a sistema di tutti gli utenti che risultano malefiche per il sistema (Malefiche non è una parola composta).

SELECT
st.text,
SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,
((CASE statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE qs.statement_end_offset END
- qs.statement_start_offset)/2) + 1) as statement_text,
execution_count,
case
when execution_count = 0 then null
else total_logical_reads/execution_count
end as avg_logical_reads,
last_logical_reads,
min_logical_reads,
max_logical_reads,
case
when execution_count = 0 then null
else total_logical_writes/execution_count
end as avg_logical_writes,
last_logical_writes,
min_logical_writes,
max_logical_writes,
max_elapsed_time
FROM sys.dm_exec_query_stats as qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st
ORDER BY max_logical_reads DESC