Tips and Tricks for SQL Server tuning

SMT 1.6 mid-year release

by Jiri Dolezalek on 30/06/2022

New version of our SQL Monitoring and Performance Tuning tool ready right in the middle of the year

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

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