Allocated Memory 1

Did you adjust your pagefile settings?

Both 565MB and 557MB for SQL and Exchange (which is what those processes are) is relatively normal. If you have a full version of SQL server you can adjust the memory utilization directly on the server. If it's MSDE, you can't. If you stop and restart that SQLserver process, it might free up some memory...

I'll add this here,

I'm also having this problem with sql2k (msde).
The real problem is that i have an application that could use 20mb ram one second and 200mb the next, which is making sbs lag a few cycles whilst it reallocates the memory usage...

Is there a way to force a service like sql to only use a max amount of ram? sql is only there to log


And, yes I know that the app is very erratic...

after i stop and restart the processes they begin with a low memory usage like 30meg or 100 and then a week later they are at 500. is it suppose to do that?

Matthew McGowan
Reynolds Park

I'm guesing that as data is added to sql (and emails with exchange), it will both save it to the hdd and in memory for quick access. I know that sql will work out which tables and records are requested the most and put them in memory.

I would say that as long as the page file size doesn't increase because of them, it should be fine. If it does then it will take alot of resources to change the size of the page file and your users will notice it.


The problem that i'm having is that i have an app, that one second will use 20mb and 200mb+ the next. This seems to lag the server whilst sql and exchange resize there memory usage. Its only half a second, but it is still a lag...

Review this post and the ones that link from there regarding allocated memory alerts on an SBS:



Jeffrey B. Kane
TechSoEasy
Blog:

Lwcomputing, actually you can adjust the max memory setting on MSDE instances as well, and the directions how are listed below.

Matt85, yes those settings are within range, so you will probably want to follow TechSoEasy's advice and maybe just reconfigure the alert thresholds.

You may also want to actually reconfigure the max memory though. I ran into the same issue when I increased the server memory to 3 GB. An MS SQL instance will consume all available memory by default when activated, so it might be best to limit these to smaller values depending on what the DB is and how many people use it. The apps I run definitely do not need the full amount they try to snatch up by default.

MSDE is allowed to use all available memory unless configured otherwise.

From the command prompt,

(Ex for SHAREPOINT, BKUPEXEC, SBSMONITORING, WSUS, etc.)
osql -E –S win2k3sbs\WSUS
sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’,256
reconfigure with override
go


WSUS is the instance name.
The 256 is the value in MB that you want the DB to be able to expand.

Good to know, thanks.

i don't understand why i am getting an allocated memory alert when i have 2gb and none of my processes run greater than that. the currect threshold is 2147483648 bytes, which is 2gb and the 2160496734 bytes is the monthly average. and if the most i've seen the store and sqlserver go to is 500megabytes why do i still keep getting this error. the memory available threshold is set at 4megabytes and the average is 453 megabytes thats what i don't understand. i don't know what page file usage is but its at 1.94 gb but that was after i restarted the store.exe is that good or bad. the physical memory total is 2096400 and avaiable is 1279000 and system cache is 743300

Matthew McGowan
Reynolds Park

It's taking up that much memory because it's being allowed to take up that much memory. It doesn't need that much to operate. If you read the linked article I provided above you'd understand that better.



Jeffrey B. Kane
TechSoEasy
Blog: