msde memory leak?

msde memory leak?

Post by c2hlbGJ » Tue, 28 Sep 2004 18:53:02


Any problem with MSDE?

Client: ASP.Net C#
Server: MSDE
2 CPU/2GB RAM machine

at beginning, RAM for MSDE is 80MB
after 40 hours, RAM for MSDE is 1.3GB
Connections to msde is flat: 28 connections

1. It is said msde will keep grabbing ram, but is it too much?
2. try to set the limitation for max mem, but got error, says can not find
'max server mem'
sp_configure 'max server mem' 3000000

thanks,
Shelby
 
 
 

msde memory leak?

Post by Andrea Mon » Tue, 28 Sep 2004 19:35:16

hi Shelby,
"shelby" < XXXX@XXXXX.COM > ha scritto nel messaggio


try perhaps with

EXEC sp_configure 'max server memory' , xx

regarding your memory usage, it could be actually normal, as SQL Server
manage it's memory footprints very well, but it usually is very hungry about
it...
you can have a look at http://www.yqcomputer.com/ , but a better disgression
about memory management is provided by Ken Henderson, and you can have a
loot at a sample chapter at
http://www.yqcomputer.com/
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ ://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

 
 
 

msde memory leak?

Post by U2hlbGJ » Thu, 30 Sep 2004 03:49:05

Client: ASP.Net C#
Server: MSDE
2 CPU/3GB RAM machine

at beginning, RAM for MSDE is 80MB
after 40 hours, RAM for MSDE is 1.3GB
Connections to msde is flat: 28 connections

Then I tried to limit the memory.

exec sp_configure 'show advanced option', '1'
RECONFIGURE WITH OVERRIDE
exec sp_configure 'max server memory', 314572800 -- 300 MB
exec sp_configure 'min server memory', 209715200 -- 200 MB

But this does not limit the msde memory usage. It still keeps eating up more
and more memory up to 1.2 after 14 hours load test.

But when i run
exec sp_configure
to check the status, here is the result, looks fine.

name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------
max server memory (MB) 4 2147483647 314572800 314572800
min server memory (MB) 0 2147483647 209715200 209715200
 
 
 

msde memory leak?

Post by Andrea Mon » Thu, 30 Sep 2004 17:08:38

hi Shelby,
"Shelby" < XXXX@XXXXX.COM > ha scritto nel messaggio


actually you have to execute
exec sp_configure N'max server memory (MB)', 300
reconfigure with override

as you can se, from the values reported by your query, 2147483647 value
states no limit has been set...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ ://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply