Welcome to Management Pack Wiki! Your documentation pro for SCOM Management Packs
0 comment(s) Post a comment
  • Management Pack:  SQL Server
  • MP Version:  6.6.2.0 for SQL Server 2008
  • Released:  10/15/2015
  • Publisher:  Microsoft

Overview

Feature Summary: The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details. New features and fixes: Added a support for disabled TCP/IP protocol Fixed performance metrics error that may occur on some localized versions of Windows Fixed bugs in monitor tiles on SQL Server Summary Dashboard Fixed incorrect performance of Transaction log free space monitor Added new type of events from failed discoveries; added a new rule that collects such events Added overrides to prevent various scripts timeout failure Removed some 1X1 tiles from Summary Dashboards Filestream filegroups are excluded from discovery for now 2008/2012 Summary Dashboards tiles were reorganized Features: Monitors and Rules – only for SQL 2008 and SQL 2012 Collect DB Active Connections count Collect DB Active Requests count Collect DB Active Sessions count Collect DB Active Transactions count Collect DB Engine Thread count Thread Count monitor Transaction Log Free Space (%) monitor Transaction Log Free Space (%) collection Collect DB Engine CPU Utilization (%) CPU Utilization (%) monitor for DB engine Buffer Cache Hit Ratio monitor Collect DB Engine Page Life Expectancy (s) Page Life Expectancy monitor Collect DB Disk Read Latency (ms) Collect DB Disk Write Latency (ms) Disk Read Latency monitor Disk Write Latency monitor Collect DB Transactions per second count Collect DB Engine Average Wait Time (ms) Average Wait Time monitor Collect DB Engine Stolen Server Memory (MB) Stolen Server Memory monitor Collect DB Allocated Free Space (MB) Collect DB Used Space (MB) Collect DB Disk Free Space (MB) SQL Re-Compilation monitor Run As configuration changes to support Low privilege for SQL Server 2012 Cluster AlwaysOn Monitoring Automatically discover and monitor availability groups, availability replicas, and availability databases for hundreds of computers. Health roll-up from availability database to availability replicas. Detailed knowledge with every critical health state to enable faster resolution to a problem. Seamless integration with Policy based management (PBM) Auto-discover custom PBM polices targeting AlwaysOn and database components. Rollup of health of policy execution within the SQL monitoring pack under extended health. Support for Replication Monitoring (applicable to SQL Server 2008 version of management pack only) Approximately twenty rules to detect replication events. Support for Mirroring Monitoring (applicable to SQL Server 2008 and 2012 versions of management pack only) Discover mirroring databases, witness, and mirroring group. Monitor database mirror state, database mirror witness state, and mirroring partners’ state. Custom diagram view to represent the primary and the mirrored databases visually. Improved Freespace monitoring with mount point support Support for Enterprise, Standard and Express editions of SQL Server 2005, 2008, 2008 R2, and 2012 and 32bit, 64bit and ia64 architectures. Support for both simple and complex SQL Server configurations such as clustered installations, multiple instances and 32bit roles running on a 64bit OS. For details regarding the supported configurations refer to the guide included with the management pack. Discovery and monitoring of SQL Server roles such as DB Engine, Reporting Services, Analysis Services, Integrations Services. Discovery of SQL Server components such as databases, the SQL Agent and SQL jobs. Views covering such areas as database free space, SQL Server related performance, SQL Server related alerts, and lists of the various SQL Server roles, and the discovered components along with their related state. Discovery and basic monitoring for SQL Server Reporting Services and Integration Services. Reports for longer-term analysis of common problem areas related to SQL Server such as SQL Server lock analysis and top deadlocked databases, SQL Server service pack levels across discovered roles, user connection activity. Likewise the generic reports from Microsoft Generic Report Library can be used against the roles and components discovered by SQL MPs to review availability and performance across many systems and over longer periods of time. Role and component specific tasks, which provide access to common tools, triage information, or corrective actions without need to leave the Operations Console in most cases. Databases monitoring covers database status, database free space, log shipping monitoring for both the source and destination, and transaction log free space. Monitoring of key SQL Server related services. Monitoring for persistent SPID blocking. Monitoring of numerous SQL Server events and performance data points. Alerts bring the issue to your attention and provide knowledge on the impact and possible resolutions. A low-privilege configuration for discovery and monitoring that eliminates the need for SQL Server sysadmin, dbo, db_owner, and box admin privileges
Login
An installation of a Microsoft SQL Server 2008 Database Engine.  The database engine hosts databases and other SQL Server components. Microsoft SQL Server 2008 database Microsoft SQL Server 2008 agent component An installation of Microsoft SQL Server 2008 Reporting Services An installation of Microsoft SQL Server 2008 Analysis Services An installation of Microsoft SQL Server 2008 Integration Services Microsoft SQL Server 2008 database file group Microsoft SQL Server 2008 database file Microsoft SQL Server 2008 database log file All Microsoft SQL Server 2008 distributors.  The distributor is a component used in SQL Server Replication. All Microsoft SQL Server 2008 agent jobs. A group containing all Windows computers that are running a component of Microsoft SQL Server A group containing all Windows computers that are running a component of Microsoft SQL Server 2008. This group contains all Windows computers that are running a component of Microsoft SQL Server A group containing all Windows computers running Microsoft SQL Server 2008 involved in replication Defines the basic properties of computers running Windows operating systems An installation of any version of Microsoft SQL Server Database Engine Analysis Services Database Group contains all SQL Server root objects such as Analysis Services instance. Analysis Services Server Roles Group contains all SQL Server root objects such as Analysis Services instance. A group containing Azure SQL Cloud Services A group containing Azure SQL Database Cloud Services A group containing all Always On High Availability groups of Microsoft SQL Server 2012 A group containing all Availability Groups of Microsoft SQL Server 2012 A group containing all Availability Replicas of Microsoft SQL Server 2012 A group containing all Database Replicas of Microsoft SQL Server 2012 Replication Database Health Group is group of Replication Database Health objects Server Roles Group contains all SQL Server root objects such as Database Engine, Analysis Services instance or Reporting Service instance. Microsoft SQL Server 2008 Mirroring Service A group containing all components related to Microsoft SQL Server A group containing all instances of Microsoft SQL Server A group containing all SQL Server 2008 agents A group containing all SQL Server 2008 databases A group containing all instances of Microsoft SQL Server 2008 database engines A group containing all SQL Server 2008 DB Engine Instances A group containing all SQL Server 2008 Integration Services A group containing all SQL Server 2008 Mirroring groups A group containing all instances of Microsoft SQL Server 2008 R2 database engines A group containing all SQL Server 2012 agents A group containing all SQL Server 2012 databases A group containing all SQL Server 2012 DB Engine Instances A group containing all SQL Server 2012 Integration Services A group containing all SQL Server 2012 Mirroring groups SQL Server Agents SQL Server Alerts Scope Group contains SQL Server objects which can throw alerts. This object is used to collect alerts. This group contains Microsoft SQL Server Always On Availability components This group contains Microsoft SQL Server Always On Availability Replica components This group contains Microsoft SQL Server Always On Database Replicas components This group contains Microsoft SQL Server Always On Availability components SQL Server Analysis Services Alerts Scope Group contains SQL Server Analysis Services objects which can throw alerts. SQL Server Databases This group containing all instances of Microsoft SQL Server database engines This group containing all instances of Microsoft SQL Server Integration Services This group contains Microsoft SQL Server Mirroring components This group contains Microsoft SQL Server Mirroring groups This object discovery populates the SQL Server Analysis Services Group with all components that relate to Analysis Services. This object discovery populates the Local Deployment group to contain all SQL Server Reporting Services Roles. This object discovery populates the Local Instance group to contain all SQL Server Reporting Services Roles. It is a seed for Microsoft SQL Server 2008 installation. This object indicates that the particular server computer contains Microsoft SQL Server 2008 installation. This object is used to collect errors from event log of computers that have SQL Server components. All Microsoft SQL Server 2008 subscribers.  The subscriber is a component used in SQL Server replication. All Microsoft SQL Server 2008 replication publications. All Microsoft SQL Server 2008 publishers.  The publisher is a component used in SQL Server Replication. All Microsoft SQL Server 2008 replication subscriptions. All Microsoft SQL Server databases regardless of the version Microsoft SQL Server 2008 Mirrored Database Microsoft SQL Server 2008 Database Mirroring Witness Role. Microsoft SQL Server 2008 Mirrored Database Witness Microsoft SQL Server 2008 Mirroring Group

