November 2, 2009 at 9:26 am
I'm looking to setup alerts within SQL instead of our other 3rd party tools. Specifically, I want to monitor when the Harddrive space on the log and database drives is getting to a certain size filled.
Has anyone done this?
Thanks!
December 7, 2009 at 7:53 pm
Yes.
The question I have is how many servers are you monitoring. Most people with more than a couple use SSIS to query WMI. It is also important to keep in mind whether you have drives or drives and mount-points. What this means is that you might have a D: drive that has 10GB of space but have mount-points where LUNS from a SAN are mapped into D: at locations like D:\MP1. In that case you won't be able to see the real space available without querying mount points. But either way WMI is the way to go.
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply