Expand All Collapse All
Distribution Queue Config

DQConfig Table

Distribution Queue Config

Service Level statistics depend on the definition that was in effect at the time the statistics was being gathered. Relying on IA for historical service level configuration settings may not provide an accurate picture what the service level statistics represented because the configuration might have been changed. Because of this need, the service level configuration settings are included with the underlying statistics so that the historical settings can be maintained.

For every distinct service level configuration settings, a unique identifier is introduced and is maintained in this table. The identifier is referred as ConfigurationSet. As only distinct settings make it to this table, the size of this table is expected be small.

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ConfigurationSet int False No

The unique identifier referencing this service level configuration settings.

 4.0.106.453 4.0 Release
dIntervalStartUTC datetime False No

The UTC time that this service level configuration was introduced.

 4.0.106.453 4.0 Release
nServiceLevel int False No

First dimension. The possible values depend on the type of data. Please refer to each of the queue period data.

 4.0.106.453 4.0 Release
cServiceLevels varchar (1024) True No

A string in XML format that consists of service level bucket configuration that the statistics row was tabulated against.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_DQConfig Clustered ConfigurationSet (Ascending)


Index Name Type Column Name (sort order)
UX_DQConfig Unique non-clustered nServiceLevel (Ascending)
cServiceLevels (Ascending)