Monitor SQL Server 2008 with OpsMgr

摘要

Many things cause poor response time: networking issues, lock contention, online backups, page splits caused by insert or update activity, replication volume, improperly designed databases, or (imagine!) poorly written applications. The defaults in the current release of the SQL Server management pack are now one hour (OI 0000) and two hours (020000), with updated knowledge regarding the thresholds. * SQL Server 2008 and 2005 include this per-job functionality, disabled by default, with thresholds in minutes. * SQL Server 2008 and 2005 also have per-SQL Server agent monitoring for SQL Server jobs. The DBA's Monitoring Tool OpsMgr monitors pretty much the same things that DBAs monitor for SQL Server performance: memory usage, disk I/O, CPU utilization, latency (network saturation), backups, and key indicators. [...] OpsMgr puts it all, along with reports, in one convenient tool.