There are a few little gems built into SQL Server Management Studio that are easy to forget, but they sure can come in handy.
I sometimes generate a little formatted report of recent growths for a database, and how long they took. It’s really easy, and it’s built right in. Here’s how:
- Right click on a database name in Object Explorer
- Select Reports
- Then Standard Reports
- Then Disk Usage. Voila, the Disk Usage report appears!
- To see recent autogrowth or autoshrink events, click the little plus sign under the pie charts.
Here’s a 30 second video of that in action:
Where Does SQL Server Track Autogrowth Events?
This report reads from the default trace files. Those files can roll over pretty frequently in an active environment, so this only gives you recent events. You can get the same information with a query, or look for slow auto-growths using our free sp_Blitz® script.
When sp_Blitz® gives me a warning that something’s up, I like to get screenshots from this report to go the extra mile. It’s very nicely formatted and shows any troublesome latency pretty clearly.