Download diagram as a Visio file

Compare with Other Versions of This Management Pack

  • 6.3.173.1 for SQL Server 2008
  • 6.7.20.0 for SQL Server 2008
  • 6.3.173.0 for SQL Server 2008
  • 6.1 for SQL Server 2008
  • 6.6.0.0 for SQL Server 2008
  • 6.7.7.0 for SQL Server 2008
  • See Also for SQL Server Management Pack


    Downloads for SQL Server Management Pack

    Post a comment
    Comments to other elements of this Management Pack:
    Article Message Posted By
    Overview
    We are providing a platform for those who want to join this profession.
    writing jobs
    jobs
    shahid.afraid111@gmail.com at 10/29/2014 11:48:42 AM
    Overview
    Is Management Pack inventory available for SQL Server 2012 MP version 6.5.1.0?
    milmanfm@gmail.com at 9/23/2014 11:36:42 AM
    Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQ
    Due to over storage of SQL database files the memory allocation refuses and creates some errors which are responsible for SQL database inaccessibility. You must go through this to learn more about resolving solutions:- http://www.sqlrecoverysoftware.net/blog/sql-error-926-and-945.html
    enriquemallon@gmail.com at 6/28/2014 10:10:17 AM
    Database consistency errors found
    I recommend you to read this article which serve you how get rid of this consistency error:- http://www.sqlrecoverysoftware.net/blog/fix-database-consistency-errors.html
    elliswhite43@gmail.com at 5/10/2014 11:06:07 AM
    Overview shantal@list.ru at 7/2/2013 11:57:28 AM
    Overview
    Where can i get the Management pack Inventory for SQL 2008
    vivakhangloo@gmail.com at 4/4/2013 8:32:16 AM
    Overview
    According to the Pinpoint catalog, the SQL MP was updated to include SQL 2012 monitoring as of 4/2/2012. Do you have an ETA for when this MPwiki entry will be updated? Keep up the great work; thanks!
    bdady@denaliai.com at 5/30/2012 2:47:22 PM
    DB File Space
    You should keep in mind that file-level monitoring works rather good now but in case of extremely loaded server (e.g. which works all the time about 99% of CPU) or you have really huge number of DBs and files (e.g. 500 databases consist of 1000-2000 files) - you should think about Database-level space monitoring.
    legolasishe@mail.ru at 3/21/2012 1:39:09 PM
    Overview shantal@list.ru at 11/4/2011 3:29:24 PM
    Overview igrudina@viacode.com at 10/26/2011 4:12:53 PM