Well. I'm sorry, but we have been testing some workarounds and we have found another way to temporary "solve" the problem.

I'm going to explain this.

If we use the <sp_recompile> SP...

We haven't modified any parameters of default memory configuration. We've been changing parameters of dynamic memory for testing purposes in our testing machines, but there is only slight differences in...

Ok, we've got maximum priority to user applications, because we are running our applications in same server computer.

We know that is better SQL Server has a dedicated computer, but we...