This Management Pack contains views and folder structure for Microsoft SQL Server 2016 management packs.
| DisplayName | ID | Base Class | Abstract | Hosted | Singleton | Group | Extension | Accessibility | |
|---|---|---|---|---|---|---|---|---|---|
 | SQL Server 2016 Agents Group | Microsoft.SQLServer.2016.AgentsGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2016: Alerts Scope Group L3 | Microsoft.SQLServer.2016.AlertsScopeGroupL3 | System.Group | False | False | True | True | False | Public |
| MSSQL 2016: Group of High Availability Groups | Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailability | System.Group | False | False | True | True | False | Public |
| MSSQL 2016: Group of Availability Groups | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2016: Group of Availability Replicas | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2016: Group of Database Replicas | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup | System.Group | False | False | True | True | False | Public |
| SQL Server 2016 Databases Group | Microsoft.SQLServer.2016.DatabasesGroup | System.Group | False | False | True | True | False | Public |
| SQL Server 2016 Instance Group | Microsoft.SQLServer.2016.InstancesGroup | System.Group | False | False | True | True | False | Public |
| SQL Server 2016 Mirroring Groups Group | Microsoft.SQLServer.2016.MirroringGroupsGroup | System.Group | False | False | True | True | False | Public |
| DisplayName | ID | Source | Target | Accessibility | Abstract | |
|---|---|---|---|---|---|---|
 | SQL Server 2016 Agents Group Contains Agent | Microsoft.SQLServer.2016.AgentsGroupContainsAgent | Microsoft.SQLServer.2016.AgentsGroup | Microsoft.SQLServer.2016.Agent | Public | False |
| SQL Server 2016 Databases Group Contains Database | Microsoft.SQLServer.2016.DatabasesGroupContainsDatabase | Microsoft.SQLServer.2016.DatabasesGroup | Microsoft.SQLServer.2016.Database | Public | False |
| MSSQL : SQL Server Instance Group Contains Instances | Microsoft.SQLServer.2016.GlobalInstanceGroupContainsDBEngine | Microsoft.SQLServer.Generic.Presentation.SQLServerInstanceGroup | Microsoft.SQLServer.2016.DBEngine | Public | False |
| SQL Server 2016 Instances Group Contains DBEngine | Microsoft.SQLServer.2016.InstancesGroupContainsDBEngine | Microsoft.SQLServer.2016.InstancesGroup | Microsoft.SQLServer.2016.DBEngine | Public | False |
| Alerts Scope Group Contains Alerts Scope Group L3 Relationship | Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupContainsAlertsScopeGroupL3 | Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup | Microsoft.SQLServer.2016.AlertsScopeGroupL3 | Internal | False |
| Alerts Scope Group Contains Seed Relationship | Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupContainsSeed | Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup | Microsoft.SQLServer.2016.Seed | Internal | False |
| Alerts Scope Group L3 Contains Event Log Collection Target Relationship | Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupL3ContainsEventLogCollectionTarget | Microsoft.SQLServer.2016.AlertsScopeGroupL3 | Microsoft.SQLServer.2016.EventLogCollectionTarget | Internal | False |
| AlertsScopeGroupL3ContainsServiceRole Relationship | Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupL3ContainsServiceRoles | Microsoft.SQLServer.2016.AlertsScopeGroupL3 | Microsoft.SQLServer.2016.ServerRole | Internal | False |
| Server Roles Group Contains Server Roles Relationship | Microsoft.SQLServer.2016.Relationships.ServerRolesGroupContainsServerRoles | Microsoft.SQLServer.Generic.Presentation.ServerRolesGroup | Microsoft.SQLServer.2016.ServerRole | Internal | False |
| DisplayName | ID | Target | Enabled | |
|---|---|---|---|---|
 | MSSQL 2016: Populate SQL Server 2016 Agents Group | Microsoft.SQLServer.2016.AgentsGroup.Discovery | Microsoft.SQLServer.2016.AgentsGroup | True |
