Query Analyzer Tool Displays plans in a hierarchical tree, and highlights immediately the 5 most costly processes.
Download

Query Analyzer Tool Ranking & Summary

Query Analyzer Tool Tags

analysis Analyze query Query Analyzer analyze query query analysis

Query Analyzer Tool Description

Query Analyzer Tool is a simple-to-use software application that, as the name says, enables you to verify SQL queries when it comes to execution plans, in order to make sure that everything is in working order. It is similar to SQL Server Query Analyzer.Rapid installation and plain-looking interfaceThe program is quickly installed and wrapped in a user-friendly interface, made from a single window with an intuitive structure. The first step is connecting to an SQL server by specifying its name, database and connection method between Windows and SQL Server authentication. Explore queries and modify dataIt is possible to find out the number of tables used in a query and total rows for each one, as well as to view the indexes of a table. Query Analyzer Tool integrates a simple editor that allows you to modify information, use a search function, set bookmarks (up to 10) and quickly select them via hotkeys, and spot brackets by color. Configure program settingsThe font can be increased or decreased in size, while information can be exported to spreadsheets (XLS), CSV or text documents (TXT) for closer examination. Query Analyzer Tool lets you indicate the lock report and user activity scripts, search path, DMO timeout, editor font size, and row count difference. Evaluation and conclusionNo error dialogs were shown in our tests, and the app did not hang or crash. It has a good response time and minimal impact on computer performance, since it runs on low CPU and RAM. Although, Query Analyzer Tool does not bring new features to the table, it provides users with a fact and effective solution to exploring and verifying SQL queries. Reviewed by Elena Opris, last updated on October 2nd, 2014

Query Analyzer Tool Related Software