Tips and Tricks for SQL Server tuning

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.

SMT_Stories Read more

SQL Day 2026

by Mikuláš Mráz on 22/05/2026

Last week, between the 11th and 13th of May 2026, we once again returned to SQL Day in Wrocław.

SQL Server SMT SQL Day Conference Wroclaw Read more

Turning Hours into Minutes: How We Solved a SQL Server Indexing Nightmare

by Michal Kovaľ on 16/04/2026

In the world of database administration, index maintenance is a necessary evil. Done right, it keeps your queries snappy; done wrong, it becomes a resource-hungry monster that eats your maintenance window alive.

SMT_Stories Read more

SQL Konferenz 2026

by Mikuláš Mráz on 12/03/2026

Earlier this month we attended SQL Konferenz 2026, held at Congress Park Hanau, just outside Frankfurt. The venue is large and perfectly suited for conferences, which the name itself already suggests.

SQL Server SMT Conference SQL Konferenz Hanau Read more

The Symmetry of Performance: Solving CPU Wait Spikes by Disabling Soft-NUMA

by Michal Kovaľ on 17/02/2026

In high-performance SQL Server environments, how you "slice" your CPU resources is just as important as how many cores you have. We recently tackled a case where a customer was plagued by high SOS_SCHEDULER_YIELD and CXPACKET waits.

SMT_Stories Read more

SMT 1.13 Introduces more QOL features and Replication Monitor

by Michal Tinthofer on 12/09/2025

As we finalize the upcoming release, we want to share with you what is coming.

SMT Read more