Tips and Tricks for SQL Server tuning

How a High-Frequency LIKE Query Saturated SQL Server

by Michal Kovaľ on 05/03/2021

A customer’s SQL Server instance reached 100% CPU utilization. Blocking increased, response times deteriorated, and unrelated workloads slowed down. The cause was a Camunda worker query executed roughly 100 times per second in one database and 40–50 times

SMT_Stories Read more

SMT 1.2 version is out

by Michal Tinthofer on 09/02/2021

Releasing SMT 1.2 to you right now! Check the details.

SMT Read more

SMT 1.1 - updates

by Michal Tinthofer on 07/12/2020

Another changes to SMT are done and ready for the release

SMT Read more

SMT 1.0 development finished

by Michal Tinthofer on 30/10/2020

We just finished second major SMT development in 2020

SMT Read more

Conquering Deadlocks: How We Achieved a 93% Reduction in Database Blockages

by Michal Kovaľ on 15/10/2020

In high-concurrency environments, deadlocks are more than just technical glitches...they are silent performance killers.

SMT_Stories Read more

The Case of the Vanishing Databases: A Deep Dive into HADR Deadlocks

by Michal Kovaľ on 14/07/2020

Imagine opening SQL Server Management Studio (SSMS) on a Monday morning and finding… nothing.

SMT_Stories Read more