MSSQL Cache Problems

Posts   
 
    
cerberis
User
Posts: 93
Joined: 20-May-2011
# Posted on: 08-Aug-2011 12:15:21   

Hello,

after migrating the code from 1.0.2005 version to the latest LLBL 3.1 and going live with new version we are experiencing quite strange problem which we did not had before. It looks like MS SQL server cache grows so that it starts slowing down MS SQL server: http://support.microsoft.com/kb/927396/en-us Have you ever noticed somewhere similar behavior. We are running .NET 3.5, with LLBL 3.1 (3.1.11.701), using adapter scenario with modified templates. However, never had any similar issue with old LLBL version, but already second time with new version in 2 weeks.

Do you have any ideas about this?

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 08-Aug-2011 15:17:13   

First time we receive such problem.

Which release of the SQlServer are you using? Have you applied the latest service pack as the article suggests?

cerberis
User
Posts: 93
Joined: 20-May-2011
# Posted on: 08-Aug-2011 15:29:40   

Walaa wrote:

First time we receive such problem.

Which release of the SQlServer are you using? Have you applied the latest service pack as the article suggests?

Not so easy to apply service packs on production server.. simple_smile But definitely we will do this. Just we are curious, because the only major change in this release was LLBL version. I will let you know if SP3 will fix the problem simple_smile

thank you.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 08-Aug-2011 16:39:21   

Will close this thread for now, and it will be re-opened once you post a reply.