Snowflake Warehouse Availability Test
The business capability supported by Snowflake for any customer is designed around virtual warehouses. The performance and availability of each of the warehouse is critical to business, so it is absolutely important for administrators to keep an eye on warehouse related statistics like running statements, queued statements and warehouse compute capacity available. These metrics help them predict the load on warehouse and take any measures to avoid warehouse failure. This test monitors the user account and collects statistics related to warehouse availability status, status of query statements etc. These metrics provide valuable insights to the administrators about the current working condition of warehouse.
Target of the test : Snowflake Database server
Agent deploying the test : A remote agent
Outputs of the test : One set of results for each warehouse in the Snowflake service account being monitored.
Parameter |
Description |
---|---|
Test period |
How often should the test be executed. |
Host |
The IP address of the Snowflake. |
Port |
The port number through which the snowflake database server communicates. The default port is 443. |
Warehouse Name |
In this text box, enter the name of a virtual warehouse that needs to be monitored. |
Database Name |
In this text box, enter the name of a default database that will connect the snowflake server. |
User |
Specify the name of the user who has any of the following privileges to the specified. |
Password |
The password of the specified USER. |
Confirm Password |
Confirm the password by retyping it here. |
Measurement |
Description |
Measurement Unit |
Interpretation |
---|---|---|---|
Status |
Indicates the status of the warehouse whether it is started, running, or inactive. |
Boolean |
|
Running statements |
Indicates the total number of running statement during the last measurement period. |
Number |
A very high number of running statements can be concerning as it is holding on to compute resources. |
Queuing statements |
Indicates the total number of queuing statement during the last measurement period. |
Number |
A very high number of queueing statements can be concerning as the queuing time will increase. |
Available percentage |
Indicates the percentage of the warehouse compute resources that are provisioned and are available. |
Percentage |
Less than 100 percent is a cause for concern. |
Provisioning percentage |
Indicates the percentage of the warehouse compute resources that are in the process of provisioning. |
Percentage |
|
Quiescing percentage |
Indicates the percentage of the warehouse compute resources that are executing SQL statements but will be shut down once the queries are complete. |
Percentage |
|