IDERA SQL Query Store Optimizer as the Latest Free Database Tool



The performance of complex queries, database administrators (DBAs), single actionable interface and simplified troubleshooting are at the core of the release of SQL Query Store Optimizer, with the goal to help database administrators (DBAs) easily manage and troubleshoot SQL Query Stores.

This new free tool can aggregate the Query Stores of all databases per instance into one single actionable interface. 

For those who are unfamiliar, 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. 

IDERA SQL Query Store Optimizer aims to address its limitations, including possible interruptions and inefficiencies, troubleshooting and tuning issues and visibility into only eight of 12 Query Store properties per database.