Create Session Level Performance Objects
Contention information – where user connections have been bottlenecked and waiting to accomplish their requests. Includes waits, locks, and deadlock activity.
SQL Execution metrics – includes per-connection capture and reporting of issued SQL statements and their performance metrics (scans, sorts, etc.)
Time model – where user connections have been spending their time; what activities have consumed most of the each connection’s attention.
I/O statistics – metrics concerning all I/O activity at the user connection level
Resource usage – metrics concerning elements such as memory, CPU, etc., for user connections (if available)
General performance metrics – everything from network activity, etc., for each user connection.
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Medium
- Drafter:
- Brian Aker
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- Discussion
- Series goal:
- Accepted for trunk
- Implementation:
- Not started
- Milestone target:
- future
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Work Items
Dependency tree
* Blueprints in grey have been implemented.