Hi Everyone, I'm trying to figure out information concerning the dirty page and it says to check the buffer pool statistics. What command can I run to find the appropriate information?
Any help is appreciated. Thanks! Dirty page Lsn=26108034.23.2782, Last DB backup Lsn=26115521.189.972, Transaction table Lsn=26115382.78.3144, Running DB backup Lsn=0.0.0, Log truncation Lsn=26108034.23.2782 Lsn=26108034.23.2782, Owner=DB, Length=56 Type=Update, Flags=C2, Action=AllocPage, Page=21964800, Tsn=0:2.907583537, PrevLsn=26108033.124.2499, UndoNextLsn=0.0.0, UpdtLsn=26108033.127.1472 ===> Bit Offset = 173 The recovery log is pinned by a dirty page in the data base buffer pool. Check the buffer pool statistics. If the associated transaction is still active then more information will be displayed about that transaction. Database buffer pool global variables: CkptId=1850569, NumClean=124335, MinClean=262048, NumTempClean=262144, MinTempClean=131024, BufPoolSize=262144, BufDescCount=262250, BufDescMaxFree=288358, DpTableSize=262144, DpCount=137805, DpDirty=137803, DpCkptId=1836176, DpCursor=26904, NumEmergency=0 CumEmergency=0, MaxEmergency=0. BuffersXlatched=2, xLatchesStopped=False, FullFlushWaiting=False. ________________________________ This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
