profiler pour les requettes sql

--============================
--> Afficher les 50 dernières requêtes exécutées
--=============================

Code:

1
2
3
4
5
6
7
SELECT TOP 50 creation_time,  
total_worker_time/execution_count AS [Avg CPU Time],  
SUBSTRING(st.text, (qs.statement_start_offset/2)+1,((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(st.text)  
ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) AS statement_text  
FROM sys.dm_exec_query_stats AS qs  
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st  
ORDER BY creation_time DESC;

Pour plus d'infos