Foglight Performance Investigator
Stop hunting the slow query — find it in minutes. Foglight Performance Investigator drills from ‘the database is slow’ to the exact SQL, session and wait, with multi-dimensional pivot and adaptive baselines, across SQL Server, Oracle and more.
Buy through TechBag
Same software. Better outcome — at a lower cost.
How it’s rated
Full scoreboard ↓Quick answer
The Quest Foglight family
This page covers Performance Investigator — the diagnostics engine. The rest of the family:
Quick facts
30-second orientation- Product
- Foglight Performance Investigator (SQL PI)
- Vendor
- Quest Software
- What it is
- Foglight's query-level diagnostics engine
- The standout
- The capability users single out most
- Drills to
- Specific SQL, session, wait, resource
- Analysis
- Multi-dimensional pivot (query/wait/time/user)
- Baselines
- Adaptive — learns normal, cuts noise
- Works across
- SQL Server, Oracle and more
- The result
- Root-cause in minutes, not hours
- In India via
- TechBag — quotes, PoCs, GST invoicing, Tier-1 support
Understand query-level diagnostics before you buy it
Most product pages skip this. We start here — so you buy a capability, not a buzzword.
What is Performance Investigator?
Foglight's query-level diagnostics engine (SQL PI) — it drills from ‘the database is slow’ to the exact SQL, session and wait, with multi-dimensional pivot and adaptive baselines.
The capability users single out most as why they choose Foglight.
Monitoring (‘what’) vs diagnostics (‘why’) — the honest table
What consolidation actually replaces, dimension by dimension.
| Dimension | Monitoring (‘it’s slow’) | SQL PI (‘this query, this wait’) |
|---|---|---|
| The alert | ‘Database is slow’ | This query, this wait, this plan |
| Root-cause time | Hours of hunting | Minutes |
| Analysis | One flat metric | Pivot by 5 dimensions |
| Alarms | Static, noisy | Adaptive baselines, trusted |
| Plan regressions | Silent for hours | Surfaced immediately |
| History | Live-only, missed | Any time window investigable |
| Per engine | A tool each | One diagnostics workflow |
| The category | Monitoring (‘what’) | Observability (‘why’) |
Multi-dimensional drill-down across engines — for a wait-time-first lens, SolarWinds DPA also fits.
The five pieces of the platform
Vendors love diagrams; buyers need to know what they’re actually operating. Here’s the whole platform, demystified.
Dimensional Collector
Continuously captures activity across dimensions — query, session, wait, time, user, program, resource — so any slowdown can be sliced any way.
Drill-Down Engine
Drills from a high-level symptom (‘the database is slow at 2pm’) to the specific SQL, session and wait responsible — the exact culprit, fast.
Adaptive Baselines
Learns each database's normal patterns by time-of-day and day-of-week, so a real deviation stands out from routine batch and reporting load.
Pivot Analysis
Pivot the same incident by query, by wait, by time, by user or by resource — understanding a problem from every angle in one workflow.
Cross-Platform
Works across the engines Foglight supports — turning cross-platform monitoring into cross-platform query-level diagnostics.
Each signal and store sits in one view, so questions are settled in place, never sewn together across silos.
Twelve capabilities. Drill, pivot, trust.
Foglight Performance Investigator turns ‘the database is slow’ into ‘this exact query, waiting on this, changed at this time’ — in minutes.
Symptom-to-Statement Drill
From ‘the database is slow’ down to the exact SQL statement causing it — the core of query-level diagnostics.
Query-Level Detail
The specific queries consuming time and resources, ranked — find the top offenders instantly.
Session Analysis
Which sessions, users and programs are driving load — attribute a slowdown to its source.
Wait Breakdown
What each query is waiting on — I/O, locks, CPU — the truest bottleneck signal, per statement.
Multi-Dimensional Pivot
Slice the same incident by query, wait, time, user or resource — every angle, one workflow.
Adaptive Baselines
Learns normal by time-of-day and day-of-week so genuine deviations stand out from routine load.
Noise Reduction
Fewer false alarms — the nightly batch stops crying wolf, so real alarms are trusted and acted on.
Time-Range Analysis
Investigate any historical window — what was that database doing at 2am last Tuesday?
Plan-Change Detection
Surfaces execution-plan changes and regressions — the query that silently got a worse plan.
Cross-Platform Diagnostics
The same query-level depth across SQL Server, Oracle and more — one diagnostics workflow.
Minutes, Not Hours
Root-cause in minutes — the practical outcome DBAs consistently report.
The Foglight Foundation
The diagnostics layer beneath every Foglight database edition — the reason teams choose Foglight.
Watch Performance Investigator in action
Drilling from symptom to the exact query — SQL PI and Foglight diagnostics.
Toad Data Studio: One Tool to Manage All Your Databases
Quest's database tooling flagship across every platform.
Getting Started with Toad for Oracle
The in-depth intro to the industry-standard Oracle IDE.
Automation in Toad Data Point
Automating data prep and reporting workflows.
Want a live, India-context walkthrough for your environment?
Book a guided demo →‘It’s slow’ isn’t an answer. ‘This query is’ is.
Here’s what genuinely sets Foglight Performance Investigator apart from the alternatives.
‘The database is slow’ isn't actionable
‘The database is slow’ starts an investigation, not a fix. SQL Performance Investigator drills from the symptom straight to the SQL statement, session, wait and resource responsible — the exact query waiting on the exact thing — so you fix the problem instead of hunting for it.
Slice it any way — multi-dimensional
Diagnosis needs several angles: which query, what time window, which user or program, which resource. SQL PI captures activity across all these dimensions, so you pivot one incident by query, wait, time, user or resource in a single workflow — making root cause fast and certain.
Adaptive baselines cut the noise
Static thresholds cry wolf, because a nightly batch or month-end run looks like an incident. SQL PI’s adaptive baselines learn each database’s normal behaviour by time-of-day and day-of-week, so genuine deviations stand out and alarms are trusted and acted on.
Catch the plan regression you missed
A plan regression — a query that ran fine yesterday silently getting a worse execution plan today — is one of the most maddening database problems. SQL PI surfaces execution-plan changes, so you catch the regressed query instead of spending hours wondering why things slowed.
Cross-platform diagnostics, one workflow
SQL PI works across the engines Foglight supports — SQL Server, Oracle and more — with the same query-level depth and investigation workflow on each. DBAs learn one diagnostic tool, not one per engine, and apply the same root-cause skills everywhere.
It's why teams choose Foglight
Across reviews, SQL Performance Investigator is the capability users single out most as why they chose Foglight: it answers ‘why?’ rather than just showing dashboards. For teams hunting the query that’s killing them, it’s the deciding feature. TechBag helps you PoC it on your worst real slowdown, in INR/GST.
The numbers behind the platform
What your Foglight Performance Investigator journey looks like
Diagnostics scoping
Where root-cause is slow today and which databases hurt most. TechBag scopes it free.
PoC on a real slowdown
Reproduce (or wait for) a real slow event; use SQL PI to drill from symptom to the exact query and wait — time the root-cause.
Baselines learn
Adaptive baselines learn normal per database; alert noise drops; the team adopts the dimensional-pivot workflow.
Minutes-to-root-cause steady state
Root-cause in minutes across engines, plan regressions caught, alarms trusted. TechBag models it in INR/GST.
The review scoreboard
Modelled on Gartner Peer Insights structure. *Counts and breakdowns are illustrative pending verified review collection.
Quick poll — what’s driving your evaluation?
Talk to an advisor“SQL PI drills from ‘the database is slow’ to the exact query, session and wait in minutes, not half a day.”
“One incident, sliced by query, wait, time and user — every angle of a problem in one workflow.”
“Adaptive baselines learned our nightly batch is normal, so it stopped paging us. We trust the alarms now.”
“It surfaced a query that silently got a worse plan overnight — a regression we’d have chased for hours.”
“Same diagnostics across SQL Server and Oracle — my team learned one investigation tool, not one per engine. That consistency is underrated.”
“Time-range analysis let me answer ‘what was this database doing at 2am last Tuesday?’ — the intermittent issue our live-only view never caught.”
“A dashboard says ‘slow’; SQL PI says ‘this query, this plan, this wait.’ That’s observability, not monitoring.”
“We evaluated wait-time tools too — SQL PI's dimensional pivot and plan-change detection edged them for us. Test it on your worst real slowdown.”
Where everyone sits — the grids
Analyst firms bury this view behind paywalls, and review-site grids score satisfaction, not fit for your estate. So here’s TechBag’s synthesis of the query-level diagnostics market — tap any vendor to see why it sits where it does.
TechBag DB Diagnostics Grid
Execution strength vs product vision — the classic market map, minus the paywall.
Multi-dimensional query-level drill-down — this page.
Drill-Down Depth × Cross-Platform Reach
The grid nobody publishes — query-level drill-down depth vs how many engines share one diagnostics workflow.
Dimensional drill-down + cross-platform — the corner it fills.
Positions are TechBag’s illustrative synthesis of public review-platform data and vendor documentation — not a reproduction of any analyst graphic. Verify before relying on it.
Foglight SQL PI vs the field
The wait-time tools, the SQL Server specialists and the APM giants — honest lanes; the edge is multi-dimensional cross-platform drill-down.
| Dimension | Foglight SQL PI | SolarWinds DPA | Idera SQL DM | Datadog DBM | Native (DMVs/AWR) |
|---|---|---|---|---|---|
| Approach | Multi-dimensional drill-down | Wait-time analytics | SQL Server diagnostics | APM-style DBM | Manual queries |
| Query-level detail | Deep, pivotable | Strong | Strong | Good | Raw |
| Multi-dimensional pivot | Yes — 5+ dimensions | Wait-centric | Good | Tags | None |
| Adaptive baselines | Yes | Anomaly | Baselines | ML | None |
| Cross-platform depth | SQL Server, Oracle & more | Multi-DB | SQL Server-first | Broad | Per engine |
| Best fit | Teams needing fast, cross-platform root-cause | Wait-time-first teams | SQL Server shops | Datadog estates | DBA-rich tiny estates |
Which diagnostics approach fits you?
Honest fit signals — because the fastest way to lose your trust is to pretend one product wins every scenario.
Choose Foglight Performance Investigator if…
- ✓Your real pain is finding the slow query, fast
- ✓Multi-dimensional drill-down (query/wait/time/user) matters
- ✓You want the same diagnostics across SQL Server, Oracle & more
- ✓Adaptive baselines to cut alert noise appeal
Choose SolarWinds DPA if…
- ✓Wait-time analytics is your preferred root-cause lens
Choose Idera SQL DM if…
- ✓You're SQL Server-centric — hub live here
Choose Datadog DBM if…
- ✓You want DB diagnostics inside full-stack APM
Native tools if…
- ✓Only for DBA-rich tiny estates with time for manual DMV/AWR work
Foglight Performance Investigator is one of 28 databases & data tools products TechBag carries. The Databases & Data Tools guide narrows them to a shortlist and shows the reasoning. →
What does slow root-cause cost you?
Drag the sliders (count database instances; IT-hour cost as loaded DBA rate). Estimates assume ~4 hours per instance per year lost to slow, manual root-cause and alert-fatigue chasing, with ~70% removed by symptom-to-statement drill-down and adaptive baselines — the avoided-downtime value from minutes-not-hours root-cause is the larger unpriced win. Illustrative.
Loaded cost = salary + overheads per productive hour. Illustrative only — your TechBag quote models your actual environment and modules.
Three ways to consume it
SQL PI comes with the Foglight database editions. TechBag scopes the right edition mix and quotes it in INR/GST.
Performance Investigator
Best for root-cause
- Symptom-to-statement drill-down
- Multi-dimensional pivot
- Plan-change detection
+ Adaptive baselines
Best for trusted alarms
- Learns normal per database
- Cuts false-alarm noise
- Real alarms only
+ Cross-platform
Best for diverse estates
- Same diagnostics across engines
- One investigation workflow
- TechBag scopes the edition mix
Buy it for less — TechBag pricing beats list
Whatever the list prices above, TechBag negotiates a significantly better deal — with GST-compliant INR invoicing and local support. Ask us for your discounted quote.
Get an India-ready quote
Tell us your requirements and current tools — we’ll model it against what you spend today.
The 8 questions to ask every database diagnostics vendor
Take this into your next vendor call — including ours.
On a real slowdown, drill from ‘the database is slow’ to the exact SQL, session and wait — how fast, how precise?
Pivot the same incident by query, wait, time, user and resource — confirm you can slice it every way.
Confirm baselines learn normal (by time-of-day/day-of-week) and cut false alarms — plan a learning period.
Test plan-change detection — does it surface a query that silently got a worse plan?
Investigate a historical window (‘2am last Tuesday’) — confirm you can debug the past, not just live.
Confirm the same diagnostics workflow works across your engines (SQL Server, Oracle…).
Measure the actual time-to-root-cause on your worst real slowdown — the outcome that matters.
SQL PI comes with the Foglight editions — TechBag scopes the mix and quotes it in INR/GST.
Questions buyers ask
Ready to evaluate Foglight Performance Investigator?
Scope a PoC on your worst real slowdown (time the SQL PI drill-down), or let a TechBag advisor plan Foglight diagnostics — in INR/GST.
Stats, ratings, review counts and pricing are illustrative and sourced from public materials; verify before purchase.