When does SQLSvr take it's memory?????

[stiej]

Our My Computer properties shows a total memory amount of 2 GB, but the Task manager shows 4GB.

SQL Server on this system is configured to use up to 2GB of memory.

Is SQL Svr causing that discrepancy between the task manager figure and the My Computer preoperties figure???

And so...when does SQLSvr actually grab and hold it's memory, during the boot process, and when during the boot process???

thanks in advance...

 

[timscronin]

It will take all the memory it can, and will continue to eat up with processes during the day. It will not give back memory to the OS until requested to. If you have any other apps running on the box you might want to set a max memory on the sql server.

 

[mrdenny]

Where in task manager are you seeing the 4 GB of memory? There are lots of memory numbers in there. You may be looking at the wrong one.

SQL server will grab a bunch of memory when it first starts. After that it will continue to grab memory as it loads accessed data into it's internal cache. It will take all the available physical memory up to it's limit that it's set for.

If you are using Standard Edition I would recomend butting another 512 MB of RAM into the machine (If you are running Windows 2003). Thay way SQL can use 2 GB of RAM and Windows can have 512. (I'm assuming that you are using Standard Edition of SQL).

By default SQL Server is configured to use all the memory in the server (up to the 2 GB mark for standard edition). This will end up leaving the OS with very little memory to work with for it's own operations.

I typically like to give Windows about 512 MB of RAM and leave the rest for SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com