Dashboard Inspector and query performance tuning
Where and how to open the Dashboard Inspector, what its Performance tab and Query table measure per layout and page, how Show Details breaks a query's time into Metadata, Waiting and Query, and the best practices that make a slow dashboard fast.
Given a scenario, monitor and optimize query performance using Dashboard Inspector.
~6 min read · 8 practice questions ·
What the exam expects
- Open the Dashboard Inspector from the right place and know where it isn't available.
- Read the Performance tab and Query table, including how layouts and pages limit what they show.
- Use Show Details and Last Run Metrics to tell a slow query from one waiting on a binding, and use View More Details for failed queries.
- Recommend the documented performance practices: fewer queries per page, combined KPI queries, pages for secondary content, global filters, precomputed fields.
Key terms: Dashboard Inspector (the view-mode tool that measures a dashboard's load and lists its queries' run times); Query table (the inspector's list of queries that ran, with Max Time); Show Details (a widget menu option that summarizes one query and its Last Run Metrics); Last Run Metrics (Metadata, Waiting and Query times in milliseconds); default page (the page whose queries run when the dashboard loads).
Key facts
- Detail
- View mode while browsing the app
- Detail
- Running the app, editing, embedded preview outside CRM Analytics
- Detail
- More button, then Dashboard Inspector
- Detail
- Max Time (SEC) per query on the current page
- Detail
- Adds newly run queries; marks unused ones
- Detail
- View More Details shows binding and query errors and the run query
- Detail
- Time to resolve bindings
- Detail
- Fetched only on the first run
- Detail
- Up to 200 results
- Detail
- Six or fewer where you can
- Why can the Metadata time vanish after a query's first run?
- Which Performance tab factors can you skip?
- When should a very large dashboard become several dashboards?
- What should you do after optimizing the slowest queries?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the CRM Analytics and Einstein Discovery Consultant pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 26 lessons of the CRM Analytics and Einstein Discovery Consultant guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Practice exams purchase adds inline bank questions and topic practice (8 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Choose guide-only, practice-only, or save $4 with both