Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Insufficient Memory SQL Server 2000

Author  Topic  sarah Starting Member 2 Posts Posted - 2001-02-08 : 14:31:49 Currently, I am experiencing memory problems with SQL Server 2000. Daily, I have many "Insufficient memory available" errors in my SQL logs, and "A time out occurred while waiting for memory resources to execute the query. Re-run the query." messages. I have already enabled Address Windowing Extensions. I do not have the /3GB in my boot.ini, but the /PAE is. Implemented is a startup option, -g256, which made no difference, but it is in place. Also, SQL Server is configured for thread mode processing. When I run the PerfMon, SQL Server: Memory Manager, and add up Maximum Workspace Memory, Connection Memory, Lock Memory, Optimizer Memory, and SQL Cache Memory I get around 1.2GB not anywhere near the 6.8GB that the SQL Server process has reserved. System Summary: SQL Server 2000 Enterprise Edition; Windows 2000 Advanced Server; DELL PE8450 8-Way, 700 Mhz, 8GB RAM, MDAC 2.6. Has anyone experienced memory problems with SQL Server 2000? The same code ran on 7.0 without this problem. Any help would be very appreciated. I would be interested in talking with anyone using more than 4GB with AWE enabled. Thank you.