|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > Why does \3GB switch give approx. 3.5GB physical memory
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Why does \3GB switch give approx. 3.5GB physical memory
|
|
| John Bay Hansen 2002-12-16, 11:23 am |
| I have installed an SQL 2000 standard server on a Windows
2000 advanced server, and i have enabled \3GB switch in
the boot.ini.
The system show 3.5GB of physical memory, but i expected
to se 3 or 4GB. Why????
In the SQL memory tap it show 3.5GB as well. I would
expect 3GB. Why????
Best regards
John
| |
| SQL Server Development Team [MSFT] 2002-12-17, 12:24 pm |
| How much memory do you have installed on this particular server?
Thanks,
Corinna & Florian
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"John Bay Hansen" <jbh@saxobank.com> wrote in message
news:000001c2a525$74ff5a20$d5f
82ecf@TK2MSFTNGXA12...
> I have installed an SQL 2000 standard server on a Windows
> 2000 advanced server, and i have enabled \3GB switch in
> the boot.ini.
> The system show 3.5GB of physical memory, but i expected
> to se 3 or 4GB. Why????
> In the SQL memory tap it show 3.5GB as well. I would
> expect 3GB. Why????
>
> Best regards
> John
| |
| SQL Server Development Team [MSFT] 2002-12-17, 1:24 pm |
| The /3GB switch means that it "increases the memory available to the
application to 3 GB, and reduces the amount available to the system to 1
GB". This doesn't mean that the total memory used by the process is bound to
3 GB, but rather that the user-space code has access to 3 GB and the kernel
space code has access to the remaining 1 GB.
So probably what you are seeing is that the kernel space of the process is
allocating 500MB to 1GB and the application itself is allocating the
remaining 2.5 GB to 3 GB.
http://msdn.microsoft.com/library/d...-us/memory/base
/4gt_ram_tuning.asp
If you want to bound the total physical memory used by SQL Server, then you
should be using Enterprise Manager and Server properties to set the values.
Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"John Bay Hansen" <jbh@saxobank.com> wrote in message
news:000001c2a525$74ff5a20$d5f
82ecf@TK2MSFTNGXA12...
> I have installed an SQL 2000 standard server on a Windows
> 2000 advanced server, and i have enabled \3GB switch in
> the boot.ini.
> The system show 3.5GB of physical memory, but i expected
> to se 3 or 4GB. Why????
> In the SQL memory tap it show 3.5GB as well. I would
> expect 3GB. Why????
>
> Best regards
> John
|
|
|
|
|