Remove 2006 Remove Hardware Remove Systems Remove Tuning
article thumbnail

Why Waits Alone Are Not Enough

SQL Performance

The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.". Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waiting queries mean waiting applications and users, and no one likes to wait!

Tuning 115
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

© ​​ 2006 ​​ Microsoft Corporation. KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? Complying with all applicable copyright laws is the responsibility of the user.

Servers 40