posts - 219, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

ClearTrace Supports SQL Server 2008 R2

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)

Print | posted on Friday, January 07, 2011 11:51 AM | Filed Under [ ClearTrace ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET