April 4, 2011 at 9:38 am
Is there a good SQL server monitoring tool on the market and in affordable price?
April 4, 2011 at 10:05 am
You could try Red Gate's SQL Monitor:
http://www.red-gate.com/products/dba/sql-monitor/
-- Gianluca Sartori
April 4, 2011 at 10:11 am
Reinforcing what Gianluca said, Red Gate's SQL Monitor really is an excellent choice for monitoring servers and the price is very reasonable. If you want to, you can actually play with it before you buy it. We're using it to monitor SQL Server Central, so you can see what it does and how it works on a live system. Just click here[/url].
"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 4, 2011 at 10:29 am
I think you could do worse than look at Idera SQL Diagnostic Manager.
It has plenty features that I find very useful.
You’d need to check out the product yourself to see whether they’d be useful to you in your environment though.
Whether it’s affordable I guess depends on your budget.
April 4, 2011 at 11:14 am
If you have a windows administration team, you should inquire if they are using SCOM to monitor the windows environment. If they are, you can ask them to install the SQL Server managment pack.
April 4, 2011 at 12:48 pm
If you don't have a lot of time to dedicate to monitoring, another one to consider is LogicMonitor. It's pre-configured to monitor most critical metrics out of the box so you don't have to know what needs to be monitored or how to configure. It's a hosted application with a monthly subscription price of about $10/month per host.
April 4, 2011 at 12:49 pm
There is another tool that is useful - Confio Ignite.
For more stuff, I have a list here that you can look into.
http://jasonbrimhall.info/2011/03/18/database-tools-follow-up/
And the first part of that article is here.
http://jasonbrimhall.info/2011/03/17/database-tools/
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
April 5, 2011 at 1:16 am
kstjacques (4/4/2011)
If you have a windows administration team, you should inquire if they are using SCOM to monitor the windows environment. If they are, you can ask them to install the SQL Server managment pack.
This is what we are using here, but I would not recommend it. SCOM is a general purpose monitoring tool, it doesn't fit well with SQL Server IMHO.
It's not under my responsibility and I cannot configure it because it's under the umbrella of the systems/networking guys and they don't want me to mess with "their" stuff. It's another thing to take into account.
-- Gianluca Sartori
April 5, 2011 at 2:03 am
Is there any free tool but good also?:hehe:
Thanks
April 5, 2011 at 2:20 am
forsqlserver (4/5/2011)
Is there any free tool but good also?:hehe:
There's always Nagios. With some plugins you can monitor the most important metrics: http://labs.consol.de/lang/en/nagios/check_mssql_health/
Very far from paid products, anyway.
-- Gianluca Sartori
April 5, 2011 at 2:22 am
There's also Idera SQL Check: http://www.idera.com/Products/Free-Tools/SQL-check/
-- Gianluca Sartori
April 5, 2011 at 2:24 am
Another one: http://www.spiceworks.com/free-sql-server-monitoring-tool/
-- Gianluca Sartori
April 5, 2011 at 2:41 am
good SQL server monitoring tool and in affordable price?
as you have raised this query in sql 2008 forum, I beleive you using sql server 2008.
So I will suggest start with activity monitor which is in-built within SSMS and then you can analyse what else is missing there which you think is benefecial in terms of prompt monitoring.
----------
Ashish
April 5, 2011 at 5:13 am
Gianluca Sartori (4/5/2011)
kstjacques (4/4/2011)
If you have a windows administration team, you should inquire if they are using SCOM to monitor the windows environment. If they are, you can ask them to install the SQL Server managment pack.This is what we are using here, but I would not recommend it. SCOM is a general purpose monitoring tool, it doesn't fit well with SQL Server IMHO.
It's not under my responsibility and I cannot configure it because it's under the umbrella of the systems/networking guys and they don't want me to mess with "their" stuff. It's another thing to take into account.
I was able to work with SCOM at my previous employer. It's very good, but it's very good at the big, broad stuff of managing an enterprise. It breaks down a bit when you start trying to monitor what's happening within SQL Server. That's why we used a second monitoring software in addition to SCOM. You can use another tool, like Red Gate SQL Monitor, to augment your SCOM system, but I don't think either replaces the other.
"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 5, 2011 at 5:15 am
forsqlserver (4/5/2011)
Is there any free tool but good also?:hehe:
Yes.
Performance Monitor comes free with every instance of windows. You can combine that with the Dynamic Management Objects within SQL Server and a server-side trace. That will give you every bit of information you need. You can use the alerts from SQL Agent to send you emails or instant messages, and you're all set. That's at no cost, at all.
"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
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply