Showing posts with label compaq. Show all posts
Showing posts with label compaq. Show all posts

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.
>>.
>.
>

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: )
>
>confers no rights.
>.
>sql