Good day SMT users,

We have just started releasing SMT version 1.3 and it is quite a leap at least is particular areas.

What have we done?

  • The biggest change is that we are leaving SSIS and from now on windows service (SMT service) will be responsible for data collections, synchronisations with CORE and additionally also for all related application updates. So, we will have everything at one place. Beyond all other pros this simplifies the deployment process of SMT.
  • We have implemented Bubble chart, the first place where to see it is Query summary report. Do not forget to check the question mark icon, it will tell you how to get oriented in displayed data.

  • In our SMT GenReport framework we have now an option to define table with submit actions, which is creating options to interact with users easier without requiring custom development of each part that needs user’s input. This has been already used for a configuration screens accessible to SMT power users, shown under SMT settings category. Where you can manage SMT parameters, but also create local configuration for data collection, which will have higher precedence compare to the preset coming from CORE.
  • We have also done a perf tuning – using SMT Query and Index recommendation reports, so there should be also a performance gain on both sides – collection and reporting.

Huge change, not directly affecting SMT on your local instance, is an installation process integrated with our customer portal and SMT installer. All customers, who want to use SMT primarily for themselves without having a support contract with us are already able to buy a licence and install it through our web.

For SMT dev team,

Regards JD

More tips and tricks

FIX: Msg 15170, Level 16, This login is the Owner of 2 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped
by Michal Tinthofer on 26/01/2018

Recently I had an issue with this error during upgrade of SSISDB AlwaysOn Support using wizard.

Read more
SQL 2012 Certification Changes
by Michal Tinthofer on 20/04/2012

Few days ago I have noticed that there will be a change (again) in certification paths for next generation of SQL servers. So I would like to recommend some thoughts about this from Microsoft Certified Masters (MCM) of Brent Ozar PLF Company.

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