November 25, 2003 at 3:23 am
How much Mry can I allocate with my SQL 2K server SP3A Ent. ED. on an Windows 2K Advanced server.
My server reports a total available physical memory of 3.898.716 KB.
When I want to start SQL Server 2K with 'min server memory' of 3556MB than he gives me a warning he can't do that.
When I look at the SQL Mry counters I have the impression that SQL can't allocate more than 3 GB of Mry.
My server is started with the /3GB switch in the boot.ini and the AWE settings are not enabled.
Can some one tell what's going wrong.
November 25, 2003 at 4:56 am
That's as it should be. The /3GB parameter allows the application (SQL Server) to use up to 3GB of the 4GB that the OS can directly address. That's the most you can get if you have <= 4GB memory.
There's a new switch /USERVA available with Windows 2003 Server that allows fine tuning of the line between User-mode (application) and Kernel mode (OS) memory space when /3GB is used. It still doesn't allow User-mode memory to exceed 3GB, but it does allow one to allocate User-mode space of more than two gigabytes but less than three gigabytes. One can also crudely tune the kernel space with this switch, as the memory returned to the kernel from the lower 3GB is used only for Page Table Entries.
--Jonathan
--Jonathan
November 25, 2003 at 6:39 am
How can I use the mry between 3GB and 4GB for SQL*Server? Or isn't that possible?
Edited by - Ludo Bernaerts on 11/25/2003 06:47:11 AM
November 25, 2003 at 6:53 am
quote:
How can I use the mry between 3GB and 4GB for SQL*Server? Or isn't that possible?Edited by - Ludo Bernaerts on 11/25/2003 06:47:11 AM
Not possible; that's the minimal space for the OS kernel.
--Jonathan
--Jonathan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply