Post reply

we only need to know if DB is down due to some issue

  • March 5, 2010 at 3:31 am

    #221246

    Hi , i have question ,

    using SQLSERVER2008 STANDARD EDITION 64 BIT.

    IS THERE ANY SCRIPT FOR THR MONITORING THE SERVER PERFORMANCE ,

    AND FOR THE DATABASE DOWN DUE TO SOME ISSUE .

    PLEASE HELP ME

    THANKS IN ADVANCE

    vkI

  • March 5, 2010 at 6:26 am

    #1129116

    I recommend Dynamic Management Views (DMV's).

    However, your question is a little broad. Are you trying to troubleshoot a performance issue or monitor when/if SQL Server goes down?

    Performance issues are best found by using Profiler and explain plans. Profiler will help you find the queries that are taking the longest and Explain plans can point out the inefficiencies.

    I hope this helps you.

    Regards, Irish 

  • March 5, 2010 at 1:29 pm

    #1129440

    The SQL Agent can help alert you when there are problems.

    I setup each of our servers to at a minimum to send email alerts when there is a failed login, a database goes suspect, or if there is any hardware related problems detected. However, you can setup alerts for a wide variety of issues SQL might detect. Downside it's a manual process to setup, but you script the process out so you can easily replicate the settings to other servers.

    On the rare occasion we did have any issues the alerts made troubleshooting issues much quicker and it almost always alerted us to the problem before any of our users had a chance to launch a ticket about it.

    We also have monitoring software specifically (OpManager) that monitors these same things, as well many other important performance metrics within SQL and at the server level. These tools are great, but can be expensive. Most free monitoring tools out there aren't worth much.

    If you want to gather performance metrics for review the data collection feature new to SQL 2008 can be useful.

  • March 8, 2010 at 1:34 am

    #1129873

    Thanks ,

    my requirement is login failed & database suspect issue alert

    can u ive me the details , how to set these two things in sqlserver2008 to get the alerts , if the login failed , or Db got suspect

    ..

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

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