TrustRadius: an HG Insights company

Woodler SMT

Score8.9 out of 10

5 Reviews and Ratings

What is Woodler SMT?

  • 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

Categories & Use Cases

Top Performing Features

  • Virtualization support

    Root cause analysis for virtual platforms like VMWare or Hyper-V

    Category average: 0

  • Historical trend data

    Historical trends and anomalies for SQL tuning

    Category average: 0

  • Performance dashboard

    Dashboard displays consolidated data with drill-down capability

    Category average: 0

Areas for Improvement

  • Top SQL

    Details about any long-running or high impact statements

    Category average: 0

  • Intelligent alerting

    Customizable alerts and reports indicating outlier values from baseline

    Category average: 0

Woodler SMT review from SQL developer

Pros

  • Very self-explainable user interface
  • 24/7 assistance from SQL professionals
  • Great insights into a behavior of each SQL Server instance in a company

Cons

  • Too [much] information for [inexperienced] users (but this is [a] very common issue with SQL Server and its monitoring)

Return on Investment

  • It saves the time of troubleshooting
  • It increases user's satisfaction with products relaying on SQL Server's performance

Alternatives Considered

SolarWinds Database Performance Analyzer

Woodler SMT Review from User and Manager

Pros

  • It contains all the diagnostics information that you need for optimization of queries, deep analysis of SQL server state, and much more
  • Regular deployment of a new versions with minor fixes but mainly with the new features.
  • It helps to make operational decisions, how to improve the performance and also expansion of the whole environment.
  • Buying this also contains excellent service from the Woodler support.

Cons

  • There is a lot of information and if you want to exploit it for 100%, you need some basic SQL administration knowledge at least. Maybe some "Lite" version with KPI's and warnings for some smaller companies would be appreciated.
  • Some deep searching and some screens are a little bit confusing for the first time and you need to put the things into consequences to get the final result.

Return on Investment

  • Revealed many problems with third party applications and their databases.
  • Instead of buying new versions of an app, you can optimize it.
  • By using SMT, we have prevented many situations and outages in advance.

Alternatives Considered

SolarWinds SQL Sentry

Impressive "deep dive" SQL monitor

Pros

  • Web interface
  • Detailed performance metrics in time series graphs.
  • Logical groups of metrics, easy to find the metric you want.
  • Alerting system
  • Tuning tracking, tuning notes
  • Automatic actualization

Cons

  • Sysadmin access to your system.
  • Consumes disk capacity on monitored server to store all the data.

Return on Investment

  • Quick reactions on problems.
  • SQL performance problems root cause analysis.
  • Increased DBAs productivity in daily operations.
  • Time saver

Alternatives Considered

SQL Sentry, IDERA SQL Diagnostic Manager for SQL Server and Redgate SQL Monitor

Other Software Used

System Center Operations Manager

Woodler SMT is a powerful tool for SQL Server

Pros

  • SQL Server monitoring
  • SQL Server performance tuning
  • SQL Server root cause analysis
  • Assistance from SQL professionals

Cons

  • The date filters are working differently than other similar apps, but easy to use after understanding how it works

Return on Investment

  • Definitely it had a positive impact after identifying and solving some performance issue in some databases
  • Very good support from Woodler team

Alternatives Considered

SQL Sentry