3rd Party Products for Monitoring SQL Server
-
Any one have experiences or recommendations for products to monitor SQL server health and availability?
We're currently looking at MOM from Microsoft but would like to contrast that against other vendors.
thks
-
Of course there are so many monitoring tools amnd it really depends on what is important to you. But I like the NetIQ tools a lot, even though most of my customers think they are too expensive. You can download a 30-day version at http://www.netiq.com/solutions/sql/default.asp
Another option is Quest Software which offer a range of tools for monitoring and administering databases. (http://www.quest.com)
M
[font="Verdana"]Markus Bohse[/font]
-
We use Embarcadero's products and like them a lot. We use DBArtisan with the Performance Analyst monitor for real time monitoring and use Performance Center (separate product) for 24 x 7 monitoring of the key systems. We have about 75 servers to look after and so far so good with these tools...
-
NetIQ all the way! We use it to monitor SQL Servers installations and also O/S level conditions. The whole enterprise uses this product.
-
MOM is NetIQ underneath. We use MOM here. I've use OpenView from HP alot in the past as well. Both do a good job monitoring and allowing you to run processes on recived errors to cut down the human cost. If you are looking at just SQL Servers I would also check out Idera's new products as well.
Wes
-
We happen to use SiteScope site-wide. It works OK, but isn't necessarily geared directly towards SQL Server. It's more of a general server/service monitor, although you can write any SQL you want and have it generate alerts based on what is returned.
Francis
-----------------
SQLRanger.com -
Hi Tom,
take a look at Quest's Spotlight® on SQL Server (at http://www.quest.com/spotlight_sql/). Free 30 days trial is also available for download from their web site.
P.S> P.S. visit our TechRepublic's SQL Server forum at http://myitforum.techtarget.com/forums/tt.asp?appid=73
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed" -
I use Idera's SQL Diagnostic Manager. It monitors performance, will notify you when performance dips and gathers statistics together nicely. The nicest thing is that it can read the trasaction log and will give you the worst performing SQL statements. I really like it. It has already made me look really good. If you download the evaluation version, you can try it out for 30 days and it will monitor up to 15 servers.
Let me know if you have any questions.
--Lori
-
Another one to check out is the "i3 for Sql Server" product from Veritas.
-
Try SQLCentric from Pearl Knowledge Solutions - an enterprise monitoring and alert solution - not at enterprise pricing. Find out what SQLCentric has offer here: http://www.pearlknows.com/id1.html
Also, check out our Forum on this site: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=352&messageid=333758
-
I've used Idera Diagnostic Manager for around 8 years, ( it was sql probe originally ) Beware of Spotlight products they can impose around 10% load when running, I've always figured Spotlight for when you really have severe problems, but often then spotlight only adds to the problem. If they could get the imapct to be less then the product would be quite good. I believe the Teratrax product is quite good, I have an early version I use for sql capture but I think th product has moved on some since.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply