From our software provided by a third party vendor, I am seeing the following:
They use prepared statements with Microsoft JDBC Driver for SQL Server
The same statement will get executed 20-30 times over a 5 minute span - it will get executed with:
Execution times are erratic....sometimes decent...sometime horrific.....hit or miss.
The statement is rather complex and should be broken down into steps with a SP, but they will not change
What will cause the 3 different methods of execution listed above?
Outside of changing the code (I have no access), what others measures can be taken?
How can I prove to them that something is wrong with their code / design?
Thank you in advance.