SQL statement maximum length?

pmcpmc Posts: 5
edited December 7, 2010 9:33AM in ANTS Performance Profiler Previous Versions
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.
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • pmcpmc Posts: 5
    Great, thanks for your support. We await your findings then.
    · Share on Twitter
Sign In or Register to comment.