Contact Us

During last SQL Server Bootcamp 2024 in Brno - our colleague Jan Repka presented a live query tuning session. The scripts used in DEMOs are available here: Live query tuning scripts (DOWNLOAD)

More tips and tricks

SMT 00.5.32 Released!
by Michal Tinthofer on 31/08/2017

After some time, we have finally released big set of changes and fixes for currently known issues. Most visible is new Waiting Task report for operational analysis, added timeline button for Index Usage & recommendation, new functionality to search for an

Read more
SMT 1.12 Introduces more features for tuning
by Michal Tinthofer on 14/04/2025

We are excited to announce the release of SMT 1.12.0. In this update, we have focused on refining existing features while introducing a new optional capability that could dramatically enhance the way you proactively tune your SQL Server with SMT.

Read more
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

Read more