I doubt that I’m alone in the experience of beginning to troubleshooting a slow query, executing, and clicking over to the messages tab to get some juicy information only to find…
Nothing too helpful. Far too often I would be bouncing between query windows and run a query only to realize my mistake of not running
1 2 3 | SET STATISTICS IO, TIME ON |
This can be especially frustrating when that query you were waiting on takes its sweet time to run (because who’s checking IO/TIME for fast queries). Thankfully, this is a step you can skip if you turn them on my default for each new query window in SSMS.
Let SSMS Handle it
Select Tools > Options:
Scroll down to Query Execution > SQL Server > Advanced:
Highlighted above are the two selections to checkbox. Click OK.
This won’t take affect the existing query window if you have one open a new query window and run the same script:
We have some information to use while troubleshooting.
If you’re frequently using the same SSMS to connect out to SQL servers then this can save you a little bit of time and frustration. It’s not that big of a deal but it’s always nice having one less thing to worry about.
