For long batched SQL queries the text get truncated by default and display: "Remainder of SQL Text has been truncated due to excessive length"Is there a setting to allow all the text to be displayed?
There's an option to store more of the SQL Text, but it can seriously increase the size of your repository. From your instance on the dashboard, click "Action" > "Advanced Options" > click the "Support Options" checkbox > Scroll down to "SQLTEXT_SQLSERVER_MAX_TEXT_LENGTH". You can increase that from the default of 7999. This can accomplish what you want but you may notice your repository size grow significantly as a result.
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.
Yes, this is a major pain point for shops using LINQ / Entity Framework.
I just created . Please vote for it.
