November 21, 2013 at 5:24 am
What is the best 3rd party tool for monmitoring a large SQL estate.
November 22, 2013 at 5:57 am
What are your requirements? Monitoring only, monitoring and alerting, do you just want only SQL Metrics, or do you want OS metrics as well?
MCITP SQL 2005, MCSA SQL 2012
November 22, 2013 at 6:00 am
For monitoring, we use SQL Sentry. It was recommended by Tim Ford at a presentation I attended and can handle large enterprises.
November 28, 2013 at 8:59 am
Thanks,
Errors beyond severity (X),
Disk Space.
Blocks
Growth Trends
Failed Access.
Performance Thresholds.
Failed Jobs.
Changes made by Sysadmins.
General DBA STUFF.
November 29, 2013 at 4:55 am
My experience has been that no monitoring tool has offered the bespoke solution we have needed for each and every scenario.
Every issue you listed is easily captured without the need for a 3rd party tool, and we do so plus more with a inhouse developed solution using a mixture of SSIS, SQL Alerts, powershell and SQL Agent jobs. This covers our entire SQL estate covering 500+ servers in 6 locations worldwide.
You have to weigh up the development cost of comming up with you own solution to the initial purchase cost and on going licencing and support costs of a monitoring and alerting system.
MCITP SQL 2005, MCSA SQL 2012
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply