Monitoring tool

Question

Post reply

Monitoring tool

Eliyahu

Ten Centuries

Points: 1071
More actions
July 9, 2012 at 5:57 am

#258572

I am looking for a monitoring tool that would allow looking in the history data to detect long ineffective queries.
I have some experience with Confio Ignite. I liked the tools but their price of $1,800 for a single server looked too high to me. After looking into similar products I see they cost even more. Is there something in the below $1,000 range?

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

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

Ant-Green SSC Guru Points: 113499 More actions · Answer 1

Top 5 off the top of my head are

Red-Gate SQL Monitor

Idera Diagnostic Manager

Quest Spotlight

Quest Foglight

SQLSentry

All are differently priced and all have their similarities and differences, I would recommned downloading the trials and see which one you like, which ones do what you want, and which come in within budget.

Lowell SSC Guru Points: 323518 More actions · Answer 2

also take a look at the two articles here on SQL Server Central;

they list a lot of free tools, some of which are related to monitoring:

Free Tools for the SQL Server DBA (from 2007!)[/url]

Free Tools for the SQL Server DBA Part 2[/url]

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!

Eliyahu Ten Centuries Points: 1071 More actions · Answer 3

Thanks.

I think we need a serious tool. Anyone has any opinion on Confio Ignite?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Confio Ignite is an excellent tool. IMHO - best tool out there for monitoring wait stats.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sfallen SSC Veteran Points: 293 More actions · Answer 5

In the interest of full disclosure, I am a member of the technical team at SQL Sentry.

Anthony.green hit all of the major players in the market other than Confio. His advice of evaluating them all is sound. While all of the tools on the market have similar goals of making monitoring easier, enabling historical analysis, and generally making the user of the tool more efficient, the approaches vary greatly.

You will see differences in interface and presentation of the data, detail of the data collected, depth of analysis available within the tool for problem queries, ease of correlation, quality of support, frequency of product updates, and overhead on the servers you are monitoring just to name a few. Most if not all vendors also offer online demonstrations of their tools, which can be a great way to get a quick overview of the features as you start an evaluation.