The Business Intelligence team reports that when some team members run queries for their dashboards in parallel with others, the query response time is getting significantly slower.
What can a Snowflake Architect do to identify what is occurring and troubleshoot this issue?
When facing query response time issues with parallel query execution, it's crucial to identify if there is significant data spillage to remote storage, as this is a common cause of performance degradation. Option A provides a detailed query to check for queries where the bytes spilled to remote storage exceed the bytes scanned by a factor of 5, which is a strong indicator of such issues. By reviewing the spilling read ratio, one can pinpoint the problematic queries and adjust warehouse sizes accordingly to mitigate the problem.
Checked in Snowflake. In fact, without seeing the SQL, is the only that has sense