Tips and Tricks for SQL Server tuning - SMT_Stories

The power of SMT data and how we put together Index changes report.

by Michal Tinthofer on 10/09/2021

There are usually multiple ways how to provide a view of a set of data as a report, involving decisions like; keep it easy to read, interpret the relationships between multiple figures in the correct way and to show user as much information as possible at

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

SMT_Stories Read more

How One App Held an Availability Group Hostage

by Michal Kovaľ on 25/05/2021

In the world of SQL Server, TEMPDB is often called the "public dumping ground." We expect it to be busy, but we also expect it to clean up after itself.

SMT_Stories Read more

Why is using proper ANSI settings important

by Jiri Dolezalek on 20/05/2021

You might have been wondering what all those ANSI settings are and how they can affect you work.

SMT_Stories Read more

Archiving strategy for DWH

by Michal Tinthofer on 22/04/2021

Recently, we have got a case where our customer requested to implement archiving strategy for their DWH. We wanted to share with you how we approached this and what was the final output.

SMT_Stories 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