article thumbnail

Why Waits Alone Are Not Enough

SQL Performance

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. of Total Wait Time.

Tuning 115
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

KB ​​ boundaries efficiently. ​​ Although ​​ SQL Server ​​ tries ​​ to use the log space as efficiently as possible, ​​ certain application patterns cause the log-block fill percentages to remain small. ​​ This creates 8?KB

Servers 40