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

Database growth Monitoring on diff servers Expand / Collapse
Author
Message
Posted Tuesday, January 25, 2011 1:01 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 11:04 AM
Points: 856, Visits: 331
Hi Friends,
My best Greetings for you,

In my work place Im supposed to build a central repository system which can track the current sizes of the DBs and drive space stats on the windows server where our sql server is residing.(One sql server per one windows server--We do not have multiple instances of sql servers)

GrowthTracker(Lets say this is where we store all the DBs info and drive space stats of all multiple servers) sits on one server and with the scheduled job... running script from here alone...should fetch and store the results which will be retrieved later sometime.

I knew sp_databases would give us current DB sizes and i also have a stored proc which can retrieve the current drive space stats.

PS: The script has to go with 2000 and 2005 servers with different SPs :)

Can someone help me how to achieve this task.
Your every little help will be atmost appreciated.

Thanks in Advance.
Post #1052904
Posted Tuesday, January 25, 2011 1:13 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
Please refer the below link,

http://www.sqlservercentral.com/articles/Automating+SQL+Server+Health+Checks/68910/

I hope it helps.

Satnam
Post #1052906
Posted Tuesday, January 25, 2011 1:23 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:18 PM
Points: 843, Visits: 2,559
You could also use PS

DB tracking script:
http://www.mssqltips.com/tip.asp?tip=1759

Disk size monitoring should not be too hard either to implement. Just google it!


__________________________
Allzu viel ist ungesund...
Post #1052913
Posted Wednesday, October 19, 2011 5:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 5, 2012 5:25 AM
Points: 67, Visits: 95
Hi Anil,

If possible could you please share Capacity planning for Database growth.How are you tracking Db growth.
Post #1192762
Posted Wednesday, February 26, 2014 2:15 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 357, Visits: 748
Create a DBA Repository , populate it with SSIS and you can build your reports using SSRS from your DBA Repository

check link

http://sql-ution.com/dba-repository-gather-database-size-info/


SQL 2005/2008 DBA - MCTS/MCITP
Post #1545272
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse