|
|
| N.Raja 2002-11-28, 7:23 pm |
| I have 2.5GB of RAM for SQL2000 and SQL server never
crosses 1.7GB for some reason. I have tried sp_configure
for enabling AWE. This does not help. Windoes 2000 Server
is the OS. And the RAM is recognised by OS.
Any clue how i could make SQL to use up the full RAM?.
Thank You
N.Raja
| |
| Andrew J. Kelly 2002-11-28, 7:23 pm |
| What edition of SQL Server do you have? Standard will only support 2GB.
--
Andrew J. Kelly
SQL Server MVP
"N.Raja" <n.r@usa.net> wrote in message
news:1e04001c29741$9257a100$89
f82ecf@TK2MSFTNGXA01...
> I have 2.5GB of RAM for SQL2000 and SQL server never
> crosses 1.7GB for some reason. I have tried sp_configure
> for enabling AWE. This does not help. Windoes 2000 Server
> is the OS. And the RAM is recognised by OS.
>
> Any clue how i could make SQL to use up the full RAM?.
>
> Thank You
> N.Raja
| |
| N.Raja 2002-11-28, 8:23 pm |
| I have installed SQL Server Enterprise Edition Andrew. I
quite dont understand Tomski also.
N.Raja
>-----Original Message-----
>What edition of SQL Server do you have? Standard will
only support 2GB.
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>
>"N.Raja" <n.r@usa.net> wrote in message
> news:1e04001c29741$9257a100$89
f82ecf@TK2MSFTNGXA01...
>> I have 2.5GB of RAM for SQL2000 and SQL server never
>> crosses 1.7GB for some reason. I have tried sp_configure
>> for enabling AWE. This does not help. Windoes 2000
Server
>> is the OS. And the RAM is recognised by OS.
>>
>> Any clue how i could make SQL to use up the full RAM?.
>>
>> Thank You
>> N.Raja
>
>
>.
>
| |
| N.Raja 2002-11-28, 8:23 pm |
| Hello Tomski.
I dont get u exactly. What are you trying to say?. I did
go thru this BOL. It applies to morethan 3GB and for
Advanced Server. My case is only 2.5GB and not Advanced
Server.
Do you want me to configure something?. Please let me know.
Thank You
N.Raja
>-----Original Message-----
>What edition of SQL Server do you have? Standard will
only support 2GB.
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>
>"N.Raja" <n.r@usa.net> wrote in message
> news:1e04001c29741$9257a100$89
f82ecf@TK2MSFTNGXA01...
>> I have 2.5GB of RAM for SQL2000 and SQL server never
>> crosses 1.7GB for some reason. I have tried sp_configure
>> for enabling AWE. This does not help. Windoes 2000
Server
>> is the OS. And the RAM is recognised by OS.
>>
>> Any clue how i could make SQL to use up the full RAM?.
>>
>> Thank You
>> N.Raja
>
>
>.
>
| |
| Simon Su [MS] 2002-11-28, 9:23 pm |
| Hi N. Raja,
If the total available memory is less than 3 GB, the instance of SQL Server
2000 will be started in non-AWE mode even if awe enabled is set to 1. In
this situation, you do not need to manage AWE memory because dynamic memory
allocation is used automatically. (From BOL).
For a 2.5GB system, you can try.
1) Add /3GB in boot.ini
2) configure "max server memory" to 2.3GB for SQL Server
More info:
Q283037 Large Memory Support Is Available in Windows 2000
http://support.microsoft.com/defaul...b;EN-US;Q283037
Good luck!
Regards,
Simon Su [MS]
-----------------------------
This posting is provided Ħ°AS ISĦħ with no warranties, and confers no rights
|
|
|
|