August 19, 2014 at 11:10 am
What are some of the best SQL Server Monitoring Tools?
I want to be able to centrally manage all of my instances on all of my SQL Server Machines.
SQL Monitor by Red Gate? Ignite?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 19, 2014 at 11:19 am
Depends on what you wish to monitor.
Solarwinds Ignite is top dog for monitoring waits and associating queries to which waits.
SQL Sentry is very good, but has a bit of a learning curve.
Disclaimer - I don't work for either company.:-D
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
August 19, 2014 at 12:29 pm
This is such a subjective question. And there are tons and tons of recommendations out there if you search for them. My favorites:
[/url]
and SQL Sentry
For specialized performance tuning only, Solarwinds Ignite.
DISCLAIMER: I work for Red Gate
"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
August 19, 2014 at 12:45 pm
Thanks for the recommendations.
When I attempt to install Ignite I get an error that the Wizard was interrupted before Ignite could be installed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 19, 2014 at 1:05 pm
I use SQL Sentry and really like it. I know I don't use it to its full capability, but it gives me what I need.
August 19, 2014 at 3:42 pm
Welsh Corgi (8/19/2014)
Thanks for the recommendations.When I attempt to install Ignite I get an error that the Wizard was interrupted before Ignite could be installed.
I've installed it three times without issue. If you're having problems, I'd suggest going to their support site.
"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
August 20, 2014 at 4:49 am
It might not be for the OP requirements but do remember SQL (from 2008 onwards) comes with it's own (FREE) Data Collector which generates basic, but quite insightful reports.
Also tons of t-sql based monitoring scripts out there.
qh
August 20, 2014 at 7:43 am
quackhandle1975 (8/20/2014)
It might not be for the OP requirements but do remember SQL (from 2008 onwards) comes with it's own (FREE) Data Collector which generates basic, but quite insightful reports.Also tons of t-sql based monitoring scripts out there.
qh
One can also create custom data collectors should they wish.:cool:
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
August 20, 2014 at 8:08 am
SQLRNNR (8/20/2014)
quackhandle1975 (8/20/2014)
It might not be for the OP requirements but do remember SQL (from 2008 onwards) comes with it's own (FREE) Data Collector which generates basic, but quite insightful reports.Also tons of t-sql based monitoring scripts out there.
qh
One can also create custom data collectors should they wish.:cool:
Cheers, I may have a look at playing with that, I've always been happy with the three that are provided.
qh
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply