Table of valid statistic types for data items

There are six valid statistic types:

• “Value for Sample”

• “Value for Session”

• “Rate for Sample”

• “Rate for Session”

• “Avg for Sample”

• “Avg for Session”

However, all six are not valid for all data items. Table B-3 shows the statistic types that are valid with each data item. In the table:

• A blank cell indicates that the statistic type is not valid with that data item.

• The valid statistic types are indicated by showing the datatype of the resulting data when that statistic type is specified:

  • long and ENUMS indicate integers

  • double indicates floating point numbers

  • charp indicates character strings

    Table B-3: Data items and their valid statistic types

    Statistic type data item	Value for sample	Value for session	Rate for sample	Rate for session	Avg for sample	Avg for session
    Application Execution Class	charp
    Application Name	charp
    Blocking Process ID	long
    Cache Efficiency	double	double
    Cache Hit Pct	double	double
    Cache Hits	long	long	double	double
    Cache ID	long
    Cache Misses	long	long	double	double
    Cache Name	charp
    Cache Prefetch Efficiency	double	double
    Cache Refer and Reuse	long	long	double	double
    Cache Reuse	long	long	double	double
    Cache Reuse Dirty	long	long	double	double
    Cache Size	double
    Cache Spinlock Contention	double	double
    Code Memory Size	long
    Connect Time	long	long
    CPU Busy Percent	double	double
    CPU Percent	double	double
    CPU Time	double	double
    CPU Yields	long	long	double	double
    Current Application Name	charp
    Current Engine	long
    Current Execution Class	charp
    Current Process State	ENUMS
    Current Stmt Batch ID	long
    Current Stmt Batch Text	charp
    Current Stmt Batch Text Byte Offset	long
    Current Stmt Batch Text Enabled	long
    Current Stmt Context ID	long
    Current Stmt CPU Time	double	double
    Current Stmt Elapsed Time	double	double
    Current Stmt Line Number	long
    Current Stmt Locks Granted Immediately	long	long	double	double
    Current Stmt Locks Granted After Wait	long	long	double	double
    Current Stmt Locks Not Granted	long	long	double	double
    Current Stmt Logical Reads	long	long	double	double
    Current Stmt Number	long
    Current Stmt Page I/O	long	long	double	double
    Current Stmt Page Writes	long	long	double	double
    Current Stmt Physical Reads	long	long	double	double
    Current Stmt Procedure Database ID	long
    Current Stmt Procedure Database Name	charp
    Current Stmt Procedure ID	long
    Current Stmt Procedure Name	charp
    Current Stmt Procedure Owner Name	charp
    Current Stmt Procedure Text	charp
    Current Stmt Query Plan Text	charp
    Current Stmt Start Time	charp
    Current Stmt Text Byte Offset	long
    Database ID	long
    Database Name	charp
    Deadlock Count	long	long
    Demand Lock	charp
    Device Hit Percent	double	double
    Device Hits	long	long	double	double
    Device I/O	long	long	double	double
    Device Misses	long	long	double	double
    Device Name	charp
    Device Reads	long	long	double	double
    Device Writes	long	long	double	double
    Elapsed Time	long	long
    Engine Number	long
    Host Name	charp
    Index Logical Reads	long	long	double	double
    Index Physical Reads	long	long	double	double
    Kernel Process ID	long
    Kernel Structures Memory Size	long
    Large I/O Denied	long	long	double	double
    Large I/O Performed	long	long	double	double
    Large I/O Requested	long	long	double	double
    Lock Count	long	long	double	double
    Lock Hit Percent	double	double
    Lock Result	ENUMS
    Lock Results Summarized	ENUMS
    Lock Status	ENUMS
    Lock Status Count	long	long	double	double
    Lock Type	ENUMS
    Locks Being Blocked Count	long
    Locks Granted After Wait	long	long	double	double
    Locks Granted Immediately	long	long	double	double
    Locks Not Granted	long	long	double	double
    Log Contention Percent	double	double
    Logical Page Reads	long	long	double	double
    Login Name	charp
    Most Active Device I/O	long	long	double	double
    Most Active Device Name	charp
    Net Bytes Received	long	long	double	double
    Net Bytes Sent	long	long	double	double
    Net Default Packet Size	long
    Net I/O Bytes	long	long	double	double
    Net Max Packet Size	long
    Net Packet Size Received	double	double	double	double
    Net Packet Size Sent	double	double	double	double
    Net Packets Received	long	long	double	double
    Net Packets Sent	long	long	double	double
    Number of Engines	long
    Number of Processes	long
    Object ID	long
    Object Name	charp
    Object Type	ENUMS
    Owner Name	charp
    Page Cache Size	long
    Page Hit Percent	double	double
    Page I/O	long	long	double	double
    Page Number	long
    Page Writes	long	long	double	double
    Physical Page Reads	long	long	double	double
    Procedure Buffer Size	long
    Procedure CPU Time	double	double			double	double
    Procedure Database ID	long
    Procedure Database Name	charp
    Procedure Elapsed Time	double	double			double	double
    Procedure Execution Class	charp
    Procedure Execution Count	long	long	double	double
    Procedure Header Size	long
    Procedure Hit Percent	double	double
    Procedure ID	long
    Procedure Line Number	long
    Procedure Line Text	charp
    Procedure Logical Reads	long	long	double	double
    Procedure Name	charp
    Procedure Owner Name	charp
    Procedure Physical Reads	long	long	double	double
    Procedure Statement Number	long
    Process ID	long
    Process State	ENUMS
    Process State Count	long
    Rows Deleted	long	long	double	double
    Rows Deleted Deferred	long	long	double	double
    Rows Deleted Direct	long	long	double	double
    Rows Inserted	long	long	double	double
    Rows Inserted Clustered	long	long	double	double
    Rows Inserted Heap	long	long	double	double
    Rows Updated	long	long	double	double
    Rows Updated Deferred	long	long	double	double
    Rows Updated Direct	long	long	double	double
    Rows Updated Expensive	long	long	double	double
    Rows Updated In Place	long	long	double	double
    Rows Updated Not In Place	long	long	double	double
    Select Statements	long	long	double	double
    Server Structures Size	long
    SQL Server Name	charp
    SQL Server Version	charp
    Thread Exceeded Max	long	long	double	double
    Thread Exceeded Max Percent	double	double
    Thread Max Used	long
    Time Waited on Lock	long
    Timestamp	charp
    Timestamp Datim	datim
    Transactions	long	long	double	double

---

Copyright © 2001. Sybase Inc. All rights reserved.

View this book as PDF