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)¹
Cache Misses	Valid	Full
Cache Name¹	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 Time²	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
Timestamp²	Valid	Value for Sample
Timestamp Datim²	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.