Home
  •  

Microsoft SQL Server 2014 (Views)

Microsoft.SQLServer.2014.Views :: 6.5.1.0 (Management Pack)

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

Management Pack Elements

Relationship Types (3)

 DisplayNameIDSourceTargetAccessibilityAbstract
Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsSeedAlerts Scope Group Contains Seed RelationshipMicrosoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsSeedMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupMicrosoft.SQLServer.2014.SeedInternalFalse
Microsoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsServiceRolesAlertsScopeGroupContainsServiceRole RelationshipMicrosoft.SQLServer.2014.Relationships.AlertsScopeGroupContainsServiceRolesMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupMicrosoft.SQLServer.2014.ServerRoleInternalFalse
Microsoft.SQLServer.2014.Relationships.ServerRolesGroupContainsServerRolesServer Roles Group Contains Server Roles RelationshipMicrosoft.SQLServer.2014.Relationships.ServerRolesGroupContainsServerRolesMicrosoft.SQLServer.Generic.Presentation.ServerRolesGroupMicrosoft.SQLServer.2014.ServerRoleInternalFalse

Discoveries (3)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.2014.AlertsScopeGroupDiscoveryMSSQL 2014: Alerts Scope Group DiscoveryMicrosoft.SQLServer.2014.AlertsScopeGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupTrue
Microsoft.SQLServer.2014.GenericComputerGroupDiscoveryMSSQL 2014: Discover SQL Server Computer Group membershipMicrosoft.SQLServer.2014.GenericComputerGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.ComputersGroupTrue
Microsoft.SQLServer.2014.ServerRolesGroupDiscoveryMSSQL 2014: Server Roles Group DiscoveryMicrosoft.SQLServer.2014.ServerRolesGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.ServerRolesGroupTrue

Folder Items (19)

 DisplayNameIDFolderNameElementID
Microsoft.SQLServer.2014.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Agent.AlertsViewMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.Agent.AlertsView
Microsoft.SQLServer.2014.Agent.StateViewSQL AgentsMicrosoft.SQLServer.2014.Agent.StateViewMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.Agent.StateView
Microsoft.SQLServer.2014.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.2014.AgentJob.StateViewMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.AgentJob.StateView
Microsoft.SQLServer.2014.Database.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Database.AlertsViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.Database.AlertsView
Microsoft.SQLServer.2014.Database.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.Database.AllPerformanceDataViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.Database.AllPerformanceDataView
Microsoft.SQLServer.2014.Database.StateViewDatabasesMicrosoft.SQLServer.2014.Database.StateViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.Database.StateView
Microsoft.SQLServer.2014.DBEngine.AlertsViewActive AlertsMicrosoft.SQLServer.2014.DBEngine.AlertsViewMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.DBEngine.AlertsView
Microsoft.SQLServer.2014.DBEngine.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.DBEngine.AllPerformanceDataViewMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.DBEngine.AllPerformanceDataView
Microsoft.SQLServer.2014.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.2014.DBEngine.StateViewMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.DBEngine.StateView
Microsoft.SQLServer.2014.DBFileGroup.StateViewFile GroupsMicrosoft.SQLServer.2014.DBFileGroup.StateViewMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.DBFileGroup.StateView
Microsoft.SQLServer.2014.ServerRole.ActiveAlertsViewActive AlertsMicrosoft.SQLServer.2014.ServerRole.ActiveAlertsViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.2014.ServerRole.ActiveAlertsView
Microsoft.SQLServer.2014.ServerRole.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.ServerRole.AllPerformanceDataViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.2014.ServerRole.AllPerformanceDataView
Microsoft.SQLServer.2014.ServerRole.TaskStatusViewTask StatusMicrosoft.SQLServer.2014.ServerRole.TaskStatusViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.2014.ServerRole.TaskStatusView
Microsoft.SQLServer.2014.View.Container.StateMemory-Optimized Data File Group ContainersMicrosoft.SQLServer.2014.View.Container.StateMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.Container.State
Microsoft.SQLServer.2014.View.DBFileGroupFx.StateMemory-Optimized Data File GroupsMicrosoft.SQLServer.2014.View.DBFileGroupFx.StateMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.DBFileGroupFx.State
Microsoft.SQLServer.2014.View.InMemoryOLTP.AlertsActive AlertsMicrosoft.SQLServer.2014.View.InMemoryOLTP.AlertsMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.InMemoryOLTP.Alerts
Microsoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataAll Performance DataMicrosoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceData
Microsoft.SQLServer.2014.View.UserResourcePool.StateResource PoolsMicrosoft.SQLServer.2014.View.UserResourcePool.StateMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.View.UserResourcePool.State
Microsoft.SQLServer.Server.StateViewComputersMicrosoft.SQLServer.Server.StateViewMicrosoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.Server.StateView

