1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Memory usage of SQLSERVR.EXE increases

Discussion in 'Plesk for Windows - 8.x and Older' started by Toepes, Apr 2, 2007.

  1. Toepes

    Toepes Guest

    0
     
    I noticed that the proces sqlservr.exe is increasing it's memory usage every day. After a reboot it is approb 67MB after 2 - 3 days it is between 600 and 800MB of Mem Usage in WIndows Task Manager.

    On the server, with SP2 w2K3 and Plesk 8.1, i have just 4 small websites using ASP. Plesk uses the MSSQL database. Does anyone noticed the same or solved this, as the server slows down when the use of memory increases.
     
  2. leozim

    leozim Guest

    0
     
    I have same problem, have 4gb of ram and server is slow, because 20 minutes after reboot server sqlserv.exe use 800MB of memory
     
  3. webface

    webface Guest

    0
     
    I was having the same problem until last week. Apparently SQL Server will use whatever memory is available, but will release it if it has to.

    You can set SQL Server to use only a maximum amount of memory that you specify.

    Right click on the server in Management Studio and choose properties. On the left click on "Memory" then enter a maximum value that you want SQL to use in "Maximum Server Memory".

    It's worked great for me. I set it to 100MB and it always just hovers around this mark.

    I hope this helps.

    Cheers
     
  4. sergius

    sergius Golden Pleskian

    28
    57%
    Joined:
    Nov 6, 2005
    Messages:
    1,898
    Likes Received:
    0
    Gentlemen, thank you for report. We will investigate this scenario.
     
  5. Toepes

    Toepes Guest

    0
     
    This is the solution that works !
    Thanks !
     
Loading...