SQL Optimizer for SQL Server version 9.0.0 is now available.
In this release, we add a brand new module, Find SQL. It helps you locate the most resource-intensive SQL in your server by extracting from SQL Server Plan Cache. It evaluates existing SQL performance by different statistics (such as CPU Time and Elapsed Time) from different areas (such as Top N SQL statements, Top N SQL Batches and Top N Database Objects). Different queries extraction sources will be added in the future releases. So please stay tuned [:)]
Microsoft has introduced the Contained Database (CDB) feature in SQL Server 2012. To support this new feature, we have enhanced our connection manager to support the Contained Database login. The Optimization engine has also been upgraded so that SQL Optimizer recognizes and handles the new CATALOG_DEFAULT collation.
We are looking forward to hearing your feedback. Please feel free to download our trial version and let us know you think about this new release.