Tips and Tricks for SQL Server tuning - SMT_Stories

Easy performance gain for data extensive process

by Michal Kovaľ on 24/05/2022

This is one of our tuning successes, particularly for the nightly process of loading data into a report server from the main database.

SMT_Stories Read more

LATCH_EX Waits

by Michal Kovaľ on 27/04/2022

Recently we had a request to optimize LATCH_EX waits on one of the production servers for our customer. Today I would like to share with you our apporach and how we handled the situation.

SQL Server SMT_Stories Read more

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