SQL Server Core Library

Microsoft.SQLServer.Library :: 6.3.173.1 (Management Pack)

Microsoft SQL Server Core Library: This Management Pack is the core library for all versions of SQL Server. It defines all SQL Server base classes and relationships

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

Management Pack Elements

Classes (20)

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	SQL Agent	Microsoft.SQLServer.Agent	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL Agent Job	Microsoft.SQLServer.AgentJob	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL Analysis Services	Microsoft.SQLServer.AnalysisServices	Microsoft.SQLServer.ServerRole	True	True	False	False	False	Public
	SQL Component	Microsoft.SQLServer.Component	Microsoft.Windows.ApplicationComponent	True	False	False	False	False	Public
	SQL Components	Microsoft.SQLServer.ComponentsGroup	System.Group	False	False	True	True	False	Public
	SQL Computers	Microsoft.SQLServer.ComputerGroup	Microsoft.SystemCenter.ComputerGroup	False	False	True	True	False	Public
	SQL Database	Microsoft.SQLServer.Database	System.Database	False	True	False	False	False	Public
	SQL DB Engine	Microsoft.SQLServer.DBEngine	Microsoft.SQLServer.ServerRole	False	True	False	False	False	Public
	SQL DB File	Microsoft.SQLServer.DBFile	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL DB File Group	Microsoft.SQLServer.DBFileGroup	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL DB Perspective	Microsoft.SQLServer.DBPerspective	System.Perspective	True	True	False	False	False	Public
	SQL Distributor	Microsoft.SQLServer.Distributor	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL Instances	Microsoft.SQLServer.InstanceGroup	System.Group	False	False	True	True	False	Public
	SQL Integration Services	Microsoft.SQLServer.IntegrationServices	Microsoft.SQLServer.ServerRole	True	True	False	False	False	Public
	SQL Publication	Microsoft.SQLServer.Publication	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL Publisher	Microsoft.SQLServer.Publisher	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL Reporting Services	Microsoft.SQLServer.ReportingServices	Microsoft.SQLServer.ServerRole	True	True	False	False	False	Public
	SQL Role	Microsoft.SQLServer.ServerRole	Microsoft.Windows.ComputerRole	True	True	False	False	False	Public
	SQL Subscriber	Microsoft.SQLServer.Subscriber	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	SQL Subscription	Microsoft.SQLServer.Subscription	Microsoft.SQLServer.Component	True	False	False	False	False	Public

Relationship Types (4)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	Components Group Contains All SQL Server related components	Microsoft.SQLServer.ComponentsGroupContainsEntity	Microsoft.SQLServer.ComponentsGroup	System.Entity	Public	False
	SQL Database Engine Hosts SQL Database	Microsoft.SQLServer.DBEngineHostsDatabase	Microsoft.SQLServer.DBEngine	Microsoft.SQLServer.Database	Public	False
	Instance Group Contains All Instances of SQL DBEngine	Microsoft.SQLServer.InstanceGroupContainsDBEngine	Microsoft.SQLServer.InstanceGroup	Microsoft.SQLServer.DBEngine	Public	False
	Windows Computer Hosts Database Perspective	Microsoft.SQLServer.WindowsComputerHostsDBPerspective	Microsoft.Windows.Computer	Microsoft.SQLServer.DBPerspective	Public	False

Secure References (3)

	DisplayName	ID	Context	Accessibility
	SQL Server Default Action Account	Microsoft.SQLServer.SQLDefaultAccount	System.Entity	Public
	SQL Server Discovery Account	Microsoft.SQLServer.SQLDiscoveryAccount	System.Entity	Public
	SQL Server Monitoring Account	Microsoft.SQLServer.SQLProbeAccount	System.Entity	Public

Discoveries (3)

	DisplayName	ID	Target	Enabled
	Discover SQL Server Components Group membership	Microsoft.SQLServer.ComponentsGroupDiscovery	Microsoft.SQLServer.ComponentsGroup	True
	Discover SQL Server Computer Group membership	Microsoft.SQLServer.ComputerGroupDiscovery	Microsoft.SQLServer.ComputerGroup	True
	Discover SQL Server Instance Group membership	Microsoft.SQLServer.InstanceGroupDiscovery	Microsoft.SQLServer.InstanceGroup	True

Folder Items (32)

	DisplayName	ID	FolderName	ElementID
	Agent Health	Microsoft.SQLServer.Agent.Health.Dashboard.View	Microsoft.SQLServer.ViewFolder.Health	Microsoft.SQLServer.Agent.Health.Dashboard.View
	SQL Agent State	Microsoft.SQLServer.Agent.State.View	Microsoft.SQLServer.ViewFolder.Agent	Microsoft.SQLServer.Agent.State.View
	SQL Agent Job State	Microsoft.SQLServer.AgentJob.State.View	Microsoft.SQLServer.ViewFolder.Agent	Microsoft.SQLServer.AgentJob.State.View
	Analysis Services	Microsoft.SQLServer.AnalysisServicesState.View	Microsoft.SQLServer.ViewFolder.SQLRoles	Microsoft.SQLServer.AnalysisServicesState.View
	Database State	Microsoft.SQLServer.Database.DatabaseState.View	Microsoft.SQLServer.ViewFolder.Databases	Microsoft.SQLServer.Database.DatabaseState.View
	Database Free Space	Microsoft.SQLServer.Database.DBSizePerformanceData.View	Microsoft.SQLServer.ViewFolder.Performance	Microsoft.SQLServer.Database.DBSizePerformanceData.View
	Database Free Space	Microsoft.SQLServer.Database.DBSizePerformanceData2.View	Microsoft.SQLServer.ViewFolder.Databases	Microsoft.SQLServer.Database.DBSizePerformanceData2.View
	Transaction Log Free Space	Microsoft.SQLServer.Database.LogSizePerformanceData.View	Microsoft.SQLServer.ViewFolder.Performance	Microsoft.SQLServer.Database.LogSizePerformanceData.View
	Transaction Log Free Space	Microsoft.SQLServer.Database.LogSizePerformanceData2.View	Microsoft.SQLServer.ViewFolder.Databases	Microsoft.SQLServer.Database.LogSizePerformanceData2.View
	Database Engine Health	Microsoft.SQLServer.DBEngine.Health.Dashboard.View	Microsoft.SQLServer.ViewFolder.Health	Microsoft.SQLServer.DBEngine.Health.Dashboard.View
	User Connections	Microsoft.SQLServer.DBEngine.UserConnections.View	Microsoft.SQLServer.ViewFolder.Performance	Microsoft.SQLServer.DBEngine.UserConnections.View
	Database Engines	Microsoft.SQLServer.DBEngineState.View	Microsoft.SQLServer.ViewFolder.SQLRoles	Microsoft.SQLServer.DBEngineState.View
	Distributors	Microsoft.SQLServer.Distributor.State.View	Microsoft.SQLServer.ViewFolder.Replication.Objects	Microsoft.SQLServer.Distributor.State.View
	Integration Services	Microsoft.SQLServer.IntegrationServicesState.View	Microsoft.SQLServer.ViewFolder.SQLRoles	Microsoft.SQLServer.IntegrationServicesState.View
	Publications	Microsoft.SQLServer.Publication.State.View	Microsoft.SQLServer.ViewFolder.Replication.Objects	Microsoft.SQLServer.Publication.State.View
	Publishers	Microsoft.SQLServer.Publisher.State.View	Microsoft.SQLServer.ViewFolder.Replication.Objects	Microsoft.SQLServer.Publisher.State.View
	Replication Agents Running	Microsoft.SQLServer.Replication.AgentsRunning.View	Microsoft.SQLServer.ViewFolder.Replication	Microsoft.SQLServer.Replication.AgentsRunning.View
	Delivered Commands	Microsoft.SQLServer.Replication.Distributor.DeliveredCommands.View	Microsoft.SQLServer.ViewFolder.Replication.Distributor	Microsoft.SQLServer.Replication.Distributor.DeliveredCommands.View
	Delivered Transactions	Microsoft.SQLServer.Replication.Distributor.DeliveredTransactions.View	Microsoft.SQLServer.ViewFolder.Replication.Distributor	Microsoft.SQLServer.Replication.Distributor.DeliveredTransactions.View
	Delivered Commands	Microsoft.SQLServer.Replication.LogReader.DeliveredCommands.View	Microsoft.SQLServer.ViewFolder.Replication.LogReader	Microsoft.SQLServer.Replication.LogReader.DeliveredCommands.View
	Delivered Transactions	Microsoft.SQLServer.Replication.LogReader.DeliveredTransactions.View	Microsoft.SQLServer.ViewFolder.Replication.LogReader	Microsoft.SQLServer.Replication.LogReader.DeliveredTransactions.View
	Conflicts	Microsoft.SQLServer.Replication.Merge.Conflicts.View	Microsoft.SQLServer.ViewFolder.Replication.Merge	Microsoft.SQLServer.Replication.Merge.Conflicts.View
	Downloaded Changes	Microsoft.SQLServer.Replication.Merge.DownloadedChanges.View	Microsoft.SQLServer.ViewFolder.Replication.Merge	Microsoft.SQLServer.Replication.Merge.DownloadedChanges.View
	Uploaded Changes	Microsoft.SQLServer.Replication.Merge.UploadedChanges.View	Microsoft.SQLServer.ViewFolder.Replication.Merge	Microsoft.SQLServer.Replication.Merge.UploadedChanges.View
	Delivered Commands	Microsoft.SQLServer.Replication.Snapshot.DeliveredCommands.View	Microsoft.SQLServer.ViewFolder.Replication.Snapshot	Microsoft.SQLServer.Replication.Snapshot.DeliveredCommands.View
	Delivered Transactions	Microsoft.SQLServer.Replication.Snapshot.DeliveredTransactions.View	Microsoft.SQLServer.ViewFolder.Replication.Snapshot	Microsoft.SQLServer.Replication.Snapshot.DeliveredTransactions.View
	Reporting Services	Microsoft.SQLServer.ReportingServicesState.View	Microsoft.SQLServer.ViewFolder.SQLRoles	Microsoft.SQLServer.ReportingServicesState.View
	Computers	Microsoft.SQLServer.Server.State.View	Microsoft.SQLServer.ViewFolder.Root	Microsoft.SQLServer.Server.State.View
	Active Alerts	Microsoft.SQLServer.ServerRole.ActiveAlerts.View	Microsoft.SQLServer.ViewFolder.Root	Microsoft.SQLServer.ServerRole.ActiveAlerts.View
	All Performance Data	Microsoft.SQLServer.ServerRole.AllPerformanceData.View	Microsoft.SQLServer.ViewFolder.Performance	Microsoft.SQLServer.ServerRole.AllPerformanceData.View
	Task Status	Microsoft.SQLServer.ServerRole.TaskStatus.View	Microsoft.SQLServer.ViewFolder.Root	Microsoft.SQLServer.ServerRole.TaskStatus.View
	Subscriptions	Microsoft.SQLServer.Subscription.State.View	Microsoft.SQLServer.ViewFolder.Replication.Objects	Microsoft.SQLServer.Subscription.State.View

Folders (12)

	DisplayName	ID	ParentFolder	Accessibility
	SQL Agent	Microsoft.SQLServer.ViewFolder.Agent	Microsoft.SQLServer.ViewFolder.Root	Public
	Databases	Microsoft.SQLServer.ViewFolder.Databases	Microsoft.SQLServer.ViewFolder.Root	Public
	Health Monitoring	Microsoft.SQLServer.ViewFolder.Health	Microsoft.SQLServer.ViewFolder.Root	Public
	Performance	Microsoft.SQLServer.ViewFolder.Performance	Microsoft.SQLServer.ViewFolder.Root	Public
	Replication	Microsoft.SQLServer.ViewFolder.Replication	Microsoft.SQLServer.ViewFolder.Root	Public
	Distributor	Microsoft.SQLServer.ViewFolder.Replication.Distributor	Microsoft.SQLServer.ViewFolder.Replication	Public
	Log Reader	Microsoft.SQLServer.ViewFolder.Replication.LogReader	Microsoft.SQLServer.ViewFolder.Replication	Public
	Merge	Microsoft.SQLServer.ViewFolder.Replication.Merge	Microsoft.SQLServer.ViewFolder.Replication	Public
	Discovered Objects	Microsoft.SQLServer.ViewFolder.Replication.Objects	Microsoft.SQLServer.ViewFolder.Replication	Public
	Snapshot	Microsoft.SQLServer.ViewFolder.Replication.Snapshot	Microsoft.SQLServer.ViewFolder.Replication	Public
	Microsoft SQL Server	Microsoft.SQLServer.ViewFolder.Root	Microsoft.SystemCenter.Monitoring.ViewFolder.Root	Public
	Server Roles	Microsoft.SQLServer.ViewFolder.SQLRoles	Microsoft.SQLServer.ViewFolder.Root	Public

Image References (6)

	DisplayName	ID	ImageID
	SQL Analysis Services	Microsoft.SQLServer.AnalysisServices	Microsoft.SQLServer.AnalysisServices.Image16
	SQL Database	Microsoft.SQLServer.Database	Microsoft.SQLServer.Database.Image80
	SQL DB Engine	Microsoft.SQLServer.DBEngine	Microsoft.SQLServer.DBEngine.Image.80
	SQL DB File	Microsoft.SQLServer.DBFile	Microsoft.SQLServer.DBFile.Image80
	SQL Integration Services	Microsoft.SQLServer.IntegrationServices	Microsoft.SQLServer.IntegrationServices.Image16
	SQL Reporting Services	Microsoft.SQLServer.ReportingServices	Microsoft.SQLServer.ReportingServices.Image16

Views (38)

	DisplayName	ID	Target	Type	Accessibility	Visible
	Agent Alerts	Microsoft.SQLServer.Agent.Alerts.View	Microsoft.SQLServer.Agent	Microsoft.SystemCenter.AlertViewType	Public	False
	Agent Health	Microsoft.SQLServer.Agent.Health.Dashboard.View	Microsoft.SQLServer.Agent	Microsoft.SystemCenter.DashboardViewType	Public	True
	SQL Agent State	Microsoft.SQLServer.Agent.State.View	Microsoft.SQLServer.Agent	Microsoft.SystemCenter.StateViewType	Public	True
	SQL Agent Job State	Microsoft.SQLServer.AgentJob.State.View	Microsoft.SQLServer.AgentJob	Microsoft.SystemCenter.StateViewType	Public	True
	Analysis Services	Microsoft.SQLServer.AnalysisServicesState.View	Microsoft.SQLServer.AnalysisServices	Microsoft.SystemCenter.StateViewType	Public	True
	Database Alerts	Microsoft.SQLServer.Database.Alerts.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.AlertViewType	Public	False
	Database State	Microsoft.SQLServer.Database.DatabaseState.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.StateViewType	Public	True
	Database Free Space	Microsoft.SQLServer.Database.DBSizePerformanceData.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Database Free Space	Microsoft.SQLServer.Database.DBSizePerformanceData2.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Database Health	Microsoft.SQLServer.Database.Health.Dashboard.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.DashboardViewType	Public	True
	Transaction Log Free Space	Microsoft.SQLServer.Database.LogSizePerformanceData.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Transaction Log Free Space	Microsoft.SQLServer.Database.LogSizePerformanceData2.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Database State	Microsoft.SQLServer.Database.State.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.StateViewType	Public	False
	Database Engine Alerts	Microsoft.SQLServer.DBEngine.Alerts.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.AlertViewType	Public	False
	Database Engine Health	Microsoft.SQLServer.DBEngine.Health.Dashboard.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.DashboardViewType	Public	True
	Database Engine State	Microsoft.SQLServer.DBEngine.State.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.StateViewType	Public	False
	User Connections	Microsoft.SQLServer.DBEngine.UserConnections.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Database Engines	Microsoft.SQLServer.DBEngineState.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.StateViewType	Public	True
	Distributors	Microsoft.SQLServer.Distributor.State.View	Microsoft.SQLServer.Distributor	Microsoft.SystemCenter.StateViewType	Public	True
	Integration Services	Microsoft.SQLServer.IntegrationServicesState.View	Microsoft.SQLServer.IntegrationServices	Microsoft.SystemCenter.StateViewType	Public	True
	Publications	Microsoft.SQLServer.Publication.State.View	Microsoft.SQLServer.Publication	Microsoft.SystemCenter.StateViewType	Public	True
	Publishers	Microsoft.SQLServer.Publisher.State.View	Microsoft.SQLServer.Publisher	Microsoft.SystemCenter.StateViewType	Public	True
	Replication Agents Running	Microsoft.SQLServer.Replication.AgentsRunning.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Delivered Commands	Microsoft.SQLServer.Replication.Distributor.DeliveredCommands.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Delivered Transactions	Microsoft.SQLServer.Replication.Distributor.DeliveredTransactions.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Delivered Commands	Microsoft.SQLServer.Replication.LogReader.DeliveredCommands.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Delivered Transactions	Microsoft.SQLServer.Replication.LogReader.DeliveredTransactions.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Conflicts	Microsoft.SQLServer.Replication.Merge.Conflicts.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Downloaded Changes	Microsoft.SQLServer.Replication.Merge.DownloadedChanges.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Uploaded Changes	Microsoft.SQLServer.Replication.Merge.UploadedChanges.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Delivered Commands	Microsoft.SQLServer.Replication.Snapshot.DeliveredCommands.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Delivered Transactions	Microsoft.SQLServer.Replication.Snapshot.DeliveredTransactions.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Reporting Services	Microsoft.SQLServer.ReportingServicesState.View	Microsoft.SQLServer.ReportingServices	Microsoft.SystemCenter.StateViewType	Public	True
	Computers	Microsoft.SQLServer.Server.State.View	Microsoft.Windows.Computer	Microsoft.SystemCenter.StateViewType	Public	True
	Active Alerts	Microsoft.SQLServer.ServerRole.ActiveAlerts.View	Microsoft.SQLServer.ServerRole	Microsoft.SystemCenter.AlertViewType	Public	True
	All Performance Data	Microsoft.SQLServer.ServerRole.AllPerformanceData.View	Microsoft.SQLServer.ServerRole	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Task Status	Microsoft.SQLServer.ServerRole.TaskStatus.View	Microsoft.SQLServer.ServerRole	Microsoft.SystemCenter.TaskStatusViewType	Public	True
	Subscriptions	Microsoft.SQLServer.Subscription.State.View	Microsoft.SQLServer.Subscription	Microsoft.SystemCenter.StateViewType	Public	True

Images (14)

	ID	File Name	Accessibility
	Microsoft.SQLServer.AnalysisServices.Image16	Microsoft.SQLServer.AnalysisServices.Image16.png	Public
	Microsoft.SQLServer.AnalysisServices.Image80	Microsoft.SQLServer.AnalysisServices.Image80.png	Public
	Microsoft.SQLServer.Database.Image16	Microsoft.SQLServer.Database.Image16.png	Public
	Microsoft.SQLServer.Database.Image80	Microsoft.SQLServer.Database.Image80.png	Public
	Microsoft.SQLServer.DBEngine.Image.80	Microsoft.SQLServer.DBEngine.Image.80.png	Public
	Microsoft.SQLServer.DBEngine.Image16	Microsoft.SQLServer.DBEngine.Image16.png	Public
	Microsoft.SQLServer.DBFile.Image16	Microsoft.SQLServer.DBFile.Image16.png	Public
	Microsoft.SQLServer.DBFile.Image80	Microsoft.SQLServer.DBFile.Image80.png	Public
	Microsoft.SQLServer.IntegrationServices.Image16	Microsoft.SQLServer.IntegrationServices.Image16.png	Public
	Microsoft.SQLServer.IntegrationServices.Image80	Microsoft.SQLServer.IntegrationServices.Image80.png	Public
	Microsoft.SQLServer.ReportingServices.Image16	Microsoft.SQLServer.ReportingServices.Image16.png	Public
	Microsoft.SQLServer.ReportingServices.Image80	Microsoft.SQLServer.ReportingServices.Image80.png	Public
	Microsoft.SQLServer.SystemDatabase.Image16	Microsoft.SQLServer.SystemDatabase.Image16.png	Public
	Microsoft.SQLServer.SystemDatabase.Image80	Microsoft.SQLServer.SystemDatabase.Image80.png	Public