Best monitoring tool

  • Hi !
    I´ve searched the forum for tips on monitoring tools for SQL servers and found one topic that hasn´t have any entrys for the last 3 years.
    There are some products named there :
    SQL Monitor - Red-Gate
    Idera DM - Idera
    Spotlight - Quest\Dell
    Foglight - Quest\Dell
    SQL Sentry - SQL Sentry

    Is this still the best ones or is there others out there ??´
    The plan is to monitor about 50 SQL servers ( dev,test,and prod)

  • It all depends what you want from the tool.

    My advise would be to go get the trials of them all and install and play with them and see which one fits your requirements.

    A couple more to add to the mix

    Solarwinds
    ApexSQL Monitor

  • Jonas Jisendal - Thursday, April 27, 2017 3:35 AM

    Hi !
    I´ve searched the forum for tips on monitoring tools for SQL servers and found one topic that hasn´t have any entrys for the last 3 years.
    There are some products named there :
    SQL Monitor - Red-Gate
    Idera DM - Idera
    Spotlight - Quest\Dell
    Foglight - Quest\Dell
    SQL Sentry - SQL Sentry

    Is this still the best ones or is there others out there ??´
    The plan is to monitor about 50 SQL servers ( dev,test,and prod)

    SQL Sentry (the company) is now SentryOne...  The SQL Server monitor product is still called SQL Sentry.

    No, I'm not affiliated with them...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • It´s primary for monitoring performance, jobs, backups.
    I´m testing SQL Monitor from Redgate now.

  • We use Spotlight and I'm very happy with but it is quite expensive. It all depends on the level of detail you need and of course your budget. As has been said they all offer free trial periods so make a list of what you are looking for from the monitoring tool so you can compare them all at the end of the trial period.

    Tahanks

  • The licensing model is also important, especially if your organization has dozens or hundreds of instances to monitor.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Don't mind wading in here even though I work for Redgate.

    You'll want to focus on two things when you're evaluating the tool (from a tech perspective). Does it give you the information you need in a timely fashion in a way that you can understand, and, does it do all that in a way that works well within your environment. The different tools largely display some of the same data collected in similar ways. The differences are in how that data gets displayed and more of the details of how the data is collected.

    Of course licensing and cost play a factor, but I tend to focus on the nerdy side of things.

    If you have questions about SQL Monitor, I'd be happy to get you answers.

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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Someone previously mentioned SolarWinds, which is a good product.  They actually have two database monitoring products.  You can register SQL Server instances in SolarWinds SAM (Server and Application Monitor) and it captures a lot of Windows perfmon for the server and the SQL instance.  They also have Database Performance Analyzer (DPA), which measures performance for queries based on the waits they accrue.  There is some perfmon tracking in there too.  You can integrate DPA into SolarWinds so you can see DPA data in the SolarWinds UI.  I'm not affiliated with SolarWinds, but I do like the product.

  • Here is an awesome and very capable FREE monitoring tool:

    DatabaseHealth

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • We are using Foglight and quite happy with that tool.  The more licenses you are going to purchase, the better deal you can strike.

  • barsuk - Friday, April 28, 2017 5:06 AM

    The more licenses you are going to purchase, the better deal you can strike.

    You'll almost certainly find that that applies no matter which package you decide on...  😀

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • Jonas Jisendal - Thursday, April 27, 2017 3:35 AM

    Hi !
    I´ve searched the forum for tips on monitoring tools for SQL servers and found one topic that hasn´t have any entrys for the last 3 years.
    There are some products named there :
    SQL Monitor - Red-Gate
    Idera DM - Idera
    Spotlight - Quest\Dell
    Foglight - Quest\Dell
    SQL Sentry - SQL Sentry

    Is this still the best ones or is there others out there ??´
    The plan is to monitor about 50 SQL servers ( dev,test,and prod)

    We're using Red Gate SQL Monitor and are very happy with it. I like that the dashboard gives me a quick overview of everything all in one place. They just added a reporting feature that lets me create a report and have it emailed to me on a schedule so I can get a more detailed look at the servers. I have that sent to my email every Monday morning to give me a snapshot of the last 7 days of activity. My 2 cents.

    -Tom

  • ThomasRushton - Friday, April 28, 2017 7:35 AM

    barsuk - Friday, April 28, 2017 5:06 AM

    The more licenses you are going to purchase, the better deal you can strike.

    You'll almost certainly find that that applies no matter which package you decide on...  😀

    You are wrong. I was trying to get Idera first. It has been about 4 years ago. And no matter what I tried, the discount was pretty much within the same range whether I was getting 1 license or 15 licenses at the time.

Viewing 13 posts - 1 through 12 (of 12 total)

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