Link to home
Start Free TrialLog in
Avatar of Intelops
Intelops

asked on

MSSQLSERVER- Insufficient Memory Available

OS : Windows 2003
SQL :SQL 2000 SP4

ERROR.JPG
Avatar of thetime
thetime

Avatar of Intelops

ASKER

Thanks for your reply, The server is having 16 GB of RAM and AWE is enabled.. the above article didnt help
The above article refers to virtual memory, not physical memory. AWE allows SQL to utilize more physical memory. There is a table below showing the different -g start up commands depending on your number of databases, try one of them and see if it solves the problem?
ASKER CERTIFIED SOLUTION
Avatar of thetime
thetime

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial