Contact Us

Today we introduce to you another patch which was focused on several “quality of life “improvements. Most notable was integration of execution plans and statements from waiting tasks report into standardized dimensions we already used in query reports. Now you will always be presented with Query detail or Plan Detail report when you click on text or query plan column in SMT reports. It will dramatically decrease the size of monitoring database.
Another nice feature is paging ability for big tables. Since amount of reported data will grow over time, we introduced this functionality to keep our tool fast as possible even when reporting thousands of rows into table.

 

Here is the full list:

  • Fixed Bug where mail component update all alerts mailed column instead of respective one which is currently notifying.
  • Fix for waiting tasks report, now it will use centralised reports for command texts and execution plans. This will greatly decrease the size of this check in monitored database. Also we splitted report Waiting tasks into two with detail informations about session.
  • In waiting tasks detailed report we also introduced table paging to allow covenient browse through big tables.
  • Fixed an issue where too deep execution plan cannot be collected due to XML type limitations in SQL Server.
  • Fix updated query collection for Phy Reads. Now its count based on real collected data for this dimension.
  • Fix for Memory pool stats not showing all graphs correctly.
  • Fix for Query performance reports showing statement text in execution plans as ** Encrypted Text **.
  • Fixed a bug where index collectors hanged over tempoerary objects for analysis.
  • Fixed bug where index recommendation check didn't finished because duplicate statistics has been reported from the server.
  • Fixed rare bug on some systems where checkpoint pages/sec graf not reported any data.

 

We hope you will continue to enjoy our tool!

With regards, 

Michal Tinthofer.

More tips and tricks

SMT 1.2 version is out
by Michal Tinthofer on 09/02/2021

Releasing SMT 1.2 to you right now! Check the details.

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

Read more