• Management Pack:  SQL Server 2016
  • MP Version:  7.0.7.0
  • Released:  10/16/2018
  • Publisher:  Microsoft

Overview

 
Login
This object represents Availability Database object. A hidden object, which is used to roll up the health from agents to availability database level. This object represents Availability Group SMO object and contains all properties required for identification and monitoring. A hidden object, which is used to roll up the health from agents to availability group level. This object represents Availability Replica SMO object and contains all properties required for identification and monitoring. This is representation of Database Replica State SMO object Custom User Policy which has Availability Group as Facet and one of the error categories as Policy Category. Custom User Policy which has Availability Group as Facet and one of the warning categories as Policy Category. Custom User Policy which has Availability Replica as Facet and one of the error categories as Policy Category. Custom User Policy which has Availability Replica as Facet and one of the warning categories as Policy Category. Custom User Policy which has Database Replica State as Facet and one of the error categories as Policy Category. Custom User Policy which has Database Replica State as Facet and one of the warning categories as Policy Category. 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 A group containing all Windows computers that are running a component of Microsoft SQL Server 2016. This group contains all Windows computers that are running a component of Microsoft SQL Server Defines the basic properties of computers running Windows operating systems This object indicates that the particular server computer contains Microsoft SQL Server 2016 installation with some Always On components enabled. 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 This object is used to collect alerts. A group containing all SQL Server 2016 Always On High Availability related objects and groups 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 2016 Mirroring Service A group containing all agents of Microsoft SQL Server 2016 database engines A group containing all SQL Server 2016 agents A group containing all components related to Microsoft SQL Server A group containing all databases of Microsoft SQL Server 2016 database engines A group containing all SQL Server 2016 databases A group containing all instances of Microsoft SQL Server 2016 database engines A group containing Microsoft SQL Server 2016 DB Engines With Many DBs A group containing all SQL Server 2016 DB Engine Instances The group contains all SQL Server 2016 resource pools supported Memory-Optimized Data feature. SQL Server 2016 Memory-Optimized Data Scope Group contains all SQL Server Memory-Optimized Data objects such as Memory-Optimized Data Filegroups, Containers and Resource Pools. A group containing all SQL Server 2016 Mirroring groups SQL Server Alerts Scope Group contains SQL Server objects which can throw alerts. 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. This group containing all instances of Microsoft SQL Server database engines A group containing all instances of Microsoft SQL Server Express 2016 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. The group contains all SQL Server 2016 resource pools This object is used to collect errors from event log of computers that have SQL Server 2016 components. It is a seed for Microsoft SQL Server 2016 installation. This object indicates that the particular server computer contains Microsoft SQL Server 2016 installation. It is a seed for Microsoft SQL Server 2016 Integration Services installation. This object indicates that the particular server computer contains Microsoft SQL Server 2016 Integration Services installation. SQL Server 2016 Internal Resource Pool A group containing all instances of Microsoft SQL Server 2016 database engines supporting Memory-Optimized Data feature. This group is considered to be obsolete in this Management Pack. A group containing a part of databases of a particular Microsoft SQL Server 2016 DB engine Microsoft SQL Server 2016 FILESTREAM Filegroup SQL Server 2016 Default Resource Pool SQL Server 2016 User-Defined Resource Pool Microsoft SQL Server 2016 Database Memory-Optimized Data Filegroup An installation of a Microsoft SQL Server 2016 Database Engine. The database engine hosts databases and other SQL Server components. Microsoft SQL Server 2016 Database The SQL Server 2016 Agent component that runs as part of a Microsoft SQL Server 2016 Database Engine All Microsoft SQL Server 2016 agent jobs. Microsoft SQL Server 2016 database Filegroup Microsoft SQL Server 2016 Database Memory-Optimized Data Filegroup container Microsoft SQL Server 2016 database file Microsoft SQL Server 2016 database transaction log file Custom User Policy, which has a Database as the Facet and one of the error categories as Policy Category. Custom User Policy, which has a Database as the Facet and one of the warning categories as Policy Category. A group containing all Availability Groups of Microsoft SQL Server 2016 A group containing all Availability Replicas of Microsoft SQL Server 2016 A group containing all Database Replicas of Microsoft SQL Server 2016 An installation of Microsoft SQL Server 2016 Integration Services Microsoft SQL Server 2016 Mirrored Database Microsoft SQL Server 2016 Database Mirroring Witness Role. Microsoft SQL Server 2016 Mirrored Database Witness Microsoft SQL Server 2016 Mirroring Group

Download diagram as a Visio file

Compare with Other Versions of This Management Pack

  • 7.0.4.0
  • 6.7.20.0
  • 7.0.2.0
  • 6.7.7.0
  • 7.0.0.0

    • See Also for SQL Server 2016 Management Pack


    Downloads for SQL Server 2016 Management Pack

    Back to top
    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