Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Centralised monitoring of disk space Expand / Collapse
Author
Message
Posted Monday, June 17, 2013 6:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:35 AM
Points: 2,507, Visits: 3,644
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.
Post #1464124
Posted Monday, June 17, 2013 8:55 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:49 PM
Points: 32,768, Visits: 14,929
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1464199
Posted Monday, June 17, 2013 9:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:35 AM
Points: 2,507, Visits: 3,644
Thanks a lot Steve..

I am blessed to get a reply from the great Steve.
Post #1464223
Posted Monday, June 17, 2013 10:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:49 PM
Points: 32,768, Visits: 14,929
:), You are welcome.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1464252
Posted Monday, June 17, 2013 10:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:56 PM
Points: 237, Visits: 761

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.
Post #1464282
Posted Tuesday, June 18, 2013 2:56 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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.
Post #1464512
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse