SET STATISTICS IO/TIME Parser
Paste SQL Server Messages output and review the read profile more clearly.
The parser keeps the work in the browser and summarises table activity, logical reads, LOB reads, physical reads, CPU time, and elapsed time.
Useful for
- Before/after query comparisons
- Spotting unexpected worktables
- Reviewing LOB read behaviour
- Preparing evidence for a Performance Review
Summary
| Table | Scans | Logical | LOB Logical | Physical | LOB Physical | Read-ahead | LOB Read-ahead | Page Server | Segments | Skipped |
|---|