SQL Service Response Time Considerations
Transactions Per Logon.
User Calls Per Second
User Calls Ratio
User Commits Percentage
User Limit Percentage
User Rollbacks Per Second
User Rollbacks Percentage
User Transaction Per Second
Background Checkpoints Per Second
CR Blocks Created Per Second
CR Blocks Created Per Transaction
Database Time Per Second
Database Wait Time Ratio
DB Block Changes Per Second
DB Block Changes Per Transaction
Branch Node Splits Per Second
Branch Node Splits Per Transaction
Consistent Read Changes Per Second
Consistent Read Changes Per Transaction
Consistent Read Gets Per Second
Consistent Read Gets Per Transaction
CR Undo Records Applied Per Second
CR Undo Records Applied Per Transaction
DB Block Changes Per User Call
DB Block Gets Per Second
DB Block Gets Per Transaction
DB Block Gets Per User Call
DBWR Checkpoints Per Second
Enqueue Deadlocks Per Second
Enqueue Deadlocks Per Transaction
Enqueue Requests Per Second
Enqueue Requests Per Transaction
Enqueue Timeouts Per Second
Enqueue Timeouts Per Transaction
Enqueue Waits Per Second
Enqueue Waits Per Transaction
Execute Without Parse Ratio
Executions Per Second
Executions Per Transaction
Executions Per User Call.
Full Index Scans Per Second
Full Index Scans Per Transaction
GC CR Block Received Per Second
GC CR Block Received Per Transaction
GC Current Block Received Per Second
GC Current Block Received Per Transaction
Leaf Node Splits Per Second
Leaf Node Splits Per Transaction
Library Cache Hit Ratio
Library Cache Miss Ratio
Logical Reads Per Second
Logical Reads Per Transaction
Logical Reads Per User Call
Logons Per Transaction.
Long Table Scans Per Second
Long Table Scans Per Transaction
Physical Reads Direct Lobs Per Second
Physical Reads Direct Lobs Per Transaction
Physical Reads Direct Per Transaction
Physical Reads Per Second
Physical Reads Per Transaction
Physical Writes Per Transaction
Physical Writes Direct Per Transaction
Physical Writes Direct Lobs Per Transaction
Physical Writes Direct Lobs Per Second
Redo Generated Per Second
Redo Generated Per Transaction
Redo Writes Per Second
Redo Writes Per Transaction