März 19, 2024
anmelden |
MSFW MSDE verbraucht sehr viel Arbeitsspeicher minimieren

Oliver Sommer

Nachtrag
Inzwischen gibt es auch einen KB Artikel dazu:
http://support.microsoft.com/default.aspx?scid=kb;en-us;909636&sd=rss&spid=2108


Quelle
ISA logging takes a lot of Ram and how to fix this:

http://www.smallbizserver.net/Default.aspx?tabid=247


[...]
The commands to limit the amount of Ram an MSDE instance takes
Open a command prompt and type the following commands or download the batch (Set SQL Ram.zip) files
here. You must be a registered user to download. If you use the dowloadable batch files place them in the root of your C drive and edit both .cmd files and replace SERVERNAME with your server name.

osql -E -S YOURSERVERNAME\msfw  [hit enter]
sp_configure 'show advanced options',1 [hit enter]
reconfigure with override  [hit enter]
go  [hit enter]
sp_configure 'max server memory',100 [hit enter]
reconfigure with override  [hit enter]
go  [hit enter]

 


Feedback maximieren