SQL Trace Analyzer 1.1.2007.313

Lakeside SQL Trace Analyzer is a tool that will analyze the data collected by Microsoft SQL Profiler to pinpoint performance problems.
Trace Analyzer ™ generates statistics and identifies problem areas to give a clear picture of what goes on inside your system – from CPU health to procedural statistics to errors.
The tool displays findings such as most resource intensive lines of code or longest running queries in easy-to-read reports that can be shared with the development team so that problems can be addressed.
With Trace Analyzer, you can:
- Quickly analyze the data
- View statistical analysis reports
- Filter and sort data analysis based on your
- requirements
- Detect problem areas that cause performance
- bottlenecks
- Generate graphical representations of your report
- Produce comprehensive reports that can be shared by DBAs and developers
With Trace Analyzer, quickly identify:
- Worst-performing statements
- Longest running queries
- Peak of heavy load
- Problem procedure/function calls
- Generate graphical representations of your report
- Rolled back transactions
Main features:
- 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 these 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.
Version restrictions:
- 30 days evaluation period