All Rules in Microsoft.SQLServer.IS.Windows Management Pack

 DisplayNameDescriptionIDTargetCategoryEnabledInstance NameCounter NameFrequencyEvent_IDEvent SourceAlert GenerateAlert SeverityAlert PriorityRemotableEvent Log
Microsoft.SQLServer.IS.Windows.IS_Package_Failed_5_RuleMSSQL Integration Services on Windows: Integration Service Package FailedA package failed during execution.Microsoft.SQLServer.IS.Windows.IS_Package_Failed_5_RuleMicrosoft.SQLServer.IS.Windows.LocalInstanceEventCollectionTrue00TrueErrorNormalTrue
Microsoft.SQLServer.IS.Windows.IS_Service_failed_to_load_user_defined_Configuration_file_5_RuleMSSQL Integration Services on Windows: IS Service failed to load user defined Configuration fileThe 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_RuleMicrosoft.SQLServer.IS.Windows.LocalInstanceEventCollectionTrue00TrueErrorNormalTrue
Microsoft.SQLServer.IS.Windows.IS_Service_has_attempted_to_stop_a_running_package_5_RuleMSSQL Integration Services on Windows: IS Service has attempted to stop a running packageThe 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_RuleMicrosoft.SQLServer.IS.Windows.LocalInstanceEventCollectionFalse00TrueErrorNormalTrue
Microsoft.SQLServer.IS.Windows.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_RuleMSSQL Integration Services on Windows: Package execution failed because the checkpoint file cannot be loadedA 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_RuleMicrosoft.SQLServer.IS.Windows.LocalInstanceEventCollectionTrue00TrueErrorNormalTrue
Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineBuffersSpooledMSSQL Integration Services on Windows: Integration Services Buffers SpooledThe 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.PipelineBuffersSpooledMicrosoft.SQLServer.IS.Windows.LocalInstancePerformanceCollectionTrueSQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0Buffers spooled9000FalseTrue
Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineRowsReadMSSQL Integration Services on Windows: Integration Services Rows ReadThis 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.PipelineRowsReadMicrosoft.SQLServer.IS.Windows.LocalInstancePerformanceCollectionTrueSQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0Rows read9000FalseTrue
Microsoft.SQLServer.IS.Windows.PerformanceRule.PipelineRowsWrittenMSSQL Integration Services on Windows: Integration Services Rows WrittenThis 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.PipelineRowsWrittenMicrosoft.SQLServer.IS.Windows.LocalInstancePerformanceCollectionTrueSQLServer:SSIS Pipeline $Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$.0Rows written9000FalseTrue
Microsoft.SQLServer.IS.Windows.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_RuleMSSQL Integration Services on Windows: The package restarted from checkpoint file. Package was configured to restart from checkpoint and it didA 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_RuleMicrosoft.SQLServer.IS.Windows.LocalInstanceEventCollectionFalse00TrueInformationNormalTrue