September 5, 2006 at 7:24 am
I am getting the following entries in my SQL Server Log a few times per day. One of my nightly backups also failed and I think these messages are related.
WARNING: Clearing procedure cache to free contiguous memory.
Buffer Distribution: Stolen=3981 Free=178891 Procedures=9
Inram=0 Dirty=650 Kept=874
I/O=0, Latched=0, Other=47155
Buffer Counts: Commited=231560 Target=231560 Hashed=48679
InternalReservation=930 ExternalReservation=0 Min Free=512
Procedure Cache: TotalProcs=2 TotalPages=9 InUsePages=8
Dynamic Memory Manager: Stolen=3990 OS=443 General=4205
Query Plan=9 Optimizer=0
Utilities=55 Connection=164
Global Memory Objects: Resource=3801 Locks=55 XDES=1
SQLCache=230 Replication=2
LockBytes=2 ServerGlobal=20
Query Memory Manager: Grants=0 Waiting=0 Maximum=166554 Available=166554
September 5, 2006 at 7:40 am
found a kb article that might apply: (for standard edition)
http://support.microsoft.com/kb/316749/
Otherwise, are you profiling any performance counters?
September 5, 2006 at 7:40 am
found a kb article that might apply: (for standard edition)
http://support.microsoft.com/kb/316749/
Otherwise, are you profiling any performance counters?
September 5, 2006 at 7:45 am
Thanks for the link. It is not a direct hit because this server only has 51 databases, not 500. But, you never know. I will keep an eye on that -g switch just in case it helps.
RH
September 5, 2006 at 8:29 am
This warning was the symptom of the pressure in MemToLeave area in SQL Memory.
What is the current build of SQL Server? Run @@version in query analyzer and post the results.
Bad components that load in MemToLeave area such as extended stored procedures, OLE Automation/COM objects, linked server OLEDB providers and ODBC drivers, MAPI components used by SQLMail. This component may cause memory leak.
Are you using any of above?
HTH
September 5, 2006 at 8:37 am
SQL 7.00.1063
Yes, I use linked servers via OLDEB (other SQL boxes) and ODBC (AS400).
No - I can't immediately retire the box or upgrade it.
Thanksf or the info. RH
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply