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)  Memory Usage

Author  Topic  bburris Starting Member 4 Posts Posted - 2006-03-17 : 08:59:09 SQL Server 2000 Enterprise SP4 on Windows 2003 SP1: 4Gb RAM. Instance is set to dynamically configure memory up to 4Gb. When instance starts up Target Server Memory is only 1.5GB. After a few days Total Server Memory reaches Target Server Memory and the SQL Server thrashes and pegs the CPU - 100%. We have to reboot the server and start over. The instance is the only one on the server. We are log shipping every 15 minutes to a backup server. Any ideas why memory is not managed better? Can the Target be increased? Is not SQL Server suppossed to deallocate buffers? How can we use more memory?