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

Should You Use ClickHouse as a Main Operational Database?

Percona

However, ClickHouse is super efficient for timeseries and provides “sharding” out of the box (scalability beyond one node). Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Inserts are efficient for bulk inserts only. 2006-01-01 ?

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

© ​​ 2006 ​​ Microsoft Corporation. KB ​​ boundaries efficiently. ​​ Application design ​​ can become ​​ critical to efficient log space usage. ​​ All rights reserved. ​​ This creates 8?KB

Servers 40