SQL statement maximum length?

Code profiling for .NET Developers

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

SQL statement maximum length?

Postby pmc » Mon Dec 06, 2010 4:34 pm

Hi, we just purchased the Performance Profiler and are having troubles viewing the full SQL statements in the SQL source code section of the application. It cuts the statement after 8192 characters (including spaces). Is this a limitation in SQL Server's monitoring services that provide PP with data, or a limitation in PP displaying the statement?

Thanks in advance.
pmc
 
Posts: 3
Joined: Mon Dec 06, 2010 4:24 pm

Postby Brian Donahue » Tue Dec 07, 2010 11:15 am

Sorry I did not answer this yesterday, but I didn't want to reply to this topic until I got an answer for you, which I have not.

I have spent about 45 minutes yesterday trawling through the ANTS Performance Profiler source code and couldn't find anything although I had found some Event Tracing code samples on MSDN that seem to indicate that there is a maximum buffer size (ring_buffer) that you can specify for the ETW buffer, which may be the issue.

So at the moment I don't know if this is a bug or just a design oversight and am waiting for someone from the ANTS Profiler dev team to get back to me about it.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Tue Dec 07, 2010 2:06 pm

We think it's just because the ETW object is using the default buffer size. I've logged bug PP-1174 so someone can look into it.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby pmc » Tue Dec 07, 2010 3:33 pm

Great, thanks for your support. We await your findings then.
pmc
 
Posts: 3
Joined: Mon Dec 06, 2010 4:24 pm


Return to ANTS Performance Profiler 6

Who is online

Users browsing this forum: No registered users and 0 guests