SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

Using ClearTrace to Analyze Profiler Results

Profiler is a great tool, but it's easy to get overwhelmed by the volume of results on a busy server. It's also not easy to aggregate the results because of literals passed in as parameters. You can do it, but it's work. Instead, we recommend you try a great free application called ClearTrace that will give you a terrific view of the results in a way that is easy to understand.

Duration:
5 mins 5 secs
Skill Level:
100
Rating:
4.57 out of 5
Publish Date:
March 02, 2011
Using ClearTrace to Analyze Profiler Results You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

There are no downloads or recommended reading links for this video

Comments
Steve Harris on 3/2/2011
Where do you get the tool

Randall Price on 3/2/2011
Great tool, would be nice to have a link to the download but I found it easily enough with a quick google search.

Travis on 3/2/2011
http://www.scalesql.com/cleartrace/download.aspx

Patrick Veilleux on 3/2/2011
I was looking for this kind of tool!!

Jay Stobbe on 3/2/2011
Blurry

Kevin Bayer on 3/2/2011
Good stuff...thank you Andy...

erick on 3/2/2011
Really going to try this out! Thanks

Stephen Schneider on 3/2/2011
Nice hint!

Janice Graver on 3/2/2011
I loved it

F1A1981877 on 3/2/2011
great free tool to learn about. very helpful and the speaker explained and demostrated clearly and simply how to use.

Tahir A. Syed on 3/2/2011
thanks...

Ameena on 3/2/2011
Very cool. I will definitely try and it already looks like a keeper. Thanks for showing that to us.

Mark Sopczak on 3/2/2011
Man... this is just what I need. Awesome... Thanks....

8EA8B9A396 on 3/3/2011
Is the query planner you are referring to inside SSMS or the ClearTrace tool itself?

Maurice Ivory on 3/3/2011
This was a okay video

Bobby on 3/3/2011
Looks interesting, I'll have to give it a try. Thanks!

DavidB on 3/4/2011
Didn't even know this existed. I have a script that I use that I pulled from SSC (by Lowell) that I use pretty regularly for the system trace but this is really nice as well. I'll be checking it out soon! Thanks for the tip Andy!

Alex Fredrich on 3/4/2011
amazing tool!

Checkpoint on 3/8/2011
Outstanding -- thanks for sharing!

linda on 3/10/2011
Thank you so much. Your experience and your willingnes to share is much admired.

Bridget on 3/14/2011
Can't really see screen due to font being too small.

Kasey Wheeler on 3/23/2011
Nice recommendation!!

Shah on 3/24/2011
Good to save time and effort to get to the problematic issue.

Adi on 3/25/2011
very good one Thanks

D9D64C4D65 on 5/5/2011
Cannot connect to the server and the database.

Marten on 5/6/2011
Good tool, good advice

Mark Horninger on 8/8/2011
Andy -great info. I've been doing this by hand and I can see where this will save me a ton of time!

Thomas Hoover on 8/24/2011
nice tool. I will give it a try.

virender on 10/18/2011
Here is the link to the tool http://www.scalesql.com/cleartrace/download.aspx

Tom Smith on 12/1/2011
looks cool...I'll try it

aasim abdullah on 1/19/2012
Excellent tool, excellent video

Amandeep on 2/21/2012
Thanks

Dan Paduck on 5/2/2013
awesome!



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions