Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50615 in /var/www/clients/client1/web13/web/db/mysql4.php on line 48 How to limit SBS Monitoring SQL database RAM usage :: Windows tehnična podpora
Gostovanje na Windows strežnikih, ponudba webhosting, ASP.NET, PHP, MySQL


Windows tehnična podpora
Podporni forum za uporabnike storitev spletnega gostovanja
Odgovori na to temo
How to limit SBS Monitoring SQL database RAM usage
Pico
Site Admin

Pridružen/-a: Ned Jan 2004 0:15
Prispevkov: 228
Kraj: HostMachine.net
Odgovori s citatom
On SBS Server 2003 your SBS monitoring SQL database may consume a large amount of RAM. When you look at running processes with Task Manager you may see sqlservr.exe process, running with SYSTEM credentials, consuming even more than 500MB RAM and over 1.5GB of Virtual memory!
This is really not good for the system, and may slow down your server.

So, how to limit RAM usage for SBS SQL monitoring database?

First, go with your Task Manager and under
View -> Select Columns
check PID and Virtual Memory Size.

Then see PID for the sqlservr.exe process which consumes large amount of RAM.

Then go to CMD Command prompt and enter this command:

tasklist /svc | find "sql"

You'll get something like this:
Koda:
C:>tasklist /svc|find "sql"
sqlservr.exe                  1628 MSSQL$MICROSOFT##SSEE
sqlservr.exe                  1724 MSSQL$SBSMONITORING
sqlagent.EXE                  2868 SQLAgent$SBSMONITORING
sqlwriter.exe                 2952 SQLWriter
sqlmangr.exe                 10832 N/A


Find the PID from Task Manager in the list from this command. Most probably it is MSSQL$SBSMONITORING process which is guilty for large RAM consumption.

If this is true, you may limit it via Command prompt entering these commands (what you need to type is marked bold):

C:>osql -E -S SERVERNAME\SBSMONITORING
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
1> sp_configure 'max server memory',70
2> reconfigure with override
3> go
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option 'max server memory (MB)' changed from 2147483647 to 70.
Run the RECONFIGURE statement to install.
1> exit
C:>

Note: Replace SERVERNAME, SBSMONITORING and number 70 with values to match your system!

As you see, by design SBS monitoring database has a limit of 2147483647 MB of memory, so it can eat up practically all your RAM!
The 70 MB limit here shown is just a guess, and my recommendation is to use some value between 70 and 300, depending on your free RAM.

Have your Task Manager open and watch your sqlservr.exe process how it releases RAM imidiatelly after you issue these commands. Many people have used this hack and all are happy with server behaviour. No side effects have been noticed (as far as I know).

_________________
Site admin alias Labsy
Vsi nasveti in tehnične rešitve so podani v dobri veri in za ljudi z razčiščenimi pojmi o veljavni zakonodaji.
Odgovornost prevzemam izključno in samo za tiste posege, ki jih opravim lastnoročno.
Poglej uporabnikov profilPošlji zasebno sporočiloObišči avtorjevo spletno stranMSN Messenger - naslov
How to limit SBS Monitoring SQL database RAM usage
Ne, ne moreš dodajati novih tem v tem forumu
Ne, ne moreš odgovarjati na teme v tem forumu
Ne, ne moreš urejati svojih prispevkov v tem forumu
Ne, ne moreš brisati svojih prispevkov v tem forumu
Ne ne moreš glasovati v anketi v tem forumu
Časovni pas GMT + 1 ura, srednjeevropski - zimski čas  
Stran 1 od 1  

  
  
 Odgovori na to temo