| MSSQL 2016: Alerts Scope Group Discovery | Microsoft.SQLServer.2016.AlertsScopeGroupDiscovery | Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup | True |
| MSSQL 2016: Populate SQL Server 2016 Databases Group | Microsoft.SQLServer.2016.DatabasesGroup.Discovery | Microsoft.SQLServer.2016.DatabasesGroup | True |
| MSSQL 2016: Alerts Scope Group L3 Discovery | Microsoft.SQLServer.2016.Discovery.AlertsScopeGroupL3 | Microsoft.SQLServer.2016.AlertsScopeGroupL3 | True |
| MSSQL 2016: Discover SQL Server Computer Group membership | Microsoft.SQLServer.2016.GenericComputerGroupDiscovery | Microsoft.SQLServer.Generic.Presentation.ComputersGroup | True |
| MSSQL: Populate SQL Server Instance Group | Microsoft.SQLServer.2016.GlobalInstanceGroupDiscovery | Microsoft.SQLServer.Generic.Presentation.SQLServerInstanceGroup | True |
| MSSQL 2016: Populate SQL Server 2016 Instance Group | Microsoft.SQLServer.2016.InstancesGroup.Discovery | Microsoft.SQLServer.2016.InstancesGroup | True |
| MSSQL 2016: Server Roles Group Discovery | Microsoft.SQLServer.2016.ServerRolesGroupDiscovery | Microsoft.SQLServer.Generic.Presentation.ServerRolesGroup | True |
| DisplayName | ID | FolderName | ElementID | |
|---|---|---|---|---|
 | Active Alerts | Microsoft.SQLServer.2016.Agent.AlertsView | Microsoft.SQLServer.2016.ViewFolder.Agent | Microsoft.SQLServer.2016.Agent.AlertsView |
