January 13, 2005 at 4:41 am
Hi,
The following information are found in the Error Log can any one Please tell me about the significant of these error messages
Buffer Distribution: Stolen=2732 Free=42349 Procedures=1
Inram=0 Dirty=1292 Kept=325
I/O=0, Latched=0, Other=175373
Global Memory Objects: Resource=1561 Locks=119 XDES=1
SQLCache=389 Replication=2
LockBytes=2 ServerGlobal=61
Dynamic Memory Manager: Stolen=2733 OS=441 General=2371
Query Plan=2 Optimizer=0
Utilities=7 Connection=794
Procedure Cache: TotalProcs=1 TotalPages=1 InUsePages=1
Query Memory Manager: Grants=0 Waiting=0 Maximum=160875 Available=160875
Buffer Counts: Commited=222072 Target=222072 Hashed=176990
InternalReservation=704 ExternalReservation=0 Min Free=512
version details
Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
Waiting for your valuable comments.
Thanks
Marimuthu
January 13, 2005 at 8:12 am
What error log were those found in? Do you mean the SQL Server Log? If so, that's not an error log.
Reason I ask is that those aren't errors, they are informational messages.
When do you see those messages? After restarting SQL Server?
-SQLBill
January 13, 2005 at 12:59 pm
Yes u are correct these are informational messages found in SQLSERVER ERROR LOG.
yesterday we have these information messages.we have restarted the server 3 months before.
January 17, 2005 at 12:41 pm
The "DBCC MEMORYSTATUS" command will provide the information you just sent.
But when I run this through QA or isql, it does NOT make an entry in the SQL logs, as you said you got???? The information is just displayed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply