Contact Us

Dear SMT users,

After about two months we have another update for Server Monitoring Tool available for you. The version is now 00.5.70 and the updates are ongoing. Some of our clients have already been informed in a bit more detail about the changes by one of my colleagues on a regular meeting, the rest will get the introduction on the upcoming session.  

Here is a brief summary of all the changes included.

  • The way how we collect data about the query performance statistics related statements and query plans has been changed.
  • A set of new reports to help performance tuning has been added;
    • Query search - based on the part of the code you can search and view collected performance statistics.
    • Performance compare – report to compare query statistics in two different intervals.
    • New report to better analyse the BLOCK chains and reveal HEADBLOCKER.
  • We are now collecting and reporting performance statistics related to triggers.
  • New report to track Configuration History.
  • New report to analyse Volatile Jobs.
  • We changed a bit the menu structure to group related reports and make it more intuitive.
  • Already existing alert for tempdb size was extended with a new check.
  • The storage reports is now able to show data from DWH.
  • Miscellaneous minor bugfixes, enhancements and adjustments.

For the new reports we tried to add enough information to make it easier for you to use those.

Please contact us in case you have any questions or suggestions, we would be happy to discuss them.

We will start scoping a new release soon. I am sure that a another set of helpful stuff and enhancements will be delivered for you to us in SMT.

Kind Regards,

Jiri Dolezalek

 

More tips and tricks

Live Query Tuning
by Michal Kovaľ on 05/09/2024

During last SQL Server Bootcamp 2024 in Brno - our colleague Jan Repka presented a live query tuning session.

Read more
Clustered Columnstore Index in an OLTP Database? Hell Yeah.
by Mikuláš Mráz on 30/07/2026

If you haven't been living under a rock for the last 10 years (14 if you count the read-only days), you've probably heard about SQL Server's columnstore engine.

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

Read more