Debugging SQL Server Query Performance
To enable timing of your query: SET STATISTICS TIME ON Time statistics provides output like this in the “Messages” tab of SSMS after running a query: (127 row(s) affected) SQL Server Execution Times: CPU time = 0 ms, elapsed time = 42 ms. To show IO statistics: SET STATISTICS IO ON ..which provides stuff […]