Mar
27
2015

Tools for Analyzing SQL Server trace files

After validating multiple options to analyze SQL server trace files, I found below tools which can help achieve required results, hope it helps someone looking for quick list. There may be multiple other tools available, below are few tested ones from my list.

 

  1. For basic analysis – Microsoft In-built tool: SQL Server profiler

Usage: Login to any server with SQL Server installed, open SSMS and go to Tools > select “SQL Server Profiler” > Open the saved .trc files and analyze


 

  1. For Quick Analysis – Freeware tool: QURE ANALYZER – FREE SQL SERVER TRACE ANALYSIS TOOL

Usage: It is simple tool for quickly analyzing trace files, go to website, download the tool (you need to register for downloading), install it on desktop or your test machine, load trace files saved and run the analysis

DL: http://www.dbsophic.com/qure-analyzer.html

 

Note: I have already a copy of this setup; can share if needed to avoid any registration requirement


 

  1. For detailed analysis – Open source tool: SQL Nexus

Usage: It provides an in-depth troubleshooting and analyzing power for trace collection and reporting (used by Microsoft as well), but require a bit of installation and database connection

DL: http://sqlnexus.codeplex.com/

 

  1. To quickly run and analyze, following tool can be used http://expressprofiler.codeplex.com/ , good part is it doesn’t require installation and negative is, it can’t open existing trace, you need to collect trace through tool itself, can be tried for small scenarios.

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 238 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2019
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: