| DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
| MSSQL Integration Services on Windows: Integration Service Package Failed | A package failed during execution. | Microsoft.SQLServer.IS.Windows.IS_Package_Failed_5_Rule | Microsoft.SQLServer.IS.Windows.LocalInstance | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
| MSSQL Integration Services on Windows: IS Service failed to load user defined Configuration file | The configuration file for the Integration Services service could not be loaded, when the services was started. By default, this file is named MSDtsSrvr.ini.xml. However, Integration Services can be configured by a registry setting to use any file name and file location. | Microsoft.SQLServer.IS.Windows.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule | Microsoft.SQLServer.IS.Windows.LocalInstance | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
| MSSQL Integration Services on Windows: IS Service has attempted to stop a running package | The Integration Services service was used to send a request to the Integration Services runtime to stop a running package. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.IS.Windows.IS_Service_has_attempted_to_stop_a_running_package_5_Rule | Microsoft.SQLServer.IS.Windows.LocalInstance | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
| MSSQL Integration Services on Windows: Package execution failed because the checkpoint file cannot be loaded | A package that is configured to use checkpoints and to always use the checkpoint file failed to restart. | Microsoft.SQLServer.IS.Windows.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule | Microsoft.SQLServer.IS.Windows.LocalInstance | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
| MSSQL Integration Services on Windows: Integration Services Buffers Spooled | The number of buffers currently written to the disk. If the data flow engine runs low on physical memory, buffers not currently used are written to disk and then reloaded when needed. This counter is polled every fifteen minutes. | Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineBuffersSpooled | Microsoft.SQLServer.IS.Windows.LocalInstance | PerformanceCollection | True | SQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0 | Buffers spooled | 900 | 0 | | False | | | True | |
| MSSQL Integration Services on Windows: Integration Services Rows Read | This counter indicates the number of rows that a source produces. The number does not include rows read from reference tables by the Lookup transformation. This counter is polled every fifteen minutes. | Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineRowsRead | Microsoft.SQLServer.IS.Windows.LocalInstance | PerformanceCollection | True | SQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0 | Rows read | 900 | 0 | | False | | | True | |
| MSSQL Integration Services on Windows: Integration Services Rows Written | This counter displays the number of rows offered to a destination. The number does not reflect rows written to the destination data store. This counter is polled every fifteen minutes. | Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineRowsWritten | Microsoft.SQLServer.IS.Windows.LocalInstance | PerformanceCollection | True | SQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0 | Rows written | 900 | 0 | | False | | | True | |
| MSSQL Integration Services on Windows: The package restarted from checkpoint file. Package was configured to restart from checkpoint and it did | A package configured to use checkpoints failed and then restarted from the point of failure using the checkpoint file. | 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 | False | | | 0 | 0 | | True | Information | Normal | True | |