Microsoft SQL Server 2016 Integration Services (Monitoring)

Microsoft.SQLServer.2016.IntegrationServices.Monitoring :: 7.0.0.0 (Management Pack)

This Management Pack enables monitoring of Microsoft SQL Server 2016 Integration Services.

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

Management Pack Elements

Unit Monitors (1)

	DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
	SQL Server Integration Services Windows Service	Microsoft.SQLServer.2016.IntegrationServices.ServiceMonitor	Microsoft.SQLServer.2016.IntegrationServices.Instance	AvailabilityHealth	True	True	Public

Rules (8)

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

Agent Tasks (2)

	DisplayName	ID	Target	Accessibility	Category	Enabled
	Start SQL Integration Services Service	Microsoft.SQLServer.2016.IntegrationServices.StartService	Microsoft.SQLServer.2016.IntegrationServices.Instance	Internal	Maintenance	True
	Stop SQL Integration Services Service	Microsoft.SQLServer.2016.IntegrationServices.StopService	Microsoft.SQLServer.2016.IntegrationServices.Instance	Internal	Maintenance	True