April 27, 2017 at 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)
April 27, 2017 at 3:58 am
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
April 27, 2017 at 4:06 am
Jonas Jisendal - Thursday, April 27, 2017 3:35 AMHi !
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 SentryIs 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
April 27, 2017 at 4:49 am
It´s primary for monitoring performance, jobs, backups.
I´m testing SQL Monitor from Redgate now.
April 27, 2017 at 5:30 am
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
April 27, 2017 at 7:25 am
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
April 27, 2017 at 7:44 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2017 at 7:48 am
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.
April 27, 2017 at 10:27 am
Here is an awesome and very capable FREE monitoring tool:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
April 28, 2017 at 5:06 am
We are using Foglight and quite happy with that tool. The more licenses you are going to purchase, the better deal you can strike.
April 28, 2017 at 7:35 am
barsuk - Friday, April 28, 2017 5:06 AMThe 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
April 28, 2017 at 8:16 am
Jonas Jisendal - Thursday, April 27, 2017 3:35 AMHi !
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 SentryIs 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
April 29, 2017 at 5:00 am
ThomasRushton - Friday, April 28, 2017 7:35 AMbarsuk - Friday, April 28, 2017 5:06 AMThe 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