Microsoft SQL Server on Linux (Views)

Microsoft.SQLServer.Linux.Views :: 7.0.20.0 (Management Pack)

This Management Pack contains views and folder structure for Microsoft SQL Server on Linux management packs.

• Show Management Pack XML
• Get Management Pack data in Excel format
• Download: Microsoft.SQLServer.Linux.Views.mp

Management Pack Elements

Classes (6)

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	MSSQL on Linux: All SQL Server Objects Group	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroup	System.Group	False	False	True	True	False	Public
	MSSQL on Linux: Group of Linux Availability Replicas	Microsoft.SQLServer.Linux.AvailabilityReplicaGroup	System.Group	False	False	True	True	False	Public
	MSSQL on Linux: Group of Linux Database Replicas	Microsoft.SQLServer.Linux.DatabaseReplicaGroup	System.Group	False	False	True	True	False	Public
	MSSQL on Linux: All SQL Server Filegroups Group	Microsoft.SQLServer.Linux.FilegroupsGroup	System.Group	False	False	True	True	False	Public
	MSSQL on Linux: Memory-Optimized Data Resource Pool Group	Microsoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroup	System.Group	False	False	True	True	False	Public
	MSSQL on Linux: Memory-Optimized Data Scope Group	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroup	System.Group	False	False	True	True	False	Public

Relationship Types (12)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	MSSQL on Linux: All SQL Server Objects Group contains SQL Server Agent Relationship	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsAgent	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroup	Microsoft.SQLServer.Linux.Agent	Internal	False
	MSSQL on Linux: All SQL Server Objects Group contains SQL Server DB Engine Relationship	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsDBEngine	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroup	Microsoft.SQLServer.Linux.DBEngine	Internal	False
	MSSQL on Linux: All SQL Server objects Group contains SQL Server Monitoring Pool Alert Collection Relationship	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsMonitoringPoolAlertCollection	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroup	Microsoft.SQLServer.Linux.MonitoringPoolAlertCollection	Internal	False
	MSSQL on Linux: Group of Linux Availability Replicas contains Linux Availability Replica	Microsoft.SQLServer.Linux.AvailabilityReplicaGroupContainsAvailabilityReplica	Microsoft.SQLServer.Linux.AvailabilityReplicaGroup	Microsoft.SQLServer.Linux.AvailabilityReplica	Internal	False
	MSSQL on Linux: Group of Linux Availability Replicas Contains Monitoring Pool Alert Collection Relationship	Microsoft.SQLServer.Linux.AvailabilityReplicaGroupContainsMonitoringPoolAlertCollection	Microsoft.SQLServer.Linux.AvailabilityReplicaGroup	Microsoft.SQLServer.Linux.MonitoringPoolAlertCollection	Internal	False
	MSSQL on Linux: Group of Linux Database Replicas contains Linux Database Replica	Microsoft.SQLServer.Linux.DatabaseReplicaGroupContainsDatabaseReplica	Microsoft.SQLServer.Linux.DatabaseReplicaGroup	Microsoft.SQLServer.Linux.DatabaseReplica	Internal	False
	MSSQL on Linux: All SQL Server Filegroups Group contains DB Filegroup Relationship	Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroup	Microsoft.SQLServer.Linux.FilegroupsGroup	Microsoft.SQLServer.Linux.DBFilegroup	Internal	False
	MSSQL on Linux: All SQL Server Filegroups Group contains DB FILESTREAM Filegroup Relationship	Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFd	Microsoft.SQLServer.Linux.FilegroupsGroup	Microsoft.SQLServer.Linux.DBFilegroupFd	Internal	False
	MSSQL on Linux: All SQL Server Filegroups Group contains DB Memory-Optimized Data Filegroup Relationship	Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFx	Microsoft.SQLServer.Linux.FilegroupsGroup	Microsoft.SQLServer.Linux.DBFilegroupFx	Internal	False
	MSSQL on Linux: SQL Server Memory-Optimized Data Resource Pool Group contains SQL Server Resource Pool on Linux Relationship	Microsoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupContainsResourcePool	Microsoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroup	Microsoft.SQLServer.Linux.ResourcePool	Internal	False
	MSSQL on Linux: SQL Server Memory-Optimized Data Scope Group contains SQL Server DB Memory-Optimized Data Filegroup Relationship	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroupContainsDBFilegroupFx	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroup	Microsoft.SQLServer.Linux.DBFilegroupFx	Internal	False
	MSSQL on Linux: SQL Server Memory-Optimized Data Scope Group contains SQL Server Memory-Optimized Data Resource Pool Group Relationship	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroupContainsInMemoryOLTPResourcePoolGroup	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroup	Microsoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroup	Internal	False

