Post reply

Daily Status monitoring report for SQL Server 2005

  • October 27, 2009 at 4:54 pm

    #385658

    Hi,

    I'm just working on monitoring SQL Server. I know there are many 3rd party tools for Monotoring But I'm looking for t-sql script to do that. Is there any script to monitor the SQL server health, database health, memory, paging, backup failures, Disk IO and get an email every day moring.

    How do you guys automate this process.

    Thanks for your inputs

  • October 29, 2009 at 12:43 am

    #1072254

    any sample scripts to start with...

    thanks

  • October 29, 2009 at 2:53 am

    #1072291

    You can collect the information you want(Uptime, Errorlogs, Diskspace, Db Status, Db Size etc..) from every server and put it into a centralized server using Integration service or even VBScript...

    Once you have the data in a database you can create reports using Reporting service...

    Sanz

  • October 30, 2009 at 6:23 am

    #1073054

    arent there any powershell solutions? would like to get a report without reporting services...:) (if this is possible)

  • October 30, 2009 at 10:21 am

    #1073263

    You can try using "SQL Server performance Dashboard" tool from microsoft.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • October 30, 2009 at 10:37 am

    #1073269

    I think the reporting services report was just a suggestion of one possibility.

    Once the data is in a database, you can use t-SQL, asp, vb, c#, crystal reports, or whatever you are comfortable using to create your reports.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 31, 2009 at 5:40 am

    #1073498

    I use a scheduled VB.Net application to poll various servers to make sure that services are running, websites are up, and ping requests are being replied to etc, then I stick all this in some tables. I then also have scheduled t-sql scripts that check the following:

    SQL Server instances are up

    Backups (full and log) have been done, including when each backup was last done, how long it took and where the backup file is

    SQL Agent job history - Today's scheduled jobs, when each one last ran, how long it took and the completion status of this

    and various other things. The whole data then gets dumped into some tables, with some of tha data being displayed through a website (I have two 32" monitors on the walls rotating through these pages at 30 second intervals so people can immediately see any problems) and the rest is served out through daily Reporting Services reports..

    There's all kinds of data you can capture and report on. I also have started integrating it with the Microsoft SQL Dashboard reporting stuff as well which really helps too.

  • November 1, 2009 at 2:44 pm

    #1073629

    could you post your t-sql script please :)?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply