Tips and Tricks for SQL Server tuning

Load Factor – Uneven load distribution

by Michal Kovaľ on 15/06/2022

Recently, we found an interesting pattern during exploring one of our SMT graphs while doing a health check of a SQL server. The following graph shows us the Load Factor attribute. The value came from system table sys.dm_os_schedulers, which the SMT tool

SMT_Stories Read more

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

Xmas release 1.5.0

by Jiri Dolezalek on 14/12/2021

SMT Christmas release is ready

SMT Read more

SMT Waits

by Michal Tinthofer on 25/11/2021

SMT Waits reports – handy overview of what is going on at the server

SMT 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