How can we help you today? How can we help you today?

SQL statement maximum length?

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
0

Comments

3 comments

Sort by
  • Brian Donahue
    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
    0
  • Brian Donahue
    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
    0
  • pmc
    Great, thanks for your support. We await your findings then.
    pmc
    0

Add comment

Please sign in to leave a comment.