Tuesday, March 20, 2012

cant see more than 3gb mem

We are running SQL server 2000 on Windows 2003 on a Compaq MLxxx. I
have /pae and /3gb switch in the boot.ini and 'awe enabled' in sql
server. However the target server memorry is only 2725808 and sql
server goes to a max to 2.7 GB. I have played with the 'max memory'
parameter but it dosent help. Any idea what am I missing ?How much physical memory is on the machine?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I have 8GB of RAM. Here is the output of @.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
>--Original Message--
>How much physical memory is on the machine?
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||The problem was the service account didnt have previlage "
lock pages in memory "
Details http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_1_server_1fnd.asp
>--Original Message--
>I have 8GB of RAM. Here is the output of @.@.version
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
>>--Original Message--
>>How much physical memory is on the machine?
>>Rand
>>This posting is provided "as is" with no warranties and
>confers no rights.
>>.
>.
>

No comments:

Post a Comment