IDERA Releases SQL Query Store Optimizer as Latest Free Database Tool

Product allows DBAs to leverage new SQL functionality in a more intuitive way

HOUSTON, TX – July 20, 2016 – IDERA today released SQL Query Store Optimizer, the latest free tool in its portfolio of database monitoring tools, to help database administrators (DBAs) easily manage and troubleshoot SQL Query Stores. This new free tool aggregates the Query Stores of all databases per instance into one single actionable interface.

SQL Query Store is a new feature offered in SQL Server 2016 that allows DBAs to see which queries ran when, how often and with what performance results to optimize queries and query plan selection. But the solution also has limitations, including possible interruptions and inefficiencies, troubleshooting and tuning issues and visibility into only eight of 12 Query Store properties per database.

IDERA SQL Query Store Optimizer simplifies troubleshooting by allowing DBAs to quickly see all 12 Query Store properties in all databases per instance in a single actionable interface, saving potentially hundreds of clicks and many hours researching custom SQL code.

"SQL Server DBAs were given a tremendous gift with SQL Server 2016’s Query Store technology, but Microsoft’s graphical user interface only provides DBAs limited control of the property settings,” said Sandi Warren, director of product marketing at IDERA. “As great as Query Store is, we saw opportunities to make it even better with this free tool. With SQL Query Store Optimizer, we’re helping DBAs improve the performance of complex queries, and make their work less complicated."

IDERA now has more than 22 free tools in its portfolio of database monitoring tools. For more information on IDERA SQL Query Store Optimizer, visit


IDERA designs powerful software with one goal in mind – to solve customers’ most complex challenges with elegant solutions. We don’t abide by the belief that a professional must sacrifice powerful features and quality for fast time to value and ease of use. With IDERA, you really can have it all. Our unique DNA is reinforced by a user community of nearly 100,000 database and IT professionals who use and evangelize our tools. From our award-winning SQL Server database solutions to multi-platform database, application and cloud monitoring tools, IDERA ensures your business never slows down. Contact us at +1-713-523-4433 or visit for free trials, free tools and more.

Join Our Global Community

Join our email list and receive the latest case studies, event updates, product news, and much more.