Tips and Tricks for SQL Server tuning

First SMT release of 2023

by Jiri Dolezalek on 10/01/2023

First SMT release of 2023 has been made available

SMT Read more

More than minor amount of changes released.

by Jiri Dolezalek on 24/09/2022

New version has been released and more features than we planned initially made it in.

SMT Read more

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