Friday 7 January 2011

Getting performance data from SQL server

If you need to tweak a query to run a bit faster you can tell SQL server to also show performance data with the following command:

SET STATISTICS PROFILE ON

This will show each part of the query and how long it has taken etc.

To turn this off again use:

SET STATISTICS PROFILE OFF

No comments:

Post a Comment