January 13, 2009 at 7:52 am
Hi,
Can anyone recommend a good tool or monitoring software that can monitor SQL Server infrastructure (abt 100+ servers globally). Just something to quickly identify SQL Server and resource areas where performance degradation originates like blocking locks, deadlocking, failed index maintenance etc.
Thanks,
Chrno
January 13, 2009 at 8:54 am
There are many tools available from places like Idera, Quest, Red-Gate, Precise, etc. Many of these tools can be really overwhelming. I have found that the Red-Gate tool seems to be the most configurable when it comes to these types of alerts and the least offensive but I don't use any of them either, just tested them all.
There is the option of setting up scripts to run on these servers and reporting back for your alerting as well. Homegrown will always fit your needs best. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 13, 2009 at 8:59 am
Red Gate offers a tool that does a bare-bones, is it up or does it have a problem type of monitoring. Idera has a pretty good tool that does what the Red Gate tool does and collects performance metrics. Having the collected metrics allows for more reporting and detailed long-term performance tuning.
To say the least, the Red Gate tool is less expensive.
"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
January 13, 2009 at 10:01 am
If you have the money there's Quest too.
January 13, 2009 at 10:11 am
And, SQL Server 2008 has a monitoring suite built in, although it's not as sophisticated as the offerings from Quest & Idera and others.
"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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply