ClearTrace Supports SQL Server 2008 R2
Posted
by Bill Graziano
on SQL Team
See other posts from SQL Team
or by Bill Graziano
Published on Fri, 07 Jan 2011 17:51:55 GMT
Indexed on
2011/01/07
18:56 UTC
Read the original article
Hit count: 228
It was a long time coming and I hope worth the wait. If you have SQL Server 2008 R2 installed on the same box as ClearTrace and you download the latest ClearTrace build (36) you’ll be able to read SQL Server 2008 R2 traces.
I also fixed a bug handling very, very large SQL statements. I encountered an INSERT statement that was 12MB in size. It was storing XML in a database. ClearTrace uses regular expressions to clean up the SQL it finds. Running two dozen regular expressions over this 12MB string caused the application to crash. In this build I’m just skipping any statement over 1MB. I’ll do something a little nicer in the next build.
(And if you don’t want to download ClearTrace you can test the online version at www.TraceTune.com)
© SQL Team or respective owner
