Quick script to see active processes and to grab the query plan. It leverages some DMVs to get the query text and plan. Only can be used on SQL 2005 and above. It is a great and light wight way to see what is going on with the server and performance tuning.
Monthly Archives: December 2011
Query Plans and active query information
Posted by JackDonnell
on December 29, 2011
Comments Off on Query Plans and active query information
Disk Space – Get table sizes
Posted by JackDonnell
on December 29, 2011
Comments Off on Disk Space – Get table sizes
Below is a script I use to determine table size. Basically, it walks through the user databases and for each table. The information is converted in GB. It’s a pretty simple use of MS sp_spaceused with sp_msforeachtable. More info on sp_spaceused.
Full script, below. Download script here.