06. Hardware: Find the Old Server’s Bottleneck with Wait Stats (28m)

While this isn’t really a performance class, we still need to understand wait stats before we buy new server gear. When you want to build new hardware, you need to check the bottlenecks for the old hardware first. SQL Server constantly tracks what it’s waiting on. Rather than guessing the bottleneck with various Perfmon counters,…

You’ll need a membership to access this course. Check out my training classes.