ClearTrace

If your daily work involves handling database files, you probably understand and appreciate the importance of having the right set of tools under your belt, ones that can easily simplify your work by providing you with anything necessary.

ClearTrace is one of the applications that fall in the aforementioned category, as it packs several useful tools for you to process data with easily and conveniently.

This application can be used by database administrators to import tracer and Profiler files from SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005 and SQL Server 2000 to your computer.

It is worth mentioning that in order for this application to work on the target computer, one of the following Microsoft SQL Server editions must be installed: 2008, 2008 R2, 2012, 2014, or 2016. This is necessary for the app to access SMO libraries.

In order to begin importing data, you need to specify a trace group and the first trace file, a valid work directory, an archive directory, as well as the database server and a database name. When you begin the import process you can view the progress in the "Import Status" tab.

After the import is finished, the application enables you to perform queries on the output documents by simply navigating to the "Query the Imported Files" tab, specifying a database server, selecting a trace group to query and configure the rest of the required parameters.

If you're in need of a tool that can help you import trace and Profiler files from your SQL Servers, ClearTrace can be exactly what you're looking for. It lets you view the import process in real time and even perform queries of files that you've already finished imported.