June 17, 2013 at 6:58 am
Hi Experts,
I want to monitor disk space of all servers and i have created a centralised server from where i can check all the server disk space at once using xp_fixeddrives.
How can i make it as a scheduled job and any script to show servers having least disk space first?
Thanks in Advance.
June 17, 2013 at 8:55 am
First, do this for one server. Make a job that runs xp_fixeddrives and inserts the results (and the date) into a table on the instance. Write a cleanup task/job that deletes data that's, say, a year old, from the table.
Once you have this, then it's a question of making a remote call from your centralized server and retrieving the information from each server and inserting it into the central instance. I would actually look at Powershell for this, looping through a list of servers, reading the table, inserting into your current server.
For a report, it's a simple query. Select server name, date, drive, diskspace, order by diskspace ascending.
June 17, 2013 at 9:40 am
Thanks a lot Steve..
I am blessed to get a reply from the great Steve.
June 17, 2013 at 10:15 am
:), You are welcome.
June 17, 2013 at 10:54 am
If all of your servers are visible from the centralized server, you could do this directly via powershell and WMI calls, while looping through a list of servers.
I implemented this at previous client.
xp_fixeddrives does not give you info on mounted volumes, nor C:\ on currently passive cluster nodes.
June 18, 2013 at 2:56 am
Hi Nair,
Are you using clusters , so is it mount points? In this case, i suspect xp_fixeddrives will help you????when googling consider mount points as well. It needs to be some thing different than monitoring ordinary NAS drives.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply