Microsoft SQL Server 2017+ on Linux (Views)

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

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

Summary

Microsoft SQL Server 2017+ on Linux (Views) Management Pack contains views and folder structure for Microsoft SQL Server 2017+ on Linux management packs. This Management Pack depends on Microsoft SQL Server 2017+ on Linux (Discovery) Management Pack and Microsoft SQL Server Core Library (Views) Management Pack.

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

ClassType (6)
RelationshipType (12)

Monitoring

Discovery (6)

Presentation

FolderItem (15)
Folder (5)
View (16)
Advanced

ComponentImplementation (1)
ComponentReference (1)
ComponentType (1)

Classes (6)

System.Entity

System.ConfigItem

System.LogicalEntity

System.Group

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 сontains 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 сontains 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 сontains 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 сontains 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 сontains 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 сontains 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 (15)

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
Microsoft.SQLServer.Linux.FolderItem.RootAlwaysOn.AlertsView	Microsoft.SQLServer.Linux.Folder.RootAlwaysOn	Microsoft.SQLServer.Linux.View.RootAlwaysOn.AlertsView

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 (16)

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
Active Alerts	Microsoft.SQLServer.Linux.View.RootAlwaysOn.AlertsView	Microsoft.SQLServer.Linux.AvailabilityReplicaGroup	Microsoft.SystemCenter.AlertViewType	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