Post reply

Alive

  • June 30, 2010 at 12:07 pm

    #223355

    Hi,

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql server or any method.

    Thanks in Advance.

  • June 30, 2010 at 12:18 pm

    #1187264

    The service has a series of options, depending on your OS, to run a command. You can use that.

  • June 30, 2010 at 12:20 pm

    #1187265

    Steve Jones - Editor (6/30/2010)

    The service has a series of options, depending on your OS, to run a command. You can use that.

    Thanks for your reply. Kindly the give me the few best options, we have windows 2000 and 2003 OS.

  • June 30, 2010 at 12:51 pm

    #1187279

    sudhakara (6/30/2010)

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql server or any method.

    What we do is to check that the whole system is up - to do that we have box A connecting every five minutes to box B and executing a test sql statement - if it doesn't work, can't connect or whatever process pages oncall dba.

    At the same time, box B is monitoring box A the same way.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • June 30, 2010 at 4:15 pm

    #1187380

    PaulB-TheOneAndOnly (6/30/2010)

    sudhakara (6/30/2010)

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql server or any method.

    What we do is to check that the whole system is up - to do that we have box A connecting every five minutes to box B and executing a test sql statement - if it doesn't work, can't connect or whatever process pages oncall dba.

    At the same time, box B is monitoring box A the same way.

    I just watch the blinking lights, listen to the tone of the fans, and occasionally feel the cables for warmth. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 30, 2010 at 4:35 pm

    #1187388

    If you just want to get notified if SQL is down, not Windows, Go to the control panel, look for services, look for the SQL Server. Look at the options for the service. If it goes down, it can be rsetarted, or a program run.

    Set up a command line option notify you.

    If you need to monitor the entire Windows box, you need some service, as mentioned above, to connect to the Windows host or SQL Server and check if it responds. There are lots of software that can do this (Unicenter, OpenView, What's Up, Servers Alive, etc.) search for monitoring tools.

  • June 30, 2010 at 6:40 pm

    #1187414

    PaulB-TheOneAndOnly (6/30/2010)

    sudhakara (6/30/2010)

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql server or any method.

    What we do is to check that the whole system is up - to do that we have box A connecting every five minutes to box B and executing a test sql statement - if it doesn't work, can't connect or whatever process pages oncall dba.

    At the same time, box B is monitoring box A the same way.

    Great idea...

  • June 30, 2010 at 6:41 pm

    #1187415

    Jeff Moden (6/30/2010)

    PaulB-TheOneAndOnly (6/30/2010)

    sudhakara (6/30/2010)

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql server or any method.

    What we do is to check that the whole system is up - to do that we have box A connecting every five minutes to box B and executing a test sql statement - if it doesn't work, can't connect or whatever process pages oncall dba.

    At the same time, box B is monitoring box A the same way.

    I just watch the blinking lights, listen to the tone of the fans, and occasionally feel the cables for warmth. 😉

    good work keep it up...

  • June 30, 2010 at 6:41 pm

    #1187416

    Steve Jones - Editor (6/30/2010)

    If you just want to get notified if SQL is down, not Windows, Go to the control panel, look for services, look for the SQL Server. Look at the options for the service. If it goes down, it can be rsetarted, or a program run.

    Set up a command line option notify you.

    If you need to monitor the entire Windows box, you need some service, as mentioned above, to connect to the Windows host or SQL Server and check if it responds. There are lots of software that can do this (Unicenter, OpenView, What's Up, Servers Alive, etc.) search for monitoring tools.

    Thanks for your reply...

  • July 1, 2010 at 6:37 am

    #1187622

    sudhakara (6/30/2010)

    Jeff Moden (6/30/2010)

    PaulB-TheOneAndOnly (6/30/2010)

    sudhakara (6/30/2010)

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql server or any method.

    What we do is to check that the whole system is up - to do that we have box A connecting every five minutes to box B and executing a test sql statement - if it doesn't work, can't connect or whatever process pages oncall dba.

    At the same time, box B is monitoring box A the same way.

    I just watch the blinking lights, listen to the tone of the fans, and occasionally feel the cables for warmth. 😉

    good work keep it up...

    BWAA-HAAA! You think I'm kidding. 😛 No one looks at the physical hardware anymore. You can tell a lot that all the fancy pantsed reporting software in the world won't tell you just by making the occasional tour through "the room". 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 1, 2010 at 6:44 am

    #1187626

    I find users tend to phone up and alert us when a database server is down............:-)

    Seriously if you need this box to be Highly available perhaps you need to look at clustering or database mirroring.

    ---------------------------------------------------------------------

Viewing 11 posts - 1 through 11 (of 11 total)

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