Table of data item requirements for playback views

Table C-2 describes the requirements for including data items in a playback view. Read the previous section for explanations of the columns.

Table C-2: Data item requirements for playback views

Data item (keys in an input view are required in a playback view)

Valid for non-raw?

Conditions for inclusion

Application Execution Class

Valid

Value for Sample

Application Name (KEY)

Blocking Process ID

No

Cache Efficiency

Valid

Estimated

Cache Hit Pct

Valid

Calculated from:

  • Cache Hits

  • Cache Misses

Cache Hits

Valid

Full

Cache ID (KEY)1

Cache Misses

Valid

Full

Cache Name1

Valid

Value for Sample

Cache Prefetch Efficiency

Valid

Estimated

Cache Refer And Reuse

Valid

Full

Cache Reuse

Valid

Full

Cache Reuse Dirty

Valid

Full

Cache Size

Valid

Value for Sample

Cache Spinlock Contention

Valid

Estimated

Code Memory Size

Valid

Value for Sample

Connect Time

Valid

Full

CPU Busy Percent

Valid

Estimated

CPU Percent

Valid

Estimated

CPU Time

Valid

Full

CPU Yields

Current Application Name

Current Engine

No

Current Execution Class

No

Current Process State

No

Current Stmt Batch ID

No

Current Stmt Batch Text

No

Current Stmt Batch Text Byte Offset

No

Current Stmt Batch Text Enabled

No

Current Stmt Cache Reads

No

Current Stmt Context ID

No

Current Stmt CPU Time

No

Current Stmt Elapsed Time

No

Current Stmt Line Number

No

Current Stmt Locks Granted Immediately

No

Current Stmt Locks Granted After Wait

No

Current Stmt Locks Not Granted

No

Current Stmt Max Text Config Size

No

Current Stmt Max Text Default Size

No

Current Stmt Max Text Run Size

No

Current Stmt Number

No

Current Stmt Page I/O

No

Current Stmt Page Writes

No

Current Stmt Physical Reads

No

Current Stmt Procedure Database ID

No

Current Stmt Procedure Database Name

No

Current Stmt Procedure ID

No

Current Stmt Procedure Name

No

Current Stmt Procedure Owner Name

No

Current Stmt Procedure Text

No

Current Stmt Query Plan Text

No

Current Stmt Start Time

No

Current Stmt Text Byte Offset

No

Database ID (KEY)

Valid

Database Name

Valid

Value for Sample

Deadlock Count

Valid

Full

Demand Lock

No

Device Hit Percent

Valid

Calculated from:

  • Device Hits

  • Device Misses

Device Hits

Valid

Full

Device I/O

Valid

Full

Device Misses

Valid

Full

Device Name (KEY)

Valid

Value for Sample

Device Reads

Valid

Full

Device Writes

Valid

Full

Elapsed Time2

Valid

Full

Engine Number (KEY)

Valid

Value for Sample

Host Name

No

Index Logical Reads

Valid

Full

Index Physical Reads

Valid

Full

Kernel Process ID (KEY)

Valid

Value for Sample

Kernel Structures Memory Size

Valid

Value for Sample

Large I/O Denied

Valid

Full

Large I/O Performed

Valid

Full

Large I/O Requested

Valid

Full

Lock Count

Valid

Full

Lock Hit Percent

Valid

Estimated

Lock Result (KEY)

Valid

Value for Sample

Lock Results Summarized (KEY)

Valid

Value for Sample

Lock Status (KEY)

Valid

Value for Sample

Lock Status Count

No

Lock Type (KEY)

Valid

Value for Sample

Locks Being Blocked Count

No

Locks Granted Immediately

Valid

Full

Locks Granted After Wait

Valid

Full

Locks Not Granted

Valid

Full

Log Contention Percent

Valid

Estimated

Logical Page Reads

Valid

Full

Login Name

Valid

Value for Sample

Most Active Device I/O

No

Most Active Device Name

No

Net Bytes Received

Valid

Full

Net Bytes Sent

Valid

Full

Net Default Packet Size

Valid

Value for Sample

Net I/O Bytes

Valid

Full

Net Max Packet Size

Valid

Value for Sample

Net Packet Size Received

Valid

Calculated from:

  • Net Packets Received

  • Net Bytes Received

Net Packet Size Sent

Valid

Calculated from:

  • Net Packets Sent

  • Net Bytes Sent

Net Packets Received

Valid

Full

Net Packets Sent

Valid

Full

Number of Engines

Valid

Value for Sample

Number of Processes

Valid

Estimated

Object ID (KEY)

Valid

Value for Sample

Object Name

Valid

Value for Sample

Object Type

Valid

Value for Sample

Owner Name

Valid

Value for Sample

Page Cache Size

Valid

Value for Sample

Page Hit Percent

Valid

Calculated from:

  • Logical Reads

  • Physical Reads

Page I/O

Valid

Full

Page Number (KEY)

Valid

Value for Sample

Page Writes

Valid

Full

Physical Page Reads

Valid

Full

Procedure Buffer Size

Valid

Value for Sample

Procedure CPU Time

Procedure Database ID (KEY)

Valid

Value for Sample

Procedure Database Name

Valid

Full

Procedure Elapsed Time

Valid

Requires: Procedure Execution Count

See “Using Procedure Elapsed Time and Procedure CPU Time”

Procedure Execution Class

No

Procedure Execution Count

Valid

Full

Procedure Header Size

Valid

Value for Sample

Procedure Hit Percent

Valid

Calculated from:

  • Procedure Logical Reads

  • Procedure Physical Reads

Procedure ID (KEY)

Valid

Value for Sample

Procedure Line Number (KEY)

Valid

Value for Sample

Procedure Line Text

Valid

Value for Sample

Procedure Logical Reads

Valid

Full

Procedure Name

Valid

Value for Sample

Procedure Owner Name

Valid

Value for Sample

Procedure Physical Reads

Valid

Full

Procedure Statement Number (KEY)

Valid

Value for Sample

Process ID (KEY)

Valid

Value for Sample

Process State (KEY)

Valid

Value for Sample

Process State Count

No

Rows Deleted

Valid

Full

Rows Deleted Deferred

Valid

Full

Rows Deleted Direct

Valid

Full

Rows Inserted

Valid

Full

Rows Inserted Clustered

Valid

Full

Rows Inserted Heap

Valid

Full

Rows Updated

Valid

Full

Rows Updated Deferred

Valid

Full

Rows Updated Direct

Valid

Full

Rows Updated Expensively

Valid

Full

Rows Updated In Place

Valid

Full

Rows Updated Not In Place

Valid

Full

Select Statements

Valid

Full

Server Structures Size

Valid

Value for Sample

SQL Server Name

Valid

Value for Sample

SQL Server Version

Valid

Value for Sample

Thread Exceeded Max

Valid

Full

Thread Exceeded Max Percent

Valid

Full

Thread Max Used

No

Time Waited on Lock

No

Timestamp2

Valid

Value for Sample

Timestamp Datim2

Valid

Value for Sample

Transactions

Valid

Full

1. In versions earlier than 11.5, Cache Name was a key. Currently, Cache Name is a result. A new key, Cache ID, replaces the key Cache Name. For compatibility, Cache Name remains valid as a key. However, for efficiency and for forward compatibiltiy, use Cache ID as the key in new views.

2. These data items can be included in any playback view even if not present in the input view.