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.