October 9, 2002 at 1:21 pm
SQL Server 2000:
This just occured in Enterprise Manager, Error Log.
"WARNING: Clearing procedure cache to free contiguous memory."
"Dynamic Memory Manager:
Stolen=721 OS=380 General=871
Query Plan=4 Optimizer=10
Utilities=24 Connection=192"
"Procedure Cache:
TotalProcs=1 TotalPages=1 InUsePages=1"
"Buffer Counts:
Commited=153601 Target=162336 Hashed=84175
InternalReservation=206 ExternalReservation=0 Min Free=205"
What is this stuff?
Details please!!!!!!!!!!!!
October 9, 2002 at 4:57 pm
Take a look here, http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316749
To me it sounds like you have more than 2GB of memory on the server and don't have the server enabled to work with.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 9, 2002 at 9:52 pm
Memory in the box:
1GB + 256MB stick.
(NT 4.0, SQL Server 7.0)
October 10, 2002 at 3:48 am
If the box is under 2GB then you will not see a benefit with using the -g switch but the infomation is what applies.
quote:
This message may indicate that SQL Server is trying to free parts of the SQL Server memory pool in order to find space for items such as extended stored procedure .dll files or automation objects. In this case, consider increasing the amount of memory reserved by the -g switch. Using a value lower than the default will increase the amount of memory available to the buffer pool and thread stacks; this may, in turn, provide some performance benefit to memory-intensive workloads in systems that do not use many extended stored procedures, distributed queries, or automation objects.
SQL is trying to reallocate memory, if this happens often, which from what I see this is a first so may be no biggie, then you may have a memory leak somewhere or so installation issue (possibly for install or some other applications installation is the root issue). If becomes common and you cannot resolve thru the latest service pack, since your configuration does not match the base requirements for a know issue, you may need to open a ticket with Microsoft.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply