Allocating Memory to SQL Server

[Alex S]

Hey there.

I have a raid 5 server with 128 mb of ram.
How can i allocate 100 mb to sql server and 28 to NT4.00.




THANK YOU IN ADVANCE.

[Craig]

On 11/5/98 3:21:42 PM, Alex S wrote:
> Hey there.

I have a raid 5 server with 128 mb of ram.
How can i
> allocate 100 mb to sql server and 28 to NT4.00.




THANK YOU IN ADVANCE.

++++++++++
Microsoft recommends a minimum of 63 meg for NT 4.0

So, 128 meg - 64 meg for NT = 64 meg for SQL Server
Set sp_configure 'memory' = 32000.

Enjoy..........