May 27, 2009 at 2:11 pm
hi Since last few days I am getting this messages in my error log files in particular timeframe period. Say between 6 am to 8 am.so many users are running some processes may be from .NET or reporting tools that causes this to happen
05/22/2009 07:51:11,spid60,Unknown,Query Memory Manager: Grants=0 Waiting=0 Maximum=32598 Available=32598
05/22/2009 07:51:11,spid60,Unknown,Procedure Cache: TotalProcs=2 TotalPages=18 InUsePages=18
05/22/2009 07:51:11,spid60,Unknown,Dynamic Memory Manager: Stolen=307700 OS Reserved=38256
05/22/2009 07:51:11,spid60,Unknown,Global Memory Objects: Resource=2669 Locks=62
05/22/2009 07:51:11,spid69,Unknown,Buffer Distribution: Stolen=307732 Free=23978 Procedures=18
05/22/2009 07:51:11,spid60,Unknown,Buffer Counts: Commited=659072 Target=659072 Hashed=327344
05/22/2009 07:51:11,spid69,Unknown,Procedure Cache: TotalProcs=2 TotalPages=18 InUsePages=18
05/22/2009 07:51:11,spid69,Unknown,Dynamic Memory Manager: Stolen=307739 OS Reserved=38256
05/22/2009 07:51:11,spid69,Unknown,Buffer Counts: Commited=659072 Target=659072 Hashed=327344
05/22/2009 07:51:11,spid69,Unknown,Global Memory Objects: Resource=2669 Locks=62
05/22/2009 07:51:11,spid69,Unknown,Query Memory Manager: Grants=0 Waiting=0 Maximum=32598 Available=32598
05/22/2009 07:51:11,spid60,Unknown,Buffer Distribution: Stolen=307691 Free=24019 Procedures=18
05/22/2009 07:51:11,spid66,Unknown,Buffer Distribution: Stolen=307891 Free=23819 Procedures=18
05/22/2009 07:51:11,spid66,Unknown,Buffer Counts: Commited=659072 Target=659072 Hashed=327344
05/22/2009 07:51:11,spid66,Unknown,Procedure Cache: TotalProcs=2 TotalPages=18 InUsePages=18
05/22/2009 07:51:11,spid66,Unknown,Dynamic Memory Manager: Stolen=307909 OS Reserved=38264
05/22/2009 07:51:11,spid66,Unknown,Global Memory Objects: Resource=2669 Locks=62
05/22/2009 07:51:11,spid66,Unknown,Query Memory Manager: Grants=0 Waiting=0 Maximum=32598 Available=32598
05/22/2009 07:51:11,spid66,Unknown,WARNING: Failed to reserve contiguous memory of Size= 65536.
05/22/2009 07:51:11,spid69,Unknown,WARNING: Failed to reserve contiguous memory of Size= 65536.
05/22/2009 07:51:11,spid60,Unknown,WARNING: Failed to reserve contiguous memory of Size= 65536.
05/22/2009 07:49:09,logon,Unknown,Login failed for user 'iieentuser'.
05/22/2009 07:47:10,spid69,Unknown,Buffer Distribution: Stolen=281478 Free=50250 Procedures=0
05/22/2009 07:47:10,spid69,Unknown,Buffer Counts: Commited=659072 Target=659072 Hashed=327344
05/22/2009 07:47:10,spid69,Unknown,Dynamic Memory Manager: Stolen=281474 OS Reserved=38144
05/22/2009 07:47:10,spid69,Unknown,Global Memory Objects: Resource=2669 Locks=62
05/22/2009 07:47:10,spid69,Unknown,Query Memory Manager: Grants=0 Waiting=0 Maximum=43831 Available=43831
05/22/2009 07:47:10,spid69,Unknown,Procedure Cache: TotalProcs=0 TotalPages=0 InUsePages=0
05/22/2009 07:47:10,spid66,Unknown,Dynamic Memory Manager: Stolen=281893 OS Reserved=38264
05/22/2009 07:47:10,spid66,Unknown,Buffer Distribution: Stolen=281893 Free=49835 Procedures=0
05/22/2009 07:47:10,spid66,Unknown,Buffer Counts: Commited=659072 Target=659072 Hashed=327344
05/22/2009 07:47:10,spid66,Unknown,Procedure Cache: TotalProcs=0 TotalPages=0 InUsePages=0
I need to know wht these messages means.What precautions should I need to take now? I assume its all related to more memory usage or excessive resource consumptions wht is the best approach to troubleshoot?i ran dbcc memorystatus but not sure how to evaluate the results.Thanks for ur help
May 27, 2009 at 7:21 pm
I have 8 GB RAM on windows 2003 server Enterprise Edition with SP2 and AWE is enabled on sql server.
I can see this after running sp_configure
name minimum maximum config_value run_value
max server memory (MB) 4 2147483647 5149 5149
min server memory (MB) 0 2147483647 0 0
CAn I increase max server memory?how much should i increase?
Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply