Post reply

SQL server restarted and need to get notified

  • June 19, 2012 at 2:48 pm

    #271502

    Sometimes a SQl server may be restarted or SQL service may be restarted by someone. ( I know this should be usually done by DBAs, but sometimes a developer may restart their testing server that owned by their small group for example).

    As a DBA, I also wanted to be notified.

    I would like to find out from DBAs on this forum, what tool you use to monitor things like this, I mean a server get restarted, or SQL service is restarted?

    Thanks

  • June 19, 2012 at 3:38 pm

    #1503145

    Some people use a startup proc that emails an alert.

    Some may use some monitoring tools from 3rd parties.

    Another possible option is to setup your own system that logs the tempdb create date every now and then. Compare the current record to the last record and if different, then fire off an email.

    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

  • June 20, 2012 at 2:16 am

    #1503265

    I have a job which sends a mail when SQL Agent starts, only problem is if the agent isnt restarted when someone restarts the engine, but as its in a clustered environment I have yet to run into that issue.

  • June 20, 2012 at 6:21 am

    #1503358

    SCOM, Solarwinds etc. will all do this kind of thing if there already in your organisation make friends with your Server OS team or person. Other than that there's loads of other products from Redgate (clang), Quest and Idera that do similar kind of things, or you can write your own tools like this one http://www.enterprisedba.com/

  • June 20, 2012 at 8:13 am

    #1503460

    We scan the log every hour and send an email with the information we want to be notified about. Server restarts are one of the things we like to know about 🙂

    Jared
    CE - Microsoft

  • June 20, 2012 at 8:21 am

    #1503468

    We have a startup SP that notifies us of the startup as well as the status of each database. We have a 2nd SP to notify us of an outage or startup of SQL Agent. We supplement that with OpenView.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • June 20, 2012 at 9:09 am

    #1503515

    Thanks all, I did some research and made two steps, one is notify SQL server agent restart, the other is to notify SQL server restart.

    By the way, anyone knows how to monitor if SQl server is shut down.

  • June 20, 2012 at 9:11 am

    #1503519

    sqlfriends (6/20/2012)

    Thanks all, I did some research and made two steps, one is notify SQL server agent restart, the other is to notify SQL server restart.

    By the way, anyone knows how to monitor if SQl server is shut down.

    You can have a task run a check in task manager, or run a check from a different SQL Server if you have that luxury.

    Jared
    CE - Microsoft

  • June 20, 2012 at 11:29 am

    #1503611

    I setup to execute a stored procedure when sql server starts up to notifiy me the server is restarted.

    It works fine.

    My question is what will happen if a stored procedure failed to execute when the server is restarted?

    The stored procedure is basically to send a mail to notify me. So I would like to know in case the server doesn't have data mail setup, or anything wrong with the email server, if the sproc failed, will it affect the server?

    Thanks

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

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