Red Gate forums :: View topic - SOLVED: Need a Custom Metric to monitor TEMPDB - help!
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

SOLVED: Need a Custom Metric to monitor TEMPDB - help!

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 512
Location: Costa Mesa, CA, USA

PostPosted: Fri Aug 17, 2012 7:35 pm    Post subject: SOLVED: Need a Custom Metric to monitor TEMPDB - help! Reply with quote

We had a runaway tempdb issue due to the version store not releasing its 240GB of reserved space and, likely, the GHOST cleanup process being unable to keep up with the deletion of somewhere approaching 50 million rows, index defragging and an emergency DB Shrink (DON'T bag on it - the choice was fail the system for lack of space or shrink it!), all at the same time...

Having failed the cluster over and reset the 16 individual tempdb files to their original 4GB, from 15GB per, I need to monitor tempdb VERY closely as we have a finite amount of space at our hosted site and expenditure of $,$$$ to permanently move tempdb to its own spindle isn't on right now.

Disclaimers:
1. I didn't architect the disk usage.
2. I'm stuck with mdf's and tempdb on the same drive.
3. I only have one other drive for ldf's and backups that doesn't have space for tempdb to grow to anything like the 240GB it just did.
4. Project IS underway to completely rearchitect the solution to spread to FOUR spindles and new server boxes and gobs of RAM.

I've seen the Custom Metric for Database Size at http://monitor.red-gate.com/Configuration/Custom-Metrics/Edit/11#/?v=1. Is this what I need as a basis and then qualify the query to feature just tempdb?

I need to get this set up ASAP so we don't get surprised, again, and run out of space...

Thanks for any assistance.

UPDATE
Thanks to what turned out to be very clear instructions on the page cited above, I was able to create and test the required metric.

However, the sample query purports to return the result in KB, but using ( 1024. * 1024. ) the result is in GB against a SQL 2005 instance. Strange but true...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group