SQL Serverj监控检查清单

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

 

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

 

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

 

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

 

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

 

Hardware MonitoringYes/NoHowHow OftenIs Physical Hardware Monitored:   Is I/O Subsystem (DAS, SAN) Monitored:   Is Free Disk Space % Monitored:   Is Physical Disk Fragmentation Monitored:       Overall Server PerformanceYes/NoHowHow OftenIs CPU Utilization Monitored:   Is Memory Utilization Monitored:   Is I/O Utilization Monitored:   Is Network Utilization Monitored:       High AvailabilityYes/NoHowHow OftenIs Clustering Monitored:   Is Database Mirroring Monitored:   Is Log Shipping Monitored:   Are Backups Monitored:   Are Offsite Backups Monitored:       Operating System MonitoringYes/NoHowHow OftenAre 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 MonitoringYes/NoHowHow OftenIs 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 MonitoringYes/NoHowHow OftenIs 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:       DocumentationYes/NoHowHow OftenIs Server Documentation Monitored:   Is the Disaster Recovery Documentation Monitored:       Microsoft SQL Server Monitoring Tools UsedYes/NoHow 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 UsedYes/NoHow List Any Third-Party Monitoring Tools:   

 

希望你能够在我的列表中填写一些东西，比如，我希望你能够输入：

 

·         列表中缺少什么？SQL Server需要定期监控的其他方面。记住我不能够包含所有的情况。

·         列表中有什么不重要的是可以移除的？ 记住列表被设计为通用的，可能有项目不适合所有的SQL Server环境

·         我的措辞是否明确，我是否需要修改我的措辞，这样就更容易理解和准确？我是否需要修改一些类别或者移动一些项目到其他类别？