Red Gate forums :: View topic - SQL statement maximum length?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
ANTS Performance Profiler 6
ANTS Performance Profiler 6 forum

SQL statement maximum length?

Search in ANTS Performance Profiler 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
pmc



Joined: 06 Dec 2010
Posts: 3

PostPosted: Mon Dec 06, 2010 4:34 pm    Post subject: SQL statement maximum length? Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Tue Dec 07, 2010 11:15 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Tue Dec 07, 2010 2:06 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
pmc



Joined: 06 Dec 2010
Posts: 3

PostPosted: Tue Dec 07, 2010 3:33 pm    Post subject: Reply with quote

Great, thanks for your support. We await your findings then.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group