Contact Us

During last SQL Server Bootcamp 2024 in Brno - our colleague Jan Repka presented a live query tuning session. The scripts used in DEMOs are available here: Live query tuning scripts (DOWNLOAD)

More tips and tricks

SMT 00.5.34 Released!
by Michal Tinthofer on 18/10/2017

Today we introduce to you another patch which was focused on several “quality of life “improvements. Let's have a look!

Read more
When Network Infrastructure Throttles SQL Server (Analyzing HADR_SYNC_COMMIT)
by Michal Kovaľ on 22/07/2021

We recently resolved a critical performance issue where a client reported an unusual spike in HADR_SYNC_COMMIT wait types.

Read more
When SQL Server 2022 Talks Too Much to Windows: Solving the PREEMPTIVE_OS_QUERYREGISTRY Mystery
by Michal Kovaľ on 28/05/2026

You open your performance analytics tool to check the top wait types, expecting the usual suspects like PAGEIOLATCH or CXPACKET. Instead, staring back at you is a strange, rarely seen wait type: PREEMPTIVE_OS_QUERYREGISTRY.

Read more