How do I interpret an SP_SYSMON report?
Posted on 2009-02-10
I know there is documentation available to explain sp_sysmon but I find it very difficult to interpret the data/results from the sysmon report.
Can somebody show me a sample or example of a sysmon report and explain how to interpret it? I'm a complete beginner here but I've been to the P&T courses and still struggling to understand sp_sysmon and what the results mean? How do i identify a bottleneck or a slow sluggish performance? What's the most important thing to look at? etc etc.
Any help/tips/guidance would be much appreciated and I will be indebted! Unlimited points on offer!