July 20, 2010 at 7:56 am
Anybody have any software that they recommend for monitoring the health of SQL Server. I've been playing with the trial of the Quest one, but I was looking for some other options. Thanks.
July 20, 2010 at 8:53 am
System Center Operations manager (SCOM) will be best choice to
monitor both windows and SQL Server. We can install the custom dashboard
will give nice Reports.
Regards
Hema.,
Regards
Hema.,
July 20, 2010 at 9:26 am
We use both SCOM and Idera's Diagnostic Manager. They monitor different stuff in different ways.
"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
July 27, 2010 at 2:24 am
Red Gate also have a SQL Server-specific tool, SQL Response, designed to monitor and alert on SQL Server instances. V1 is currently available and we're working on v2 at the moment - you can try an early access version of v2 at:
http://www.red-gate.com/products/sql_response_eap/index.htm
The current v1 release is available from:
July 27, 2010 at 9:37 am
Depends on what you are doing.
Red Gate (my employer) has done a lot of work and SQL Response 2 looks like
SQL Sentry has a performance tool that you can use
Quest has tools as well
Many monitoring packages (What's Up, Openview) will monitor servers and the SQL Server counters are visible.
# servers, budget, etc. will help you determine what to do. If you have Enterprise Edition, management Data warehouse comes with it, though you might want a dedicated server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply