Post reply

Automated System report

  • February 5, 2007 at 1:54 pm

    #194140

    Hi all,

    How can i generate automated response from the server which provides me the system uptime and usage  and all the information.

    Please help me.

    thanks

  • February 5, 2007 at 10:48 pm

    #687913

    You could "borrow" the some of the rpt reports on SQL 2005. Should be somewhere in the SQL directory.

  • February 6, 2007 at 2:34 am

    #687943

    Depending on the type of information you want there are several ways to go. If you want a message then a certain value exceeds some value you might want to look into alerts.

    If you want something like a daily report you could set up a job which queries the values and then sends them using databasemail. Or if you're using Report services you can create a report with a subscription which sends the report on a daily basis. You could use the standard SSMS reports as a starting point. You can download the definiton of these reports here:

    http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS-Reports-3.aspx

    Hope this helps

    Markus 

    [font="Verdana"]Markus Bohse[/font]

  • February 6, 2007 at 7:49 am

    #688030

    buy a monitoring tool :-

    • SQL Diagnostics Manager
    • Terratrax performance monitor
    • MOM

    for example.

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 4 posts - 1 through 3 (of 3 total)

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