fercasas (2/19/2013)
Hello,Very good article Jason, I will use it to monitor the growth of the tempdb database.
I have a question, for my case should only change the line SET @ instanceName = 'tempdb' in SpaceUsed_perfmon procedure, is this correct?
Regards 🙂
Thank you.
Yes, change @instanceName to whichever DB you are monitoring. In hindsight, this really should have been more aptly named @DBName.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events