SQL Server monitoring tools

Question

Post reply

SQL Server monitoring tools

cmc123

Right there with Babe

Points: 762
More actions
April 25, 2016 at 1:35 pm

#306846

Hi,
We have an estate of 120 Prod & DR Servers. We looking for efficient monitoring tool. we would like to know Top 10 tools in market.
Please assist me on this.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

the real question is what is your budget;

the top tools cost money, typically ~1000 per server, with discounts against more and more servers.

is your job going to shell out 100K for monitoring, or is there really just ten servers you REALLY need to monitor? or only 2?

WHAT do you need to monitor is the next piece of the puzzle; 100 servers, or 100 SQL servers?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

abostetxea Valued Member Points: 59 More actions · Answer 2

Hi Grasshopper,

In my experience, I would recommend Pandora FMS[/url]. This all-in-one monitoring solution is capable of server monitoring, network monitoring and APM as well.

Besides the Enterprise version, they also provide a Community editions to fit every budget.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

I don't think there are 10 decent tools in the market. Here are a few, in the order I'm recommending them:

Redgate SQL Monitor [/url](my employer)

SQL Sentry

Microsoft System Center

Solarwinds

Idera

Dell/Quest

That's what I see the overwhelming majority of people using in the production systems. Each of these has strengths and weaknesses, you'll want to evaluate them for your environment.

"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

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 4

I'm gonna make a pitch for Solarwinds DPA, formerly Confio Ignite. In terms of alerting, there are better tools, though you can make DPA do anything through some user defined jobs on a DBA database. But where DPA shines is its analysis of waits and server usage. I feel blind as a DBA now without it. There are very few times where I cannot find the root cause of a DB problem, if it is in fact a DB problem, within a few minutes through DPA analysis. It is the most useful DBA tool I have ever had in my arsenal.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

I'm mostly with Grant (same employeR), but I'd put the MS tool lower. PErhaps I'm wrong as I haven't used it in awhile, but it's more setup hassle, and admin hassle, IMHO.

Redgate, Solarwinds, SQL Sentry, try them all out. I think the Dell (formerly Quest) tools are heavy on the client, but maybe you don't care.

Is this SQL specific monitoring or general Windows servers?

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 6

cmc123 (4/25/2016)
Hi,
We have an estate of 120 Prod & DR Servers. We looking for efficient monitoring tool. we would like to know Top 10 tools in market.
Please assist me on this.

2 mins of search on this forum would you have got you many results. http://www.sqlservercentral.com/Forums/Topic1744971-2799-1.aspx#bm1745147