- BFSIBanking, Financial Services & Insurance
- HealthcareComing soon
- ManufacturingComing soon
- Retail & E-CommerceComing soon
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.
How it’s rated
Full scoreboard ↓Quick answer
Foglight Performance Investigator (SQL PI) is the query-level diagnostics engine at the heart of Foglight — the capability users most consistently single out as its standout strength. Basic monitoring tells you a database is slow; SQL PI tells you exactly why, drilling from a high-level symptom down to the specific SQL statement, session, wait and resource responsible, with multi-dimensional analysis you can pivot through (by query, wait event, time, user, program, resource). It pairs this with adaptive baselines that learn each database's normal behaviour — by time of day and day of week — so a genuine deviation stands out from routine variation and you're not chasing a nightly batch job. The result is dramatically faster root-cause: a DBA moves from 'the database is slow' to 'this exact query, running this plan, waiting on this, changed at this time' in minutes rather than hours. SQL PI works across the database platforms Foglight supports (SQL Server, Oracle and more), turning cross-platform monitoring into cross-platform diagnostics. For teams whose real pain is finding the query that's killing them, fast, Performance Investigator is the reason to choose Foglight.
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.
One agent on every machine, one console over all of them — modules attach without a second operational world.
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 on your own fleet?
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 single most useless alert a DBA gets is ‘the database is slow.’ It starts an investigation, not a fix. SQL Performance Investigator collapses that investigation: it drills from the symptom straight to the specific SQL statement, session, wait and resource responsible. You go from a vague symptom to a precise, actionable root cause — the exact query, waiting on the exact thing — which is the difference between fixing the problem and hunting for it.
Slice it any way — multi-dimensional
Real diagnosis needs to be explored from multiple angles: which query? during what time window? from which user or program? waiting on which resource? SQL PI captures activity across all these dimensions, so you can pivot the same incident by query, by wait, by time, by user or by resource in one workflow — understanding it from every angle rather than staring at a single flat metric. That dimensional analysis is what makes root cause fast and certain.
Adaptive baselines cut the noise
The reason teams ignore monitoring dashboards is alert fatigue — static thresholds cry wolf constantly, 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 a genuine deviation stands out from routine variation. Fewer false alarms means the alarms you do get are trusted and acted on — which is the whole point of alerting.
Catch the plan regression you missed
One of the most common and maddening database problems is a plan regression: a query that ran fine yesterday silently gets a worse execution plan today and degrades. SQL PI surfaces execution-plan changes, so you catch the regressed query and can act, rather than spending hours wondering why a previously-fine system suddenly slowed. Seeing plan changes over time is a diagnostic superpower.
Cross-platform diagnostics, one workflow
SQL PI works across the database engines Foglight supports — SQL Server, Oracle and more — so you get the same query-level diagnostic depth and the same investigation workflow whichever engine you're debugging. That turns Foglight's cross-platform monitoring into cross-platform diagnostics: your DBAs learn one diagnostic tool, not one per engine, and apply the same root-cause muscle everywhere.
It's why teams choose Foglight
Across reviews, SQL Performance Investigator is the capability users single out most as the reason they chose and value Foglight. It's the difference between a monitoring tool that shows dashboards and an observability tool that answers ‘why?’ — and for teams whose real pain is finding the query that's killing them, fast, 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.
Trusted across regulated industries in 100+ countries
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 is the reason we chose Foglight. It drills from ‘the database is slow’ to the exact query, session and wait in minutes. Root-cause went from a half-day hunt to a coffee break.”
“The multi-dimensional pivot is the magic — same incident, sliced by query, wait, time and user. I understand a problem from every angle in one workflow.”
“Adaptive baselines killed our alert fatigue — the nightly batch stopped paging us because SQL PI learned that's normal. Now we trust and act on the alarms we do get.”
“It caught a plan regression we'd have spent hours chasing — the query that silently got a worse plan overnight, surfaced immediately. A genuine diagnostic superpower.”
“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.”
“It's the difference between a dashboard that says ‘slow’ and a tool that 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 G2 retired its Grid. 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
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 actual device counts 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 device counts 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.