QuestionQ100

VerifiedIngesting and processing the data

You are a BigQuery administrator supporting data consumers who run ad hoc queries and downstream reports in tools such as Looker. All data and users are consolidated under one organizational project. You recently observed slower query results and want to troubleshoot where the delays are occurring. You suspect that job queuing or slot contention might be happening as users run jobs, slowing access to results. You need to investigate query-job information and identify where performance is being impacted. What should you do?

Explanation

BigQuery administrative resource charts expose historical slot usage, job concurrency, and job-duration trends, making them suitable for locating contention and queue-related slowdowns. Querying INFORMATION_SCHEMA job views supplies near-real-time job metadata and performance details for investigating the affected queries. Monitor health, resource utilization, and jobs JOBS view

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!