![]() The Query performance tab displays the slowest queries recently executed by defined criteria and collected from SQL Server with provided all important details: The Script view displays full query text for a Stored Procedure with execution times per statement: ![]() The Stored Procedure Summary tab displays combined information about Stored Procedure statements from Detail view tab and parameter execution from Parameter history tab: The Execution plan history tab is used to display the history of different versions of query executions for the current application tab: The XML view tab is used to display the query execution plan in XML format: The Join graph tab is used to graphically display relationships between database tables involved in the execution plan: The Operations tree tab is used for analyzing query operation tree details: The Columns tab is used for reviewing all columns used in the plan, and their associated operations and indexes: The Operations tab shows simplified and expanded operations that are used in the selected query and allows implicit conversions within. The Waits tab is used for analyzing wait statistics of executed queries: The I/O reads tab is used for performing I/O reads analysis along with scan counts: ![]() The Execution plan tab is activated, along with other tabs, seen on the bottom of the window, when an execution plan is executed to create an actual, live or estimated query execution plan: This tab is also shown when a previously saved execution plan query is loaded: This Query text tab is used for writing execution plan queries. Stored procedure ribbon bar, with selection of options for profile analysis: ![]() Management ribbon bar, with dropdown action buttons: Home ribbon bar, with analysis and main application options: This window is shown when new session in ApexSQL Plan is started: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |