page280
368
Figure 10-5.
Snowsight performance-related tooling
The tools shown in Figure 10-5 provide a quick way to identify recent performance
hot spots but do not provide wider contextual information required for a thorough
investigation.
Snowsight is constantly evolving with new functionality and screens. We recommend
periodic review of Snowsight capabilities; in fact, while writing this book new screens
became available.
Warehouse Monitor
Snowsight offers a Warehouse screen accessible from the Admin link on the left side of
the browser. Select Warehouses where summary information for the previous two weeks
is displayed (shorter time periods can be displayed).
In the Query History section, the Status drop-down list provides several options, two
of which are Queued and Blocked. Both options provide immediate visibility of recent
issues with corresponding queries available for selection.
Cost Management Screen
Snowsight offers a Cost Management screen accessible from the Admin link on the left
side of the browser. Select Cost Management and then Account Overview, where summary
information about costs and the most expensive queries are displayed. At the time of
writing, Account Overview is in public preview, and the capability will increase over time.
ChapTer 10
OpTimizing perfOrmanCe