Skip to Content
Nov 25, 2014 at 08:40 AM

15.7 SP110 -> CPU, proccache and memory consumption increase after IMDB



We finally switched our tempdbs databases to IMDB databases last weekend. We experienced the day after a blocking of dataserver , that we solved by emptying proccache. We already had only once this behaviour, and I asked prod DBAS for opening support ticket to perhaps activate TF 753 and/or 757.

Nevertheless , I can see that memory usage increase , and for some batch processes Proccache usage has drastically increased, for globally the same amount of work. Moreover exec time has not decreased , but increased by about 20%.

On the opposite, response time for screen (which also calls stored procs , but lighter) has decreased as expected.

Has someone experienced this kind of behaviour ?