Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2007-02-24 : 03:11:23
|
| Hi allIn Our production server log i found a huge number of logs as follows.2007-02-20 17:31:42.66 spid134 Buffer Distribution: Stolen=91073 Free=1589 Procedures=70690 Inram=0 Dirty=213457 Kept=0 I/O=0, Latched=199, Other=35451682007-02-20 17:31:42.66 spid134 Buffer Counts: Commited=3922176 Target=3922176 Hashed=3758824 InternalReservation=638 ExternalReservation=327 Min Free=832 Visible= 1745202007-02-20 17:31:42.66 spid134 Procedure Cache: TotalProcs=23534 TotalPages=70690 InUsePages=705072007-02-20 17:31:42.66 spid134 Dynamic Memory Manager: Stolen=161710 OS Reserved=1640 OS Committed=1603 OS In Use=1585 Query Plan=142035 Optimizer=40 General=13862 Utilities=16 Connection=66102007-02-20 17:31:42.66 spid134 Global Memory Objects: Resource=8522 Locks=285 SQLCache=3395 Replication=3 LockBytes=2 ServerGlobal=33 Xact=1855...May i know what does this mean..what to do to avoid it..Thanks |
|
|
|
|
|
Error log from Production server