View Single Post

   
  #4 (permalink)  
Old 02-27-2008, 04:27 AM
peteh
 
Posts: n/a
Default Re: Snapshot_LockWait table function question

Hi Serge;
That makes sense. Given the monitor switch settings below, would we
incur any significant overhead by turning the "LOCK" switch on? Seems
like if the Statement and Timestamp switches are already on, the impact
would be minimal. Can you (or the the "backstage") confirm? Thanks very
much!

Pete H

---------------------------------------------------------------
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = ON
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = OFF
----------------------------------------------------------------

Reply With Quote