SQL Server Monitoring & Performance Tuning tool designed by in-the-field performance tuners for administrators, developers, and tuners
Data-driven root cause analysis ideal for root cause analysis (RCA)
Interpretation of collected data with advanced descriptions and sharing options.
Offers a high-level overview and deep internal metrics allowing the resolution of the toughest challenges.
Recommended to use it during the deep-dive tuning phase
Accessible by Customer‘s internal team and Woodler team(optional)
Useful in the development/testing phase of the applications (A/B analysis)
Running in 7x24 always on mode
Automated alerting and notification
From a recording of tuning changes on the server to specialized tools for daily management and development.
Reports connecting different metrics into singular pieces for better troubleshooting overview
It enables users to compare and measure the impact of future changes and optimizations on the system

Where could SMT help?

Proper SQL Server configuration
Index consolidation: to speedup database modification operations and maintenance
Reconfiguration of index objects: to provide a more concurrent environment and less fragmented databases
Optimize database transaction logs: to speed up transaction processing
Leveraging baseline monitoring, users can:
Recommend new indexes to improve the overall performance of queries executed on the server
Perform query tuning for top intensive/resource-consuming operations on the server
Feature tuning for user most application exposed operations
Recommend database code refactoring if possible (depending on database and application type)
Further tuning of database maintenance operations based on historic runtime data