SQL Server监控检查清单

精选转载

lzf328 2014-07-10 15:55:06 博主文章分类：SQL SERVER

检查一下你的SQLServer是不是很好的被监控了。原文网址： http://bradmcgehee.com/2010/08/27/sql-server-monitoring-checklist-2/

这一段时间我一直在忙我的检查清单系列博客，最终会变成一本书。这次检查列表关注的是你想要监控的SQL Server实例，确保他们能够正常工作。

跟我之前的检查清单不同，这次的清单询问你是否监控了SQL Server实例的特定方面，如果你已经监控了，你是如何监控的，监控频率。我的目的不是建议你应该监控，应该如何监控或者多久监控，只是让你开始思考什么东西应该定期的监控。在清单的最后，我提供了一些常见的方法你可以考虑监控SQL Server实例不同的方面。

与所有清单一样，这次不打算覆盖100%监控的事情，只包括一些关键的。清单上的一些可能并不适合你，或者可能使用但是你不在乎，或者对你使用你也关注。

下面是我的当前SQL Server监控清单列表，这是一个电子表格形式，不光可以用来收集和存储信息，还可以被数据库管理员定制满足他们独特的环境。

Hardware Monitoring	Yes/No	How	How Often
Is Physical Hardware Monitored:
Is I/O Subsystem (DAS, SAN) Monitored:
Is Free Disk Space % Monitored:
Is Physical Disk Fragmentation Monitored:

Overall Server Performance	Yes/No	How	How Often
Is CPU Utilization Monitored:
Is Memory Utilization Monitored:
Is I/O Utilization Monitored:
Is Network Utilization Monitored:

High Availability	Yes/No	How	How Often
Is Clustering Monitored:
Is Database Mirroring Monitored:
Is Log Shipping Monitored:
Are Backups Monitored:
Are Offsite Backups Monitored:

Operating System Monitoring	Yes/No	How	How Often
Are OS Events Monitored:
Are Hardware Event Logs Monitored:
Are System Logs Monitored:
Are Application Logs Monitored:
Are Security Audit Failures Monitored:
Are Other Windows Logs Monitored:
Is Virtualization Monitored:

SQL Server Instance Monitoring	Yes/No	How	How Often
Is SQL Server Connectivity Monitored:
Is the SQL Server Service Monitored:
Is the SQL Server Agent Service Monitored:
Is the Analysis Services Service Monitored:
Is the Reporting Services Service Monitored:
Is the SSIS Service Monitored:
Is the Service Broker Service Monitored:
Is the Full-Text Search Service Monitored:
Are SQL Server Agent Jobs Monitored:
Are SQL Server Alerts Monitored:
Is the Database Mail Log Monitored:
Is the SQL Server Log Monitored
Is the SQL Server Agent Log Monitored:
Are Policy Violations Monitored:
Are SQL Audit Events Monitored:
Is Resource Governor Monitored:
Is the Default Trace Monitored:

Database Monitoring	Yes/No	How	How Often
Is Database Status Monitored:
Are MDF and LDF Sizes Monitored:
Is tempdb Size and Performance Monitored:
Is Blocking Monitored:
Are Deadlocks Monitored:
Is Query Performance Monitored:
Are Indexing Needs Monitored:
Is Database Corruption Monitored:
Is Replication Monitored:

Documentation	Yes/No	How	How Often
Is Server Documentation Monitored:
Is the Disaster Recovery Documentation Monitored:

Microsoft SQL Server Monitoring Tools Used	Yes/No	How
SQL Server Configuration Manager:
SSMS Reports:
SSMS Activity Monitor:
SQL Server Alerts:
OS Alerts:
Performance Monitor:
Profiler/SQL Trace:
SQL Server 2005 Performance Dashboard:
SQL Server 2008 Data Collector:
SQL Audit:
SQL Server 2008 Best Practices Analyzer
RML Utilities:
PAL:
Extended Events:
DMVs & Custom T-SQL:
Custom PowerShell Scripts:

Other Monitoring Tools Used	Yes/No	How
List Any Third-Party Monitoring Tools: