July 8, 2010 at 9:37 pm
Just want to make sure I am not missing something obvious here.
I am looking to be able to alert when the TEMPDB data file is x% full. I know I can set alerts for TLOGS on % log used and yes, TLOG filling does translate to data files filling, but it is not an exact correlation.
I do have database size and growth trending reports I review every morning for which I have written custom code, so I know how to get the data I am looking for, but I was just hoping I might not have to go the "roll my own" route.
Thoughts? Comments?
Thanks!
July 9, 2010 at 6:50 am
Sorry, nothing built in for that. You'll have to roll your own.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply