The Top 10 SQL Server Wait Types, Worldwide
SQL Server uses wait stats to track what queries are waiting on. Rather than monitoring gazillions of Perfmon counters and DMV objects, the easiest way to make your queries go faster is to ask, "What is my server waiting on?" Then, focus your efforts on your server's top wait type. When you're learning how to…