Discoveries (6)

	DisplayName	ID	Target	Enabled
	MSSQL on Linux: All SQL Server Objects Group Discovery	Microsoft.SQLServer.Linux.Discovery.AllSQLServerObjectsGroup	Microsoft.SQLServer.Linux.AllSQLServerObjectsGroup	True
	MSSQL on Linux: Populate Group of Linux Availability Replicas	Microsoft.SQLServer.Linux.Discovery.AvailabilityReplicaGroup	Microsoft.SQLServer.Linux.AvailabilityReplicaGroup	True
	MSSQL on Linux: Populate Group of Linux Database Replicas	Microsoft.SQLServer.Linux.Discovery.DatabaseReplicaGroup	Microsoft.SQLServer.Linux.DatabaseReplicaGroup	True
	MSSQL on Linux: All SQL Server Filegroups Group Discovery	Microsoft.SQLServer.Linux.Discovery.FilegroupsGroup	Microsoft.SQLServer.Linux.FilegroupsGroup	True
	MSSQL on Linux: SQL Server Memory-Optimized Data Resource Pool Group Discovery	Microsoft.SQLServer.Linux.Discovery.InMemoryOLTPResourcePoolGroup	Microsoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroup	True
	MSSQL on Linux: Memory-Optimized Data Scope Group Discovery	Microsoft.SQLServer.Linux.Discovery.InMemoryOLTPScopeGroup	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroup	True

Folder Items (14)

	ID	FolderName	ElementID
	Microsoft.SQLServer.Linux.FolderItem.Agent.AlertsView	Microsoft.SQLServer.Linux.Folder.Agent	Microsoft.SQLServer.Linux.View.Agent.AlertsView
	Microsoft.SQLServer.Linux.FolderItem.Agent.StateView	Microsoft.SQLServer.Linux.Folder.Agent	Microsoft.SQLServer.Linux.View.Agent.StateView
	Microsoft.SQLServer.Linux.FolderItem.AgentJob.StateView	Microsoft.SQLServer.Linux.Folder.Agent	Microsoft.SQLServer.Linux.View.AgentJob.StateView
	Microsoft.SQLServer.Linux.FolderItem.AvailabilityReplica.Performance	Microsoft.SQLServer.Linux.Folder.AllPerformanceAlwaysOn	Microsoft.SQLServer.Linux.View.AvailabilityReplica.Performance
	Microsoft.SQLServer.Linux.FolderItem.AvailabilityReplica.StateView	Microsoft.SQLServer.Linux.Folder.RootAlwaysOn	Microsoft.SQLServer.Linux.View.AvailabilityReplica.StateView
	Microsoft.SQLServer.Linux.FolderItem.Container.StateView	Microsoft.SQLServer.Linux.Folder.InMemoryOLTP	Microsoft.SQLServer.Linux.View.Container.StateView
	Microsoft.SQLServer.Linux.FolderItem.Database.StateView	Microsoft.SQLServer.Linux.Folder.DBEngine	Microsoft.SQLServer.Linux.View.Filegroup.StateView
	Microsoft.SQLServer.Linux.FolderItem.DatabaseReplica.Performance	Microsoft.SQLServer.Linux.Folder.AllPerformanceAlwaysOn	Microsoft.SQLServer.Linux.View.DatabaseReplica.Performance
	Microsoft.SQLServer.Linux.FolderItem.DatabaseReplica.StateView	Microsoft.SQLServer.Linux.Folder.RootAlwaysOn	Microsoft.SQLServer.Linux.View.DatabaseReplica.StateView
	Microsoft.SQLServer.Linux.FolderItem.DBEngine.StateView	Microsoft.SQLServer.Linux.Folder.DBEngine	Microsoft.SQLServer.Linux.View.DBEngine.StateView
	Microsoft.SQLServer.Linux.FolderItem.DBFilegroupFx.StateView	Microsoft.SQLServer.Linux.Folder.InMemoryOLTP	Microsoft.SQLServer.Linux.View.DBFilegroupFx.StateView
	Microsoft.SQLServer.Linux.FolderItem.InMemoryOLTP.AlertsView	Microsoft.SQLServer.Linux.Folder.InMemoryOLTP	Microsoft.SQLServer.Linux.View.InMemoryOLTP.AlertsView
	Microsoft.SQLServer.Linux.FolderItem.InMemoryOLTP.AllPerformance	Microsoft.SQLServer.Linux.Folder.InMemoryOLTP	Microsoft.SQLServer.Linux.View.InMemoryOLTP.AllPerformance
	Microsoft.SQLServer.Linux.FolderItem.InMemoryOLTPResourcePool.StateView	Microsoft.SQLServer.Linux.Folder.InMemoryOLTP	Microsoft.SQLServer.Linux.View.InMemoryOLTPResourcePool.StateView

Folders (5)

	DisplayName	ID	ParentFolder	Accessibility
	SQL Agent on Linux	Microsoft.SQLServer.Linux.Folder.Agent	Microsoft.SQLServer.Core.Folder.Agent	Public
	Performance	Microsoft.SQLServer.Linux.Folder.AllPerformanceAlwaysOn	Microsoft.SQLServer.Linux.Folder.RootAlwaysOn	Public
	Database Engines on Linux	Microsoft.SQLServer.Linux.Folder.DBEngine	Microsoft.SQLServer.Core.Folder.DBEngine	Public
	Memory-Optimized Data on Linux	Microsoft.SQLServer.Linux.Folder.InMemoryOLTP	Microsoft.SQLServer.Core.Folder.InMemoryOLTP	Public
	Always On High Availability on Linux	Microsoft.SQLServer.Linux.Folder.RootAlwaysOn	Microsoft.SQLServer.Core.Folder.RootAlwaysOn	Public

Views (15)

	DisplayName	ID	Target	Type	Accessibility	Visible
	Active Alerts	Microsoft.SQLServer.Linux.View.Agent.AlertsView	Microsoft.SQLServer.Linux.Agent	Microsoft.SystemCenter.AlertViewType	Public	True
	SQL Agents	Microsoft.SQLServer.Linux.View.Agent.StateView	Microsoft.SQLServer.Linux.Agent	Microsoft.SystemCenter.StateViewType	Public	True
	SQL Agent Jobs	Microsoft.SQLServer.Linux.View.AgentJob.StateView	Microsoft.SQLServer.Linux.AgentJob	Microsoft.SystemCenter.StateViewType	Public	True
	Availability Replica Performance	Microsoft.SQLServer.Linux.View.AvailabilityReplica.Performance	Microsoft.SQLServer.Linux.AvailabilityReplica	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Availability Replicas	Microsoft.SQLServer.Linux.View.AvailabilityReplica.StateView	Microsoft.SQLServer.Linux.AvailabilityReplica	Microsoft.SystemCenter.StateViewType	Public	True
	Memory-Optimized Data Filegroup Containers	Microsoft.SQLServer.Linux.View.Container.StateView	Microsoft.SQLServer.Linux.Container	Microsoft.SystemCenter.StateViewType	Public	True
	Databases	Microsoft.SQLServer.Linux.View.Database.StateView	Microsoft.SQLServer.Linux.Database	Microsoft.SystemCenter.StateViewType	Public	True
	Database Replica Performance	Microsoft.SQLServer.Linux.View.DatabaseReplica.Performance	Microsoft.SQLServer.Linux.DatabaseReplica	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Database Replicas	Microsoft.SQLServer.Linux.View.DatabaseReplica.StateView	Microsoft.SQLServer.Linux.DatabaseReplica	Microsoft.SystemCenter.StateViewType	Public	True
	Database Engines	Microsoft.SQLServer.Linux.View.DBEngine.StateView	Microsoft.SQLServer.Linux.DBEngine	Microsoft.SystemCenter.StateViewType	Public	True
	Memory-Optimized Data Filegroups	Microsoft.SQLServer.Linux.View.DBFilegroupFx.StateView	Microsoft.SQLServer.Linux.DBFilegroupFx	Microsoft.SystemCenter.StateViewType	Public	True
	Filegroups	Microsoft.SQLServer.Linux.View.Filegroup.StateView	Microsoft.SQLServer.Core.Filegroup	Microsoft.SystemCenter.StateViewType	Public	True
	Active Alerts	Microsoft.SQLServer.Linux.View.InMemoryOLTP.AlertsView	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroup	Microsoft.SystemCenter.AlertViewType	Public	True
	All Performance Data	Microsoft.SQLServer.Linux.View.InMemoryOLTP.AllPerformance	Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroup	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Resource Pools	Microsoft.SQLServer.Linux.View.InMemoryOLTPResourcePool.StateView	Microsoft.SQLServer.Linux.ResourcePool	Microsoft.SystemCenter.StateViewType	Public	True

Component Implementations (1)

	ID	Type	Platform	Target	Accessibility
	Microsoft.SQLServer.Linux.Dashboards.SummaryImplementation	Microsoft.SQLServer.Linux.Dashboards.Summary	Wpf, Silverlight		Public

Component References (1)

	ID	Type	Parent	Accessibility
	Microsoft.SQLServer.Linux.Dashboards.SummaryReference	Microsoft.SQLServer.Linux.Dashboards.Summary	Microsoft.SQLServer.Linux.Folder.DBEngine	Public

Component Types (1)

	DisplayName	ID	Accessibility
	Summary	Microsoft.SQLServer.Linux.Dashboards.Summary	Public