December 14, 2015 at 2:07 am
Can any one please tell me if there is any suitable database server monitoring tool is available in market?
I found a link here:
https://www.mssqltips.com/sqlservertip/1067/sql-server-performance-monitoring-tools/
But it does not have any pricing or any recommendation mentioned among this long list to which I can easily decide on a particular tool to be short listed and selected. Also if possible let me recommend if someone is using them in professional environment and share their experience.
Let me know about the Pros. & Cons. as well. If there is any that I need to care.
Can we run on live Production environment and keep it as a monitoring tool to help what happened and what I need to fix in quick steps etc.
Detect Hardware, Memory, Software, Database issues all in at a glance in dashboard kind of look.
Also do we need to put a dependency of such monitoring tool in any environment, would you suggest this as requirement?
Shamshad Ali
December 14, 2015 at 2:21 am
Take a look at
Red-Gate SQL Monitor
Idera Diagnostic Manager
Dell Spotlight on SQL Server
Dell Foglight
SQL Sentry Performance Adviser
ApexSQL Monitor
Prices vary, and will vary on bulk purchasing so prices are never usually given on blog posts as what one person pays another may not due to volume or special promotions the vendors are having.
Its then up to you to choose which one fits the needs of your business and your requirements.
They will all give you free trials and demos of the software so you can make the right choice.
December 14, 2015 at 4:03 am
The list you mentioned is sorted by best one on top or it is mixed?
December 14, 2015 at 4:09 am
As Anthony said
Its then up to you to choose which one fits the needs of your business and your requirements.
What's best for my requirements may not be best for yours, so try them out and select whichever one works best for you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2015 at 4:12 am
shamshad.ali (12/14/2015)
The list you mentioned is sorted by best one on top or it is mixed?
Mixed, as detailed, try them all out, they all do the same but different, they all may good for your needs they all might not be.
It's up to you to decide which one ticks all the boxes for you.
December 14, 2015 at 4:22 am
Can you please short list this? Can you recommend anyone out of your given list?
Sorry for asking this, as I wanted to get the idea from those who used it and save my time that is the main reason I wrote question here.
Shamshad Ali
December 14, 2015 at 4:24 am
Not going to stand one out from the other, they are all good tools, they all monitor, they all do the same thing, just in different ways and allow for customization in different ways.
What I've used in the past
Idera, Spotlight, SQL Sentry, all are good, all did what we needed in their own way.
What you want compared to what we wanted may be two different things, you will need to go do the research for yourself. What we suggest may be totally incorrect for what you actually need.
December 14, 2015 at 4:55 am
anthony.green (12/14/2015)
What I've used in the pastIdera, Spotlight, SQL Sentry, all are good, all did what we needed in their own way.
and I've used
SQL Monitor, Foglight and Spotlight. All good, all ones I'd be happy to recommend people evaluate.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2015 at 7:09 am
shamshad.ali (12/14/2015)
Can you please short list this? Can you recommend anyone out of your given list?Sorry for asking this, as I wanted to get the idea from those who used it and save my time that is the main reason I wrote question here.
Shamshad Ali
I'll recommend two.
If you're a small to mid-sized shop with moderate volume and mid-range to junior level DBAs, you should absolutely try out Redgate SQL Monitor.
If you're a very large scale enterprise, or you have extreme volume, or your DBAs are highly advanced, you should try out SQL Sentry.
DISCLAIMER: I work for Redgate.
"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
December 14, 2015 at 9:54 pm
Redgate or Idera
May 31, 2019 at 11:43 am
This was removed by the editor as SPAM
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply