• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

MSSQL memory usage is increasing continiusly

T

Toepes

Guest
I have a problem with MSSQL on my windows2003 server with Plesk 8.1.

Problem is that the MSSQL service uses more memory when it runs. Starting the service it begins with approx 64MB memory usage, after one day it runs up to 700MB and more. At that time Plesk doesn't work fine (very slow)and I have to restart the MSSQL service.

I have some sites (approx 6) that use MSSQL for ASP. (not very heavily visited sites).

Is there a way to find out if one of the sites is creating this problem ?
 
This is actually "normal" behaviour for MS SQL (and other MS products such as Exchange). They will consume as much RAM as possible so data is kept in RAM and not read off the much slower swap file. The best thing you can do if it is becoming a problem is to manually set limits on the RAM use by SQL. This can be done in Enterprise Manager by right-clicking on your server, selecting properties and then the Memory tab. There you can set a maximum limit.
 
Thank you for your reply. Somehow i had an idea that it would be something linke that.

I'll try to change the settings
 
You must log in or register to reply here.

Similar threads

q-quan
Question What's your recommendation on MSSQL databases?
Replies
3
Views
6K
scsa20
scsa20
T
Question Mysql memory usage and memory used by system reach 90% of available ram and then crash
2
Replies
28
Views
25K
thinkjarvis
T
E
Issue High CPU usage
Replies
1
Views
3K
Kaspar
K
O
Issue Constantly increasing Mysql memory usage problem
Replies
4
Views
5K
orcunaras
O
M
Resolved After Plesk-Update 18.0.69 Update 3 mariadbd high memory usage - every time - also after every server restart
Replies
1
Views
4K
mcac
M
Back
Top