Last week I blogged about using wait stats, latch stats, and spinlock stats as part of your performance tuning toolset so I thought I’d do a demo for you that shows using wait and latch stats. The demo investigates a poorly performing log file, takes action, and them compares the before and after wait stats to see the effect the action made. The short video (9 minutes) explains what is going on and also shows an interesting outstanding I/O limit that the log manager enforces.
