msde memory leak?

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
hi Shelby,
"shelby" <shelby@.discussions.microsoft.com> ha scritto nel messaggio
news:2537A25E-666F-4E46-9878-DB00B854AF66@.microsoft.com
> 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
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://tinyurl.com/63bl3 , but a better disgression
about memory management is provided by Ken Henderson, and you can have a
loot at a sample chapter at
http://msdn.microsoft.com/library/de...v_03252004.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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