Log file performance analysis (видео, английский)

Log file performance analysis (видео, английский)

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.

Запись опубликована в рубрике Paul Randal (видео) с метками . Добавьте в закладки постоянную ссылку.

Добавить комментарий

Войти с помощью: