VA Performance Auditor
HEALTHY (< 100ms): Queries are executing efficiently. Standard plan stability is maintaining throughput.
WARNING (100-499ms): Moderate pressure. Check for unoptimized join logic or implicit conversions.
CRITICAL (500ms+): High resource drain. SQL Optimizer is likely struggling with complex plans or stale stats.
DBA Action Plan: Surgical Performance Recovery
- High CPU: Analyze execution plans in SSMS for Index Scans that should be surgical Seeks.
- High Reads: This signals missing infrastructure. Check the Index Health module for recommendations.
- Context-Wide: This view captures all server-wide activity to ensure no "hidden" bottlenecks are missed.
Total Cached Plans
15
Worst Avg CPU
645.15 ms
Worst Avg Reads
28,415
Top 5 CPU Impact (ms)
Detailed Performance Auditor
| # | NAME | TYPE | AVG CPU | AVG READS | STATUS |
|---|---|---|---|---|---|
| 1 | Ad-Hoc: SELECT TOP 100000 a.* FROM sy | Ad-Hoc | 645.15 ms | 28,415 | ⌠Critical |
| 2 | Ad-Hoc: SELECT CustomerName, Regio | Ad-Hoc | 107.29 ms | 3,918 | âš ï¸ Warning |
| 3 | Ad-Hoc: SELECT r.DiagnosisCode, v.L | Ad-Hoc | 32.03 ms | 2,149 | ✅ Optimal |
| 4 | usp_VA_Demo_HeavyAnchor | Stored Proc | 4.92 ms | 2,054 | ✅ Optimal |
| 5 | Ad-Hoc: SELECT target_data F | Ad-Hoc | 81.87 ms | 229 | ✅ Optimal |
| 6 | Ad-Hoc: SELECT LastName, ServiceBr | Ad-Hoc | 1.09 ms | 63 | ✅ Optimal |
| 7 | Ad-Hoc: (@_msparam_0 nvarchar(4000),@_ | Ad-Hoc | 0.53 ms | 63 | ✅ Optimal |
| 8 | Ad-Hoc: (@1 tinyint,@2 varchar(8000))S | Ad-Hoc | 0.66 ms | 63 | ✅ Optimal |
Reference: Raw Truth Verification Query
SELECT TOP 10 ISNULL(OBJECT_NAME(st.objectid, st.dbid), 'Ad-Hoc') as [Name], qs.execution_count, (qs.total_worker_time/1000.0)/qs.execution_count as [AvgCPU_ms] FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st ORDER BY total_worker_time DESC;