Microsoft SQL Server Core Library

Microsoft.SQLServer.Library :: 6.6.2.0 (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

Summary

The SQL Server Core Library Management Pack provides the base object definitions for the other SQL Management Packs. This Library Management Pack must be imported before or during the import of the SQL Server 2000 or 2005 (Discovery) and SQL Server 2000 or 2005 (Monitoring) Management Pack.

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

ClassType (36)
RelationshipType (10)

SecureReference (3)

Monitoring

Discovery (10)

Presentation

FolderItem (33)
Folder (13)
ImageReference (6)
View (41)

Resources

Image (20)

Classes (36)

System.Entity

System.LogicalEntity

System.ApplicationComponent

Microsoft.Windows.ApplicationComponent

Microsoft.SQLServer.Component

System.Database

Microsoft.SQLServer.Database

System.ComputerRole

Microsoft.Windows.ComputerRole

Microsoft.SQLServer.ServerRole

System.Group

Microsoft.SystemCenter.ComputerGroup

Microsoft.SQLServer.ComputerGroup

System.Perspective

Microsoft.SQLServer.DBPerspective

DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
SQL Server 2008 Agents Group	Microsoft.SQLServer.2008.AgentsGroup	System.Group	False	False	True	True	False	Public
SQL Server 2008 Databases Group	Microsoft.SQLServer.2008.DatabasesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2008 Instance Group	Microsoft.SQLServer.2008.InstancesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2008 Integration Services Group	Microsoft.SQLServer.2008.IntegrationServicesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2008 Mirroring Groups Group	Microsoft.SQLServer.2008.MirroringGroupsGroup	System.Group	False	False	True	True	False	Public
SQL Server 2012 Agents Group	Microsoft.SQLServer.2012.AgentsGroup	System.Group	False	False	True	True	False	Public
Group of Availability Groups	Microsoft.SQLServer.2012.AlwaysOn.AlwaysOnHightAvailability	System.Group	False	False	True	True	False	Public
Group of Availability Groups	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupGroup	System.Group	False	False	True	True	False	Public
Group of Availability Replicas	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaGroup	System.Group	False	False	True	True	False	Public
Group of Database Replicas	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaGroup	System.Group	False	False	True	True	False	Public
SQL Server 2012 Databases Group	Microsoft.SQLServer.2012.DatabasesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2012 Instance Group	Microsoft.SQLServer.2012.InstancesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2012 Integration Services Group	Microsoft.SQLServer.2012.IntegrationServicesGroup	System.Group	False	False	True	True	False	Public
SQL Server 2012 Mirroring Groups Group	Microsoft.SQLServer.2012.MirroringGroupsGroup	System.Group	False	False	True	True	False	Public
SQL Agent	Microsoft.SQLServer.Agent	Microsoft.SQLServer.Component	True	False	False	False	False	Public
SQL Server Agents	Microsoft.SQLServer.AgentGroup	System.Group	False	False	True	True	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 Server Databases	Microsoft.SQLServer.DatabaseGroup	System.Group	False	False	True	True	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 (10)

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
MSSQL : SQL Server Instance Group Contains Instances	Microsoft.SQLServer.GlobalInstanceGroupContainsDBEngine	Microsoft.SQLServer.Generic.Presentation.SQLServerInstanceGroup	Microsoft.SQLServer.DBEngine	Public	False
Instance Group Contains All Instances of SQL DBEngine	Microsoft.SQLServer.InstanceGroupContainsDBEngine	Microsoft.SQLServer.InstanceGroup	Microsoft.SQLServer.DBEngine	Public	False
Alerts Scope Group Contains Service Roles Relationship	Microsoft.SQLServer.Library.Relationships.AlertsScopeGroupContainsServiceRoles	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	Microsoft.SQLServer.ServerRole	Internal	False
Server Roles Group Contains Server Roles Relationship	Microsoft.SQLServer.Library.Relationships.ServerRolesGroupContainsServerRoles	Microsoft.SQLServer.Generic.Presentation.ServerRolesGroup	Microsoft.SQLServer.ServerRole	Internal	False
Windows Computer Hosts Database Perspective	Microsoft.SQLServer.WindowsComputerHostsDBPerspective	Microsoft.Windows.Computer	Microsoft.SQLServer.DBPerspective	Public	False
Microsoft.SQLServer.AgentGroupContainsAgent	Microsoft.SQLServer.AgentGroupContainsAgent	Microsoft.SQLServer.AgentGroup	Microsoft.SQLServer.Agent	Public	False
Microsoft.SQLServer.DatabaseGroupContainsDatabase	Microsoft.SQLServer.DatabaseGroupContainsDatabase	Microsoft.SQLServer.DatabaseGroup	Microsoft.SQLServer.Database	Public	False
Microsoft.SQLServer.SQLServerIntegrationServicesGroupContainsInstance	Microsoft.SQLServer.SQLServerIntegrationServicesGroupContainsInstance	Microsoft.SQLServer.Generic.Presentation.SQLServerIntegrationServicesGroup	Microsoft.SQLServer.IntegrationServices	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 (10)

DisplayName	ID	Target	Enabled
MSSQL: Populate SQL Server Instance Group	Microsoft.SQLServer.2012.GlobalInstanceGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.SQLServerInstanceGroup	True
MSSQL: Populate SQL Server Instance Group	Microsoft.SQLServer.2012.GlobalSQLServerIntegrationServicesGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.SQLServerIntegrationServicesGroup	True
MSSQL: Populate SQL Server Agent Group	Microsoft.SQLServer.AgentGroupDiscovery	Microsoft.SQLServer.AgentGroup	True
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
MSSQL: Populate SQL Server Database Group	Microsoft.SQLServer.DatabaseGroupDiscovery	Microsoft.SQLServer.DatabaseGroup	True
Discover SQL Server Instance Group membership	Microsoft.SQLServer.InstanceGroupDiscovery	Microsoft.SQLServer.InstanceGroup	True
Alerts Scope Group Discovery	Microsoft.SQLServer.Library.AlertsScopeGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	True
Discover SQL Server Computer Group membership	Microsoft.SQLServer.Library.GenericComputerGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.ComputersGroup	True
Server Roles Group Discovery	Microsoft.SQLServer.Library.ServerRolesGroupDiscovery	Microsoft.SQLServer.Generic.Presentation.ServerRolesGroup	True

Folder Items (33)

Folders (13)

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
SQL Server 2005/2008/2012	Microsoft.SQLServer.ViewFolder.Root	Microsoft.SQLServer.Generic.Presentation.Folder.DatabaseEngine	Public
Database Engines	Microsoft.SQLServer.ViewFolder.SQLRoles	Microsoft.SQLServer.ViewFolder.Root	Public
Integration Services	Microsoft.SQLServer.ViewFolder.SSIS	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 Group	Microsoft.SQLServer.DBFileGroup	Microsoft.SQLServer.FileGroup.Image64
SQL Integration Services	Microsoft.SQLServer.IntegrationServices	Microsoft.SQLServer.IntegrationServices.Image80
SQL Reporting Services	Microsoft.SQLServer.ReportingServices	Microsoft.SQLServer.ReportingServices.Image80

Views (41)

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
Database Alerts	Microsoft.SQLServer.Database.Alerts.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.AlertViewType	Public	False
Active Alerts	Microsoft.SQLServer.Database.AlertsView	Microsoft.SQLServer.Database	Microsoft.SystemCenter.AlertViewType	Public	True
All Performance Data	Microsoft.SQLServer.Database.AllPerformanceData.View	Microsoft.SQLServer.Database	Microsoft.SystemCenter.PerformanceViewType	Public	True
Databases	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
File Groups	Microsoft.SQLServer.Database.FileGroupState.View	Microsoft.SQLServer.DBFileGroup	Microsoft.SystemCenter.StateViewType	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
Active Alerts	Microsoft.SQLServer.DBEngine.AlertsView	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.AlertViewType	Public	True
All Performance Data	Microsoft.SQLServer.DBEngine.AllPerformanceData.View	Microsoft.SQLServer.DBEngine	Microsoft.SystemCenter.PerformanceViewType	Public	True
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
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 (20)

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.DBLogFile.Image16	Microsoft.SQLServer.DBLogFile.Image16.png	Public
Microsoft.SQLServer.DBLogFile.Image64	Microsoft.SQLServer.DBLogFile.Image64.png	Public
Microsoft.SQLServer.FileGroup.Image16	Microsoft.SQLServer.FileGroup.Image16.png	Public
Microsoft.SQLServer.FileGroup.Image64	Microsoft.SQLServer.FileGroup.Image64.png	Public
Microsoft.SQLServer.IntegrationServices.Image16	Microsoft.SQLServer.IntegrationServices.Image16.png	Public
Microsoft.SQLServer.IntegrationServices.Image80	Microsoft.SQLServer.IntegrationServices.Image80.png	Public
Microsoft.SQLServer.Policy.Image16	Microsoft.SQLServer.Policy.Image16.png	Public
Microsoft.SQLServer.Policy.Image80	Microsoft.SQLServer.Policy.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