ryanjlind

We too are using Entity Framework (sigh) and have this issue. So far my only work-around has been to copy part of the query from DPA, and then run a profiler trace looking for this part of the query until I find the full query in profiler. If anyone has any better solutions please provide. This is really troublesome...many…

in Allow values larger than 7999 for SQLTEXT_SQLSERVER_MAX_TEXT_LENGTH Comment by ryanjlind October 2016

You note "manually hunt for it in the repository..." do you have any advice as to getting the sql handle from the repository? I can find the plan handle but not the sql handle.

in Display the actual varbinary sql_handle or plan_handle for the DPA representation Comment by ryanjlind October 2016

So it looks like something has been changed here, and it is allowing values up to 49,999. Unfortuantely 1) I can't seem to get it to work. Even after setting 49999 and restarting the monitor, I am not getting 49,999 characters 2) I fear this is still not a high enough maximum for us. Any clarification?

in Allow values larger than 7999 for SQLTEXT_SQLSERVER_MAX_TEXT_LENGTH Comment by ryanjlind March 2018

DPA will not allow me to actually set this higher than 7999 (value must be less than or equal to 7999.) This is a real problem for us. WE have queries that are killing our performance and we can't see what they are because they are too long for DPA.

in Remainder of SQL Text has been truncated due to excessive length Comment by ryanjlind October 2016

ryanjlind

Comments