Viewing 2 posts - 1 through 2 (of 2 total)
Dynamic SQL - that is application's fault.
Is there anything that can be done by the DBA in the meanwhile?
May 23, 2011 at 9:40 am
#1328526
Me too, I was finding that many query plans are being compiled ad hoc.
(57% of batch requests result in compilation)
I would like if the server reused more my plans.
Any...
May 23, 2011 at 9:24 am
#1328510