Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2007-01-18 : 08:18:17
|
| Hi I have 600 instances on my network .... I need to monitor the Disk Space ... how should I do that I mean the best way for this would be ???By Disk Space I mean the SQL Instance should atleat have 10% of free disk space ... If it is less , maybe an alert can be sent or something of that sort .Now it would be a pain configuring alerts on each machine.Is there some good way to this Thanks in advance. |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-01-18 : 08:37:42
|
| I have an admin DB on each machine, and a set of SP's that run that collect things like TLog, DB space and Free Disk space on each server. These throw out alerts via SMTP email if any thresholds are passed, and I also collect the data to a central server overnight for analysis, and mothly reporting purposes.For Server Free Space look at xp_fixeddrives which returns how much space is available on the diskand IIRC sp_SpaceUsed gives you the amount of space used by a database-- RegardsTony The DBA |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-20 : 08:36:19
|
| We do this too [an Admin database to monitor such things].One benefit of this, which Tony has hinted at, is predicting the rate at which disk space is being exhausted - rather than just getting the emergency "Disk nearly full" message!Kristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-01-22 : 03:20:51
|
| We have a similar Admin database too, I've just tacked an ASP.NET page onto it (and an RSS feed) so that I can access the data easily in the form I wantsteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-23 : 01:12:21
|
| "... and an RSS feed) ..."Hadn't considered that .... a web page that had "Plenty", "Low" and "None" as its "Disk space" values (rather than exact MBs) would then only need to be "changed" when those values change, and an RSS feed would only need to look at changed pages. Is that about right?Kristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-01-23 : 03:35:41
|
| Yes pretty much, if you're really clever you can put pie charts and stuff in too but I'm not really clever.To be honest I got the idea because my new phone has an RSS reader!steve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2007-01-23 : 11:40:58
|
| Can some one please explain in detail how to set this up ... I mean I can go ahead & have an ADMIN Db in all off my servers.. but then whats the next step ... I need to create jobsa that would run every hour .. but then... can someone please help me .. Dont have the finance to get a 3rd party tool to help me do thisThanks a ton.... |
|
|
|
|
|
|
|
|
Disk Space Monitoring ...