November 29, 2015
anmelden | registrieren
MSFW MSDE verbraucht sehr viel Arbeitsspeicher minimieren

Oliver Sommer

Inzwischen gibt es auch einen KB Artikel dazu:;en-us;909636&sd=rss&spid=2108

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

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 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