Hi All
Below is the error, that's somewhat getting frequent:
++++++++++++++=====
Failed to reserve contiguous memory of Size= 65536.
Query Memory Manager: Grants=0 Waiting=0 Maximum=148160 Available=148160
2002-12-23 08:22:01.37 spid87 Global Memory Objects: Resource=2547
Locks=72 ...
2002-12-23 08:22:01.37 spid87 Dynamic Memory Manager: Stolen=4115 OS
Reserved=2096 ...
2002-12-23 08:22:01.37 spid87 Procedure Cache: TotalProcs=135
TotalPages=706 InUsePages=703
2002-12-23 08:22:01.37 spid87 Buffer Counts: Commited=872064
Target=872064 Hashed=773613...
2002-12-23 08:22:01.37 spid87 Buffer Distribution: Stolen=3413
Free=94332 Procedures=706...
+++++++++++++++++
If anyone can provide the useful links or info regarding the same, Vl be
great.
Thanks And Regards,
Pardeep Dhull
DBA-IIS
TSR-Somajiguda
(0)9908888273
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
MS Sql Server LazyDBA home page