Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Query for Sql capcity palnning Expand / Collapse
Posted Monday, October 21, 2013 9:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, May 27, 2016 7:35 AM
Points: 277, Visits: 1,046
we need to provide Volume Capacity every month for every drive and difference between pervious and current growth on the drives.
At present we are doing in the below way,

we create a sql job on central server which will fetch all the disk space and drive information on all server
and will sent to mail in an .xls format.

Server_Name Drive Free_MB Total_MB Percent_Free

After that every month we are doing difference(previous and current month) in below way and updating in the below formate.

March Feb Jan difference
------------------------------------------------------------------ ---------------- ------------------------------------------------
Server, Disk ,Total capactiy ,Free space ,Space used,Free space,Space used,Free space,Space used,Mar13-Feb13 ,Feb13-Jan13,Mar13-Jan13 ,

Projected growth , Projected growth , Capacity planning
for next 3 months for next 6 months

Instead of doing it manully we need to do it automated.

Can anyone help me to wright the script to do it automated.....
Post #1506707
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse