ClearTrace

New: ClearTrace for Extended Events imports extended event files from SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, and SQL Server 2008.

ClearTrace for Trace imports SQL Server 2016, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000 trace and Profiler files into SQL Server and displays summary performance information. (The latest version of SMO no longer supports reading Trace files. That means I’m unable to support reading Trace files from SQL Server 2019.)

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