SolarWinds Information Service v3.0 Schema Documentation

Index

DPA.WaitData

Base type: System.Entity

Summary: PerfStack data explorer data for waits

Properties

Name Type Notes
DatabaseInstanceId System.Int32
GlobalDatabaseInstanceID System.Int32 Unique ID of Database Instance
PrimaryDimension System.String Name of a primary dimension. Has to be equal to dimension name without non-alphanumeric characters. See the names in NormalizedDataDimension class
PrimaryDimensionValue System.String Single value uniquely identifying the dimension entry.
WaitTime System.Double Total Wait Time for this dimension entry in given time interval.
TotalWaitPercentage System.Double Percentage of Total Wait Time in given time interval.
Executions System.Int32 Number of query executions from SQL Statistics (CONSS_xx). Available only for SQL / TOP_WAIT primary dimension.
WaitTypes System.String Comma separated list of Wait Types for SQL / TOP_WAIT dimensions for 1 hour of data. NULL for all other dimensions.
Databases System.String Comma separated list of Databases for SQL / TOP_WAIT dimensions for 1 hour of data. NULL for all other dimensions.
DbUsers System.String Comma separated list of Database Users for SQL / TOP_WAIT dimensions for 1 hour of data. NULL for all other dimensions.
Machines System.String Comma separated list of Machines for SQL / TOP_WAIT dimensions for 1 hour of data. NULL for all other dimensions.
Programs System.String Comma separated list of Programs for SQL / TOP_WAIT dimensions for 1 hour of data. NULL for all other dimensions.
Text System.String Additional text. Currently only used for SQL / TOP_WAIT dimension to provide first part of the SQL query from CONST_xx.
Link System.String URL link. Will be used to provide URLs for Perfstack that'll lead to more details about the entry.
Time System.DateTime Time of the data point.
Interval System.Int32 Duration of the data point in seconds.
Rank System.Int32 Order of the entry based on its total wait time.
DisplayName System.String
Description System.String
InstanceType System.Type
Uri System.String
InstanceSiteId System.Int32 Default='0'.