Memory allocation

[zircon06]

Why a server would only allocate 100k to SQL Server when it's given 4gb. A client has a 2 processor / 4gb RAM server. The sqlserver.exe process is only using 100-200k and not growing. The CPU is pegged at 90-100% during peak hours.

Thanks in advance

 

[ptheriault]

Can you provide us with the details of the server?
What version of SQL and OS
What is the current setting for max server memory?



- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[zircon06]

SQL Server 2000 Enterprise Ed. with /GB /PAE switches in the BOOT.INI and AWE enabled

Thanks

 

[ptheriault]

What is your current setting for max server memory?

- Paul
- If at first you don't succeed, find out if the loser gets anything.