Test the online version of ClearTrace at www.TraceTune.com

ClearTrace

ClearTrace imports SQL Server 2000, SQL Server 2005, SQL Server 2008,SQL Server 2012, SQL Server 2014 trace and Profiler files into SQL Server and displays summary performance information.

Features

Normalized SQL Statements

ClearTrace "normalizes" the SQL statements to eliminate transient differences in SQL statements. For example, the following statement

Select * From qryLinksByNewsletterID Where NewsletterID=19

is normalized to

SELECT * FROM QRYLINKSBYNEWSLETTERID WHERE NEWSLETTERID={##}

This allows the common SQL statements to be grouped together to determine their impact on the system. Other steps include:

Integrated Query Results

Other Features