Microsoft SQL Server 2017+ on Windows (Views)

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

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

Summary

Microsoft SQL Server 2017+ on Windows (Views) Management Pack contains views and folder structure for Microsoft SQL Server 2017+ on Windows management packs. This Management Pack depends on Microsoft SQL Server 2017+ on Windows (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)

Resources

Resource (2)

Reporting

Report (1)
ReportResource (1)
DataWarehouseScript (1)

Classes (6)

System.Entity

System.ConfigItem

System.LogicalEntity

System.Group

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

Relationship Types (12)

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

Discoveries (6)

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

Folder Items (15)

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

Folders (5)

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

Views (16)

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

Component Implementations (1)

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

Component References (1)

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

Component Types (1)

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

Resources (2)

	ID	File Name	Accessibility
	GetDBFilesForecastData_CreateAlter.sql	GetDBFilesForecastData_CreateAlter.sql	Internal
	GetDBFilesForecastData_Drop.sql	GetDBFilesForecastData_Drop.sql	Internal

Report Resources (1)

	ID	File Name	Accessibility
	Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast.rdl	DBFilesForecast.rdl	Internal

Reports (1)

	DisplayName	ID	Accessibility	Visible
	Database Files Space Usage Forecast	Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast	Internal	True

Data Warehouse Scripts (1)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	Microsoft.SQLServer.Windows.Views.Script.GetDBFilesForecastData	GetDBFilesForecastData_CreateAlter.sql	GetDBFilesForecastData_Drop.sql	GetDBFilesForecastData_CreateAlter.sql	False	Internal