Failed to reserve contiguous memory of Size= 65536

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)

Failed to reserve contiguous memory of Size= 65536

Author

Topic

OMB
Yak Posting Veteran

88 Posts

Posted - 2005-09-20 : 03:44:16

Hi All

I have the SQL server enterprise edition SP3 running on a cluster with the following hardware:

Twin 2.8g P4 hyperthreading processors
3.8G RAM each cluster

Recently I have seen the following errors in the the log files:


WARNING:  Failed to reserve contiguous memory of Size= 65536.

Buffer Distribution:  Stolen=4294938038 Free=233 Procedures=264593
		Inram=0 Dirty=1688 Kept=0
		I/O=0, Latched=25, Other=83318

Buffer Counts:  Commited=320599 Target=337816 Hashed=85031
		InternalReservation=224 ExternalReservation=0
                Min Free=252

Procedure Cache:TotalProcs=35601  totalPages=264593 
                UsePages=106221

Dynamic Memory Manager:  Stolen=235335 OS Reserved=38000 
		OS Committed=37971
		OS In Use=37787
		Query Plan=264480 Optimizer=0
		General=8335

It has happened three times and on each occasion it has caused one of our apps to fail. I have made several searches to fix this problem, and the majority of articles point to network packets or memory allocation issues . Most advise reconfiguring these variables. However I am reluctant to do this. Can any one help on how I troubleshoot this problem or point in the right direction.

Any help will be appreciated.

OMB

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources