We have for a periode of time had the problem that the procedure cache for one specific table (ATP_RESB) gets corrupted.
(Windows server, MSSQL 11.00.6567.00, SAP_BASIS 7.40, SAP_ABA 7.40)
I happens regularly - maybe once a week that the availability check in sales order becomes very slow.
The fix is to drop the sql statement from the procedure cach (in transaction ST04). This solves the problem instantly.
The problem has existed for the last ½ year or so, but we have had it before. When I googled the problem i found a similar thread started by my self in 2010!
I 2010 we found the quick fix solution, but now I want to know if it is possible to identify the root cause of the problem.