We would like to wish you a pleasant time and oportunity to slow down and enjoy the simple things. May this wonderful time of the year touch your heart in a special way. Wishing you much happiness not just today, but throughout the New Year.

This time we are bringing a special patch with new features such a tuning tnotes where you can record all your tunning efforts and explore it's benefits through new tuning dashboard. Also we introduce new reports for tempdb contention issues and updated resource governor and memory reports for better visibility and performance. 

Here is the full list:

  • Hotfix for advanced collector analysis of check executions..
  • Added new summary graph to Query summary report to help visualize impact of query changes over a day periods. You may choose between database or hash aggregation.
  • Added new check to collect information regarding all opened transactions on the server with log footprint higher than 1MB. Also new report has been added for this (Query>Tran. log Usage).
  • Focus will be now kept on the active tab when parameters are changed or page refreshed.
  • URL of a report is now kept when user have to login after session expired.
  • Added new tuning notes to allow users store results of their tuning efforts. Added also summary report with dashboards from all tuning activities on the server.
  • Report enhancements like table sorting, filters configuration, added column bars into some table reports, report performance.
  • Added time filter buttons for some reports.
  • Added new report for tempdb usage and contention events.(Category Tempdb added to the report pane)
  • Reorganized memory report for better visibility and performance.
  • Fixed several issues with resource governor report and administration reports (mainly filtering issues).
  • Fixed various issues with check performance and data collection.
  • Fixed block report issue where table reported one hour data later than graph.

 

We hope you will continue to enjoy our tool!

With regards, 

Michal Tinthofer.

 

More tips and tricks

Releasing SMT 1.3
by Michal Kovaľ on 01/07/2021

A release of SMT 1.3 have just commenced

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
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