Monitoring sqlservers

  • Hi

    i want to monitor all sqlservers including production servers in my office

    any body can u pls give u r valuble suggesstion

  • Hi,

    Please specify on what aspect you would like to monitor the SQL servers. Is it the jobs, services, etc.

    Thanks,

    Have a nice day !!!

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • Hello Karan,

    You need to first narrow down your needs like what you would like to monitor? how would you like to monitor?

    There are also third party tool available to monitor sql server like mom, redgate tool etc.

    http://www.red-gate.com/products/SQL_Response/index.htm

    HTH,

    Cheers!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Hi

    manually i want to monitor all the servers

    like sql health check,jobs, counters etc......

    like dba tasks

    so pls help

    Thanks in advance

  • I guess the question is, do you want grow your own monitors or do you want to go & purchase some of the more sophisticated monitors?

    If you want to grow your own, I'd start with setting up event forwarding. Instead of trying to configure email on every server in the domain, and make yourself crazy, set up email on one server. Then configure the rest of your servers to forward all events to that server. You can do a search for event forwarding to find articles and it's in the Books Online. After that, you'll want to set up a method for running perfmon on your servers. To run it 24/7 on lots of servers will require quite a lot of work on your part, but it's doable. I'd also suggest spending time setting up a method to collect some amount of trace data each day so that you can identify the longest running procedures, most frequently called, etc.

    If that's all too daunting, then look to purchase software like Red Gate's SQL Response or Idera's SQL Manager or Microsofts Operations Manager. Those tools will do tons of that work for you and more.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Hello Grant,

    Thank you for pointing event forwarding feature of SQL Server.

    Just would like to know is it possible in event forwarding to filter the few or repetative errors or use multiple filters...? like

    "Message

    [364] The Messenger service has not been started - NetSend notifications will not be sent"

    Thank you in advance!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • I'm pretty sure you can't limit the forwarding, but I'm pretty sure you can limit the number of alerts or emails that are sent from the email enabled sql server. I'd have to look it up to be sure.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Idera SQL Diagnostic Manager is a good product which is very much geared towards what you are trying to do.

    Don't know what your budget is, but this is a good option if you have the money available.

  • I am recommending using SCOM 2007. I am already use it/

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

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