Folders (5)

 DisplayNameIDParentFolderAccessibility
Microsoft.SQLServer.2014.ViewFolder.AgentSQL AgentMicrosoft.SQLServer.2014.ViewFolder.AgentMicrosoft.SQLServer.2014.ViewFolder.RootPublic
Microsoft.SQLServer.2014.ViewFolder.DatabasesDatabasesMicrosoft.SQLServer.2014.ViewFolder.DatabasesMicrosoft.SQLServer.2014.ViewFolder.RootPublic
Microsoft.SQLServer.2014.ViewFolder.DBEnginesDatabase EnginesMicrosoft.SQLServer.2014.ViewFolder.DBEnginesMicrosoft.SQLServer.2014.ViewFolder.RootPublic
Microsoft.SQLServer.2014.ViewFolder.InMemoryOLTPIn-Memory OLTPMicrosoft.SQLServer.2014.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2014.ViewFolder.DatabasesPublic
Microsoft.SQLServer.2014.ViewFolder.RootSQL Server 2014Microsoft.SQLServer.2014.ViewFolder.RootMicrosoft.SQLServer.Generic.Presentation.Folder.DatabaseEnginePublic

Views (22)

 DisplayNameIDTargetTypeAccessibilityVisible
Microsoft.SQLServer.2014.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Agent.AlertsViewMicrosoft.SQLServer.2014.AgentMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.Agent.StateViewSQL AgentsMicrosoft.SQLServer.2014.Agent.StateViewMicrosoft.SQLServer.2014.AgentMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.2014.AgentJob.StateViewMicrosoft.SQLServer.2014.AgentJobMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.Database.AlertsViewActive AlertsMicrosoft.SQLServer.2014.Database.AlertsViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.Database.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.Database.AllPerformanceDataViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.Database.DBSizePerformanceDataViewDatabase Free SpaceMicrosoft.SQLServer.2014.Database.DBSizePerformanceDataViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.Database.LogSizePerformanceDataViewTransaction Log Free SpaceMicrosoft.SQLServer.2014.Database.LogSizePerformanceDataViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.Database.StateViewDatabasesMicrosoft.SQLServer.2014.Database.StateViewMicrosoft.SQLServer.2014.DatabaseMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.AlertsViewActive AlertsMicrosoft.SQLServer.2014.DBEngine.AlertsViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.DBEngine.AllPerformanceDataViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.2014.DBEngine.StateViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.DBEngine.UserConnectionsViewUser ConnectionsMicrosoft.SQLServer.2014.DBEngine.UserConnectionsViewMicrosoft.SQLServer.2014.DBEngineMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.DBFileGroup.StateViewFile GroupsMicrosoft.SQLServer.2014.DBFileGroup.StateViewMicrosoft.SQLServer.2014.DBFileGroupMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.ServerRole.ActiveAlertsViewActive AlertsMicrosoft.SQLServer.2014.ServerRole.ActiveAlertsViewMicrosoft.SQLServer.2014.ServerRoleMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.ServerRole.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2014.ServerRole.AllPerformanceDataViewMicrosoft.SQLServer.2014.ServerRoleMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.ServerRole.TaskStatusViewTask StatusMicrosoft.SQLServer.2014.ServerRole.TaskStatusViewMicrosoft.SQLServer.2014.ServerRoleMicrosoft.SystemCenter.TaskStatusViewTypePublicTrue
Microsoft.SQLServer.2014.View.Container.StateMemory-Optimized Data File Group ContainersMicrosoft.SQLServer.2014.View.Container.StateMicrosoft.SQLServer.2014.ContainerMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.View.DBFileGroupFx.StateMemory-Optimized Data File GroupsMicrosoft.SQLServer.2014.View.DBFileGroupFx.StateMicrosoft.SQLServer.2014.DBFileGroupFxMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2014.View.InMemoryOLTP.AlertsActive AlertsMicrosoft.SQLServer.2014.View.InMemoryOLTP.AlertsMicrosoft.SQLServer.2014.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataAll Performance DataMicrosoft.SQLServer.2014.View.InMemoryOLTP.AllPerformanceDataMicrosoft.SQLServer.2014.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2014.View.UserResourcePool.StateResource PoolsMicrosoft.SQLServer.2014.View.UserResourcePool.StateMicrosoft.SQLServer.2014.UserResourcePoolMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Server.StateViewComputersMicrosoft.SQLServer.Server.StateViewMicrosoft.Windows.ComputerMicrosoft.SystemCenter.StateViewTypePublicTrue