| SQL Agents | Microsoft.SQLServer.2016.Agent.StateView | Microsoft.SQLServer.2016.ViewFolder.Agent | Microsoft.SQLServer.2016.Agent.StateView |
| SQL Agent Jobs | Microsoft.SQLServer.2016.AgentJob.StateView | Microsoft.SQLServer.2016.ViewFolder.Agent | Microsoft.SQLServer.2016.AgentJob.StateView |
| Active Alerts | Microsoft.SQLServer.2016.Database.AlertsView | Microsoft.SQLServer.2016.ViewFolder.Databases | Microsoft.SQLServer.2016.Database.AlertsView |
| All Performance Data | Microsoft.SQLServer.2016.Database.AllPerformanceDataView | Microsoft.SQLServer.2016.ViewFolder.Databases | Microsoft.SQLServer.2016.Database.AllPerformanceDataView |
| Databases | Microsoft.SQLServer.2016.Database.StateView | Microsoft.SQLServer.2016.ViewFolder.Databases | Microsoft.SQLServer.2016.Database.StateView |
| Active Alerts | Microsoft.SQLServer.2016.DBEngine.AlertsView | Microsoft.SQLServer.2016.ViewFolder.DBEngines | Microsoft.SQLServer.2016.DBEngine.AlertsView |
| All Performance Data | Microsoft.SQLServer.2016.DBEngine.AllPerformanceDataView | Microsoft.SQLServer.2016.ViewFolder.DBEngines | Microsoft.SQLServer.2016.DBEngine.AllPerformanceDataView |
| Resource Pools | Microsoft.SQLServer.2016.DBEngine.ResourcePoolsView | Microsoft.SQLServer.2016.ViewFolder.DBEngines | Microsoft.SQLServer.2016.DBEngine.ResourcePoolsView |
| Database Engines | Microsoft.SQLServer.2016.DBEngine.StateView | Microsoft.SQLServer.2016.ViewFolder.DBEngines | Microsoft.SQLServer.2016.DBEngine.StateView |
| Filegroups | Microsoft.SQLServer.2016.DBFileGroup.StateView | Microsoft.SQLServer.2016.ViewFolder.Databases | Microsoft.SQLServer.2016.DBFileGroup.StateView |
| Computers | Microsoft.SQLServer.2016.Server.StateView | Microsoft.SQLServer.2016.ViewFolder.Root | Microsoft.SQLServer.2016.Server.StateView |
| Active Alerts | Microsoft.SQLServer.2016.ServerRole.ActiveAlertsView | Microsoft.SQLServer.2016.ViewFolder.Root | Microsoft.SQLServer.2016.ServerRole.ActiveAlertsView |
| All Performance Data | Microsoft.SQLServer.2016.ServerRole.AllPerformanceDataView | Microsoft.SQLServer.2016.ViewFolder.Root | Microsoft.SQLServer.2016.ServerRole.AllPerformanceDataView |
| Task Status | Microsoft.SQLServer.2016.ServerRole.TaskStatusView | Microsoft.SQLServer.2016.ViewFolder.Root | Microsoft.SQLServer.2016.ServerRole.TaskStatusView |
| Memory-Optimized Data Filegroup Containers | Microsoft.SQLServer.2016.View.Container.State | Microsoft.SQLServer.2016.ViewFolder.InMemoryOLTP | Microsoft.SQLServer.2016.View.Container.State |
| Memory-Optimized Data Filegroups | Microsoft.SQLServer.2016.View.DBFileGroupFx.State | Microsoft.SQLServer.2016.ViewFolder.InMemoryOLTP | Microsoft.SQLServer.2016.View.DBFileGroupFx.State |
| Active Alerts | Microsoft.SQLServer.2016.View.InMemoryOLTP.Alerts | Microsoft.SQLServer.2016.ViewFolder.InMemoryOLTP | Microsoft.SQLServer.2016.View.InMemoryOLTP.Alerts |
| All Performance Data | Microsoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceData | Microsoft.SQLServer.2016.ViewFolder.InMemoryOLTP | Microsoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceData |
| Resource Pools | Microsoft.SQLServer.2016.View.UserResourcePool.State | Microsoft.SQLServer.2016.ViewFolder.InMemoryOLTP | Microsoft.SQLServer.2016.View.UserResourcePool.State |
| DisplayName | ID | ParentFolder | Accessibility | |
|---|---|---|---|---|
| SQL Agent | Microsoft.SQLServer.2016.ViewFolder.Agent | Microsoft.SQLServer.2016.ViewFolder.Root | Public |
| Databases | Microsoft.SQLServer.2016.ViewFolder.Databases | Microsoft.SQLServer.2016.ViewFolder.Root | Public |
| Database Engines | Microsoft.SQLServer.2016.ViewFolder.DBEngines | Microsoft.SQLServer.2016.ViewFolder.Root | Public |
| Memory-Optimized Data | Microsoft.SQLServer.2016.ViewFolder.InMemoryOLTP | Microsoft.SQLServer.2016.ViewFolder.Databases | Public |
| SQL Server 2016 | Microsoft.SQLServer.2016.ViewFolder.Root | Microsoft.SQLServer.Generic.Presentation.Folder.DatabaseEngine | Public |
| DisplayName | ID | Target | Type | Accessibility | Visible | |
|---|---|---|---|---|---|---|
 | Active Alerts | Microsoft.SQLServer.2016.Agent.AlertsView | Microsoft.SQLServer.2016.Agent | Microsoft.SystemCenter.AlertViewType | Public | True |
 | SQL Agents | Microsoft.SQLServer.2016.Agent.StateView | Microsoft.SQLServer.2016.Agent | Microsoft.SystemCenter.StateViewType | Public | True |
| SQL Agent Jobs | Microsoft.SQLServer.2016.AgentJob.StateView | Microsoft.SQLServer.2016.AgentJob | Microsoft.SystemCenter.StateViewType | Public | True |
| Active Alerts | Microsoft.SQLServer.2016.Database.AlertsView | Microsoft.SQLServer.2016.Database | Microsoft.SystemCenter.AlertViewType | Public | True |
 | All Performance Data | Microsoft.SQLServer.2016.Database.AllPerformanceDataView | Microsoft.SQLServer.2016.Database | Microsoft.SystemCenter.PerformanceViewType | Public | True |
| Database Free Space | Microsoft.SQLServer.2016.Database.DBSizePerformanceDataView | Microsoft.SQLServer.2016.Database | Microsoft.SystemCenter.PerformanceViewType | Public | True |
| Transaction Log Free Space | Microsoft.SQLServer.2016.Database.LogSizePerformanceDataView | Microsoft.SQLServer.2016.Database | Microsoft.SystemCenter.PerformanceViewType | Public | True |
| Databases | Microsoft.SQLServer.2016.Database.StateView | Microsoft.SQLServer.2016.Database | Microsoft.SystemCenter.StateViewType | Public | True |
| Active Alerts | Microsoft.SQLServer.2016.DBEngine.AlertsView | Microsoft.SQLServer.2016.DBEngine | Microsoft.SystemCenter.AlertViewType | Public | True |
| All Performance Data | Microsoft.SQLServer.2016.DBEngine.AllPerformanceDataView | Microsoft.SQLServer.2016.DBEngine | Microsoft.SystemCenter.PerformanceViewType | Public | True |
| Resource Pools | Microsoft.SQLServer.2016.DBEngine.ResourcePoolsView | Microsoft.SQLServer.2016.ResourcePool | Microsoft.SystemCenter.StateViewType | Public | True |
| Database Engines | Microsoft.SQLServer.2016.DBEngine.StateView | Microsoft.SQLServer.2016.DBEngine | Microsoft.SystemCenter.StateViewType | Public | True |
| User Connections | Microsoft.SQLServer.2016.DBEngine.UserConnectionsView | Microsoft.SQLServer.2016.DBEngine | Microsoft.SystemCenter.PerformanceViewType | Public | True |
| Filegroups | Microsoft.SQLServer.2016.DBFileGroup.StateView | Microsoft.SQLServer.2016.FileGroup | Microsoft.SystemCenter.StateViewType | Public | True |
| Computers | Microsoft.SQLServer.2016.Server.StateView | Microsoft.Windows.Computer | Microsoft.SystemCenter.StateViewType | Public | True |
| Active Alerts | Microsoft.SQLServer.2016.ServerRole.ActiveAlertsView | Microsoft.SQLServer.2016.AlertsScopeGroupL3 | Microsoft.SystemCenter.AlertViewType | Public | True |
| All Performance Data | Microsoft.SQLServer.2016.ServerRole.AllPerformanceDataView | Microsoft.SQLServer.2016.ServerRole | Microsoft.SystemCenter.PerformanceViewType | Public | True |
 | Task Status | Microsoft.SQLServer.2016.ServerRole.TaskStatusView | Microsoft.SQLServer.2016.ServerRole | Microsoft.SystemCenter.TaskStatusViewType | Public | True |
| Memory-Optimized Data Filegroup Containers | Microsoft.SQLServer.2016.View.Container.State | Microsoft.SQLServer.2016.Container | Microsoft.SystemCenter.StateViewType | Public | True |
| Memory-Optimized Data Filegroups | Microsoft.SQLServer.2016.View.DBFileGroupFx.State | Microsoft.SQLServer.2016.DBFileGroupFx | Microsoft.SystemCenter.StateViewType | Public | True |
| Active Alerts | Microsoft.SQLServer.2016.View.InMemoryOLTP.Alerts | Microsoft.SQLServer.2016.InMemoryOLTPScopeGroup | Microsoft.SystemCenter.AlertViewType | Public | True |
| All Performance Data | Microsoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceData | Microsoft.SQLServer.2016.InMemoryOLTPScopeGroup | Microsoft.SystemCenter.PerformanceViewType | Public | True |
| Resource Pools | Microsoft.SQLServer.2016.View.UserResourcePool.State | Microsoft.SQLServer.2016.ResourcePool | Microsoft.SystemCenter.StateViewType | Public | True |
Home
ENU 
Show Management Pack References