Returns information about all the waits encountered by threads that executed. You can use this aggregated view to diagnose performance issues with SQL Server and also with specific queries and batches.
SELECT *
FROM sys.dm_os_wait_stats
ORDER BY wait_time_ms DESC
No comments:
Post a Comment