• Management Pack:  SQL Server 2008
  • MP Version:  6.7.20.0
  • Released:  3/14/2017
  • 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. Discovery and monitoring of SQL Server 2008, 2008 R2 and 2012 roles like DB Engine, Integrations Services. Discovery of SQL Server 2008, 2008 R2 and 2012 components: Databases, SQL Agent and SQL jobs. Monitoring of SQL Server 2012 Always On: Automatic discovery and monitoring of availability groups, availability replicas, and availability databases. Health roll-up from availability database to availability replicas. Detailed knowledge for each related monitoring workflow. Seamless integration with SQL Server policy based management (PBM): Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components. Rollup of policy execution health to the health of related SCOM entity. Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM. Support of Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012 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.
Login
An installation of 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 Filegroup 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; it is considered to be obsolete in this Management Pack. 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 the replication. Considered to be obsolete in this Management Pack. 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 instances of Microsoft SQL Server 2008 WOW64 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 A group containing all instances of Microsoft SQL Server Express 2008 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; it is considered to be obsolete in this Management Pack. All Microsoft SQL Server 2008 replication publications. Considered to be obsolete in this Management Pack. All Microsoft SQL Server 2008 publishers.  The publisher is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. All Microsoft SQL Server 2008 replication subscriptions. Considered to be obsolete in this Management Pack. 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.6.2.0
  • 7.0.4.0
  • 7.0.0.0
  • 6.7.7.0
  • 6.3.173.0
  • 6.6.0.0
  • See Also for SQL Server 2008 Management Pack


    Downloads for SQL Server 2008 Management Pack

    AZURE OPTIMIZATION ASSESSMENT GET STARTED
    MIGRATION TO AZURE GET STARTED
    SYSTEM CENTER MIGRATION TO AZURE GET STARTED
    MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED