Microsoft SQL Server Integration Services on Windows

Microsoft.SQLServer.IS.Windows :: 7.0.7.0 (Management Pack)

This Management Pack discovers and monitors Microsoft SQL Server Integration Services and related objects on Windows.

• Show Management Pack XML
• Get Management Pack data in Excel format
• Microsoft.SQLServer.IS.Windows.mpb

Management Pack Elements

Classes (2)

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	MSSQL on Windows Integration Services: Local Instance	Microsoft.SQLServer.IS.Windows.LocalInstance	Microsoft.Windows.ApplicationComponent	False	False	False	False	False	Public
	MSSQL on Windows Integration Services: Local Seed	Microsoft.SQLServer.IS.Windows.LocalSeed	Microsoft.Windows.ApplicationComponent	False	True	False	False	False	Public

Relationship Types (2)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	MSSQL on Windows Integration Services: Server Computer Contains SQL Server Integration Services Installation Seed	Microsoft.SQLServer.IntegrationServices.Relationship.ServerComputerContainsISInstance	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.IS.Windows.LocalInstance	Public	False
	MSSQL on Windows Integration Services: Server Computer Hosts SQL Server Integration Services Local Discovery Seed	Microsoft.SQLServer.IntegrationServices.Relationship.ServerComputerHostsISLocalSeed	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.IS.Windows.LocalSeed	Public	False

DataSource Modules (3)

	DisplayName	ID	Isolation	Accessibility
	MSSQL on Windows Integration Services: Instance Status Provider	Microsoft.SQLServer.IS.Windows.DataSource.InstanceStatus	Any	Internal
	MSSQL on Windows Integration Services: Local SQL Server Integration Services Discovery Source	Microsoft.SQLServer.IS.Windows.DataSource.LocalInstanceDiscovery	Any	Internal
	Microsoft.SQLServer.IS.Windows.EventProvider	Microsoft.SQLServer.IS.Windows.EventProvider	Any	Internal

ProbeAction Modules (2)

	DisplayName	ID	Isolation	Accessibility
	MSSQL on Windows Integration Services: Integration Service Status Probe Action	Microsoft.SQLServer.IS.Windows.ProbeAction.InstanceStatus	Any	Internal
	MSSQL on Windows Integration Services: Local Integration Service Instance Probe Discovery on Windows	Microsoft.SQLServer.IS.Windows.ProbeAction.LocalInstanceDiscovery	Any	Internal

WriteAction Modules (1)

	DisplayName	ID	Isolation	Accessibility
	MSSQL on Windows Integration Services: Windows Service Control	Microsoft.SQLServer.IS.Windows.WriteAction.ServiceControl	Any	Internal

Unit Monitor Types (1)

	DisplayName	ID	Accessibility	Support Monitor Recalculate
	MSSQL on Windows Integration Services: Integration Service Status Provider	Microsoft.SQLServer.IS.Windows.MonitorType.InstanceStatus	Internal	False

Discoveries (2)

	DisplayName	ID	Target	Enabled
	MSSQL on Windows Integration Services: Discover Local SQL Server Integration Services	Microsoft.SQLServer.IS.Windows.LocalInstanceDiscovery	Microsoft.SQLServer.IS.Windows.LocalSeed	True
	MSSQL on Windows Integration Services: Discover Installation Source (seed)	Microsoft.SQLServer.IS.Windows.LocalSeedDiscovery	Microsoft.Windows.Server.Computer	True

Unit Monitors (1)

	DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
	Integration Service Health Status	Microsoft.SQLServer.IS.Windows.InstanceStatus	Microsoft.SQLServer.IS.Windows.LocalInstance	AvailabilityHealth	True	True	Public

Rules (8)

	DisplayName	ID	Target	Category	Enabled	Alert Generate
	MSSQL Integration Services on Windows: Integration Service Package Failed	Microsoft.SQLServer.IS.Windows.IS_Package_Failed_5_Rule	Microsoft.SQLServer.IS.Windows.LocalInstance	EventCollection	True	True
	MSSQL Integration Services on Windows: IS Service failed to load user defined Configuration file	Microsoft.SQLServer.IS.Windows.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule	Microsoft.SQLServer.IS.Windows.LocalInstance	EventCollection	True	True
	MSSQL Integration Services on Windows: IS Service has attempted to stop a running package	Microsoft.SQLServer.IS.Windows.IS_Service_has_attempted_to_stop_a_running_package_5_Rule	Microsoft.SQLServer.IS.Windows.LocalInstance	EventCollection	False	True
	MSSQL Integration Services on Windows: Package execution failed because the checkpoint file cannot be loaded	Microsoft.SQLServer.IS.Windows.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule	Microsoft.SQLServer.IS.Windows.LocalInstance	EventCollection	True	True
	MSSQL Integration Services on Windows: Integration Services Buffers Spooled	Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineBuffersSpooled	Microsoft.SQLServer.IS.Windows.LocalInstance	PerformanceCollection	True	False
	MSSQL Integration Services on Windows: Integration Services Rows Read	Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineRowsRead	Microsoft.SQLServer.IS.Windows.LocalInstance	PerformanceCollection	True	False
	MSSQL Integration Services on Windows: Integration Services Rows Written	Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineRowsWritten	Microsoft.SQLServer.IS.Windows.LocalInstance	PerformanceCollection	True	False
	MSSQL Integration Services on Windows: The package restarted from checkpoint file. Package was configured to restart from checkpoint and it did	Microsoft.SQLServer.IS.Windows.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_Rule	Microsoft.SQLServer.IS.Windows.LocalInstance	EventCollection	True	True

Agent Tasks (2)

	DisplayName	ID	Target	Accessibility	Category	Enabled
	Start Integration Service	Microsoft.SQLServer.IS.Windows.Task.LocalInstance.StartService	Microsoft.SQLServer.IS.Windows.LocalInstance	Internal	Maintenance	True
	Stop Integration Service	Microsoft.SQLServer.IS.Windows.Task.LocalInstance.StopService	Microsoft.SQLServer.IS.Windows.LocalInstance	Internal	Maintenance	True

Deployable Assemblies (2)

	ID	File Name	Accessibility
	Microsoft.SQLServer.Core.Module.Helper.Assembly	Microsoft.SQLServer.Core.Module.Helper.dll	Public
	Microsoft.SQLServer.IS.Windows.Module.Assembly	Microsoft.SQLServer.IS.Windows.Module.dll	Public