Have you ever needed to find your most expensive queries and quickly grew weary of writing T-SQL against trace tables to try to ferret them out? Have you ever had to wade through gigabytes of trace data just to find one ill-behaving query? Have you ever struggled to decide what performance metrics really matter when analyzing Profiler traces: duration, reads, writes, etc? Ken Henderson's post is about a new tool Bart and Ken wrote to help you do all this and more.
Check it out here: http://blogs.msdn.com/khen1234/archive/2007/12/12/a-sql-profiler-trace-swiss-army-knife.aspx
Wednesday, December 12, 2007
Retrace : A SQL Profiler Trace Swiss Army Knife
Posted by Denis at 9:00 AM
Labels: SQL Server 2005, Tools, Trace
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment