Profiler shows SQL Queries trimmed after ~100 lines

Code profiling for .NET Developers

Moderators: Luke Jefferson, StephenC, Alex.Davies, AndrewH, melvyn.harbour, Laura Morley

Profiler shows SQL Queries trimmed after ~100 lines

Postby DSKY » Sun Jan 29, 2012 10:39 am

Is it possible to remove this restriction?
DSKY
 
Posts: 4
Joined: Sun Jan 29, 2012 9:39 am

Postby Brian Donahue » Mon Jan 30, 2012 1:50 pm

Hello,

I don't know yet if it's possible to see more than 8KB in a SQL Query - I'd logged this as a bug quite awhile ago (PP-1174) but there has been no update. I'm not sure if we can do anything about it or if it's a limitation of Windows Event Tracing. We do only reserve an 8KB buffer for each query, according to the source code.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to ANTS Performance Profiler 6

Who is online

Users browsing this forum: No registered users and 1 guest