February 24, 2012 at 1:15 pm
I want to minitor SQL Servers (2000/2005/2008). The the sql servers are NOT in the same Network, Some of them are in differet part of the world. When I need to look into any sql issues, i remote to the server and look for issues. I do not remoting into indivual server every time. Is there any tool kind of dashbord, so that i monitor them at one spot. Pl advise. Thanks for help.
February 24, 2012 at 1:39 pm
Idera Diagnostic Manager has a nice dashboard for viewing multiple servers, and can collect information all the time, not just when you look at it.
It works with all the versions of SQL Server you mentioned.
SQL diagnostic manager v7.1
SQL Server performance monitoring, alerting & diagnostics
February 24, 2012 at 2:12 pm
DbTuna is a decent tool
Confio Ignite is a good tool
Some like Spotlight from Quest as well.
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
February 24, 2012 at 2:29 pm
Our hosts here Red-Gate have SQL Monitor.. Which I use and like.
CEWII
February 27, 2012 at 6:26 am
i tried Indra freed tool, the tool shows only the servers in local NETWORK. How to add a database server that is not in the same network? pl help.
February 27, 2012 at 6:48 am
you have to allow the other servers internet connectivity
we have DEV/TEST servers here in the UK locally and PROD servers in the US managed by a 3rd party.
I'm a fan of Spotlight so in order for this to work I had to either install Spotlight in the US and UK, or get the US servers to communicate over the internet as they dont touch our LAN.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply