Tips and Tricks for SQL Server tuning

SMT 1.14.1 – Memory Grants & Plan Explorer

by Michal Tinthofer on 13/08/2026

Introduces advanced SQL Server Memory Grants analysis, production-ready Plan Explorer, Row Accuracy and major monitoring improvements.

SQL Server SMT Performance Monitoring Memory Grants Execution Plans Query Tuning Read more

Clustered Columnstore Index in an OLTP Database? Hell Yeah.

by Mikuláš Mráz on 30/07/2026

If you haven't been living under a rock for the last 10 years (14 if you count the read-only days), you've probably heard about SQL Server's columnstore engine.

SMT_Stories Read more

SMT 1.14.0 – Custom Pages, Plan Guides and New Charts

by Michal Kovaľ on 19/06/2026

We are pleased to announce SMT 1.14.0, one of the most significant SMT releases to date. This version introduces Custom Pages, a completely redesigned chart engine, advanced query recompilation analysis, Plan Guide management, monitoring controls directly

SMT 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.

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