SQL Trace Analyzer ™   |  Features and Benefits

SQL Trace Analyzer helps database administrators and application developers in a number of ways.

Organize Trace Contents

A trace acts like a container of jumbled information. Some of this information may be useful, some may be not. SQL Trace Analyzer segregates this raw information into distinct categories and presents them in an ordered, clear, and consistent format. This eases the task of locating and identifying objects that are possible causes of performance delays.

Measure and Evaluate Performance of SQL Calls and Transactions

Upon generating an Analysis report, SQL Trace Analyzer displays the number of calls, durations, reads and writes. It also shows CPU usage of stored procedures, functions, dynamic SQL Calls, Select calls, DML calls and transactions. SQL Trace Analyzer ranks these elements, thereby helping you execute your analysis much faster.

Inspect SQL Code of Problem Calls and Transactions

SQL Trace Analyzer highlights the specific suspect code, providing more detailed information for analysis.

Extract a Great Deal of Information From a Single Trace

SQL Trace Analyzer can mine database activity information recorded in a single trace file or trace table using its extensive filtering features. These include special filters for Text Data to sort out objects inside SQL codes and Start/End Time to concentrate on specific segments within the trace. These filters allow you to focus your analysis on crucial areas and then reuse the same trace for analyzing other activities.

Compare Traces Side by Side

SQL Trace Analyzer can open multiple traces. This is a welcome aid to present the before and after scenarios in your database, and measure the effectivity of applied changes on the spot.

Visualize Trace Data

SQL Trace Analyzer uses colorful charts that provide a clear picture of how connections and stored procedures perform inside SQL Server. It also includes animated pie diagrams that show subset values for different trace elements.

Establish Collaboration Strategy

SQL Trace Analyzer helps create an effective collaboration strategy between database administrators and application developers. After the database administrator generates the trace, he can send the trace to developers for analysis. This allows database administrators to work on other maintenance issues and developers to focus on what they do best - writing good code.

Achieve Organizational Benefits

Even though SQL Trace Analyzer only uses a small foot print in your computer, its features help you achieve better response time, meet expectations constantly, improve competency of database developers, and maintain reliability.