It’s like a mentor ,Constantly helping you improve .Only for your SQL database

Data Optimizer – Automatically optimize millions of SQL Server queries

Data Optimizer provides accurate recommendations for performance improvement of the SQL Server on a daily basis. This allows the server to be constantly tuned holistically. Receive a daily report of the before and after improvement and the scripts to implement to the production server.

Software Highlights

Analyzes procedures and provides recommendations in real time

Receive a daily report including scripts for immediate implementation

Track the implemented recommendations

Accurate tested scripts for adding/removing Indexes and rewriting queries

View a before and after implementation report

Web application

Key benefits

  • Real time optimization
    Data Optimizer performs workload analysis on a daily basis in a sterile environment based on a trace provided from the previous day of work
  • Daily report
    Receive a daily report with a before and after improvement and the scripts to implement to the production server tested
  • Comprehensive SQL Server Performance recommendations
    Data Optimizer provides a wide range of detailed recommendations to improve SQL Server performance, including changes to the indexes scheme, SQL rewrites and more
  • Detailed explanations and mapping
    Every SQL Server tuning recommendation is accompanied by a detailed textual explanation, and all recommendations are ranked according to benefit. Recommendations are mapped to the SQL Server queries that they effect
  • Executable scripts
    Wherever possible (eg, for index recommendations and stored code rewrites) executable scripts are provided for deploying the selected recommendations to production
  • Index recommendations
    These include recommendations to add, modify or drop specific indexes.. Data Optimizer's advanced indexing algorithm recommends an optimal set of indexes that takes into account the entire workload, not just individual queries, so as to maximize performance benefits while avoiding over-indexing
  • SQL rewrite recommendations
    Recommendations for SQL rewrites include a side-by-side comparison of the original SQL and the alternative syntax, as well as detailed explanation. Both stored code and application-side code are supporte

Server requirements

  • Dedicated SQL Server similar version as production or above
  • Windows XP/Vista/7, Windows Server 2003/2008/2008R2 - 32 or 64 bit
  • .Net Framework 3.5 SP1
  • SQL Server 2005/2008/2008R2/2012/2014/2017/2017 client tools
  • 8 GB RAM, 5 GB free disk space, 2 GHz CPU
  • Network access and security credentials with 'SysAdmin'
  • permissions for the non-production analysis database

comprehensive 24X7 SQL Performance Monitoring

Purchase Multiple Licenses

Please complete the form to request a quote

All fields are required

add chat to your website