January 25, 2011 at 1:01 am
[font="Tahoma"]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.[/font]
January 25, 2011 at 1:13 am
Please refer the below link,
http://www.sqlservercentral.com/articles/Automating+SQL+Server+Health+Checks/68910/
I hope it helps.
Satnam
January 25, 2011 at 1:23 am
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...
October 19, 2011 at 5:28 am
Hi Anil,
If possible could you please share Capacity planning for Database growth.How are you tracking Db growth.
February 26, 2014 at 2:15 am
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 2000/2005/2008/2012 DBA - MCTS/MCITP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply