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 any specific query or plan which you could find in the tool reports and extended range of execution plan attributes in its report. 

 

Here is the full list:

 

  • Fix for news versioning.
  • Fix for unknown wait types. Updated types of waits to SQL 2017 version, so   Wait report shows them correctly.
  • Fix for Index Usage by database, table, index timeline button. Now you may   see also only statistics for specified time, previously you have only cumulative   values.
  • Fix for Index Recommendation timeline report update. Here you also see real   values during specified timeframe.
  • Perf tuning for Memory Report. We have improved performance 20 times   when big sets of data are reported.
  • Fix for not valid number of queries per query hash reported by Query   Summary Report.
  • Update for Query Hash Report to allow filtering on database.
  • Fix for maintenance report showing duplicate rows. Also, added "Grand Total &   Total" description for summarized rows.
  • Fix for Maintenance Report filter showing unfiltered and unordered list.
  • Fix for Maintenance Report where report id 3 missing (used for maintenance   log detail).
  • Fix for Job Report Filter showing unordered set. Fixed Inaccurate data based   on time range.
  • Fix for Job Detail Report not showing data from timeline.
  • Fix for Alerts Log Report to show also older active alerts when using time filter.
  • Fix for Maintenance stats report. Added schema to [CommandToTune]   recommendation.
  • Fix for Collector Status reporting procedure. Added collector status report for   admins for troubleshooting SMT processing issues.
  • Updated Parallel collector to give threads a better chance to finish if no work is   available.
  • Added description to alerts (on click of alert name) in Sever dashboard.
  • Minor tweaks for Memory Report descriptions.
  • Added new execution plan attributes to plan report (StatementOptmLevel,   CardinalityEstimationModelVersion, StatementSubTreeCost,   EstimatedDegreeOfPrl, StatementOptmEarlyAbortReason,   NonParallelPlanReason)
  • Added new execution plan attributes to plan report Database Name and Plan   Encrypted to help understand why we missing plan for  the query.
  • Added new performance metric PhyReads to query report which allow you to   analyze queries which bloated storage on read operations.
  • Improved column description in Query Report.
  • Updated Wait Report procedures to perform faster and more universally.
  • Created new version of Waiting Tasks Report to allow better operational   analysis.
  • Updated small bug with data ordering for internal Table Size Report.
  • Fixed bug where Maintenance Reports showed more data in filters than reality.
  • Fixed bug in Cpu Report not showing always correct values.
  • Updated Deadlock Report graph to better show deadlock issues.
  • Performance tuning tweaks for Storage Report. Added beater descriptions for   specific graphs and columns.
  • Fix for mail sender which updated all values in mailed column instead of one   which is sending.

More tips and tricks

Tool to measure Index Selectivity
by Michal Tinthofer on 05/06/2012

Sometimes when you plan to change your index design is good to know the columns of your tables. But not just a data type and max size.

Read more
SMT 00.6.00 Released!
by Jiri Dolezalek on 20/05/2020

Dear SMT users, We are glad to announce that a new version 00.6.00 is finally out.

Read more
Collation conflict
by Michal Tinthofer on 07/03/2012

I think there is more simple and harmless way. First we need to understand the process of tempdb collation setting.

Read more