Working with Rules

The following is a summary of rules available out-of-the-box with the Snowflake cartridge. Default threshold values can be changed or scoped to specific values, generally through registry variables. These rules can be copied, modified, disabled, or customized in a wide variety of ways. For more information refer to Working with Alarm Templates or contact Quest Software PSO.

This section describes the following rules:

Snowflake Availability

Alert if the availability is less than 100% for two consecutive periods.

Snowflake High Account Workload

Alert if the account workload is significantly higher than its historical weekly average.

Snowflake High Database Storage Growth

Alert if the database workload is significantly higher than its historical weekly average.

Snowflake High Database Workload

Alert if the database growth is significantly higher than its historical weekly average.

Snowflake High Percentage of Queries Blocked

Alert when there is a high percentage of blocked queries.

Snowflake High Percentage of Queries Failed

Alert when there is a high percentage of failed queries.

Snowflake High Percentage of Queries Queued

Alert when the percentage of queued queries is high.

Snowflake Pipe Execution State

Alert when the pipe execution state is not running or paused.

Snowflake User Failed Logins

Alert when a user has multiple failed login attempts within a specified period.

Snowflake Warehouse Credit Usage

Alert when a average daily credit usage of a warehouse is significantly higher than its historical weekly average.

Snowflake Lock Wait Time Alarm Generator

Alert when a lock has been holding a resource for a long time.

Snowflake Blocked Transaction Alarm Generator

Alert when a transaction has been waiting for a long time to complete.

Snowflake Resource Monitor Usage

Alert when the resource monitor is approaching the credit usage quota.