This section lists data items in alphabetical order with the following information:
Description
Server level status
Result or key designation
For result data items, required keys and optional keys
For key data items, result data items that require the key data item and result data items that can use the key data item, but do not require it
Version compatibility: either SQL Server 11.0 or Adaptive Server 11.5 and later
Valid statistical types
The valid statistical types are as follows:
SMC_STAT_VALUE_SAMPLE
SMC_STAT_VALUE_SESSION
SMC_STAT_RATE_SAMPLE
SMC_STAT_RATE_SESSION
SMC_STAT_AVG_SAMPLE
SMC_STAT_AVG_SESSION
The possible datatypes for a data item are:
LONG – long
ENUMS – integer
DOUBLE – double
CHARP – character
DATIM – date/time
For more information about enumerated types, see Appendix B, “Datatypes and Structures”.
Not all statistical types are available for each data
item.
You cannot use SMC_NAME_SPID and SMC_NAME_APPLICATION_NAME in the same view.
