AveDirReadTime=Direct Read Time / Direct Read To Database
AveDirWriteTime=Direct Write Time / Direct Writes To Database
AveNumSectorsRead=Direct Reads from DB / Direct Read Requests
AveNumSectorsWritten=Direct Writes from DB / Direct Write Requests
AveSortTime=Total Sort time / Total Sorts
PctOverflowSortReqs=(Sort Overflows / Total Sorts) * 100
TableSpaceIO
= Total Read/ Write Time
=elapsed time required to perform the direct reads from disk
+
elapsed time required to perform the direct writes to disk
+
elapsed time spent processing read requests that caused data or index pages to be physically read from disk to buffer pool
+
elapsed time spent physically writing data or index pages from the buffer pool to disk
TotThroughput=Dynamic SQL Statements Attempted + Static SQL Statements Attempted + Failed Statement Operations
TotUOW=Commit Statements Attempted + Internal Commits + Rollback Statements Attempted + Internal Rollbacks
DBFilesClosed
PctLockedOutDBConns=(Current Applications Waiting on Locks / Applications Executing in DBM Currently) * 100
PctDBLocklistUsed=(Total Locklist Memory In Use / (locklist * 4096)) * 100
AveWaitForLock=Total Time Waited On Locks / Number of Lock Waits
PctAppsWaitingOnLocks=(Current Applications Waiting On Locks / Applications Connected Currently) * 100
NumLocksRemaining=((Locklist * 4096) / 36) - Locks Held
BackupTime=((currentTime in seconds - LastBackupTime in seconds) / 3600)
DataPgHitRatio=(1 - (Buffer Pool Data Physical Reads / Buffer Pool Data Logical Reads)) * 100
PctPagesUsed=100 * (Pages Used / (Pages Used + Space Available))
沒有留言:
張貼留言