Database growth Monitoring on diff servers

  • [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]

  • Please refer the below link,

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

    I hope it helps.

    Satnam

  • 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...

  • Hi Anil,

    If possible could you please share Capacity planning for Database growth.How are you tracking Db growth.

  • 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