SYSTEMPROVIDERSACTIVE: Data Dictionary Active System Providers

ABBREVIATION

string(30)

Abbreviation

☑

Abbreviation.

BULK_INSERT_COUNT

int32

Bulk Insert Count

☑

Number of times a bulk insert was executed.

BULK_INSERT_DURATION_MAX_MS

int64

Bulk Insert Duration Maximum (ms)

☑

Maximum time spent in ms during bulk insert.

BULK_INSERT_DURATION_TOTAL_MS

int64

Bulk Insert Duration Total (ms)

☑

Total time spent in ms during bulk insert.

BULK_INSERT_PAGE_COUNT

int32

Bulk Insert Page Count

☑

Number of times a bulk page insert was executed.

BULK_INSERT_ROW_COUNT

int64

Bulk Insert Row Count

☑

Number of rows inserted in bulk.

COMMERCIAL_NAME

string(240)

Commercial Name

☑

Commercial name.

COMMUNITY_EDITION

boolean

Is Community Edition

☑

Is application software offered for free?

CONNECTION_OPENED_AT_UTC

datetime

Connection Opened at (UTC)

☐

Time the connection was opened (UTC).

DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

☐

Data container alias.

DATA_CONTAINER_ID

string(4000)

Data Container ID

☐

Data container ID.

DATABASE_POOL_DESCRIPTION

string(4000)

Database Pool Description

☐

Database pool description, in which multiple databases are pooled.

DATABASE_PRICING_TIER

string(240)

Database Pricing Tier

☐

Database pricing tier.

DATABASE_SERVICE_TIER

string(240)

Database Service Tier

☐

Database service tier.

DATABASE_VERSION_NUMBER

string(240)

Database Version Number

☐

Current database version number.

DATABASE_VERSION

string(240)

Database Version

☐

Current database version including platform, edition and version number.

DEFAULT_CONNECTION_ID

guid

Default Connection ID

☑

Default GUID for first discovered connection of this provider.

DEFAULT_NUMBER_PARALLEL_REQUESTS

int32

Default Number of Parallel Requests

Default number of parallel requests.

DEFAULT_SLOTBASED_RATE_LIMIT_LENGTH_MS

int64

Default Slot-based Rate Limit Length (ms)

☑

Default length in ms of a slot-based rate limit.

DEFAULT_SLOTBASED_RATE_LIMIT_SLOTS

int32

Default Slot-based Rate Limit Slots

☐

Default number of slots of a slot-based rate limit.

DESCRIPTION

string(4000)

Provider Description

☑

Provider description.

DISPLAY_NAME

string(240)

Display Name

☑

Display name.

DOCUMENTATION_URL

string(4000)

Documentation (URL)

☐

Documentation URL.

DOCUMENTATION

string(32767)

Documentation

☐

Documentation.

DOWNLOAD_IMPLEMENTATION_URL

string(4000)

Download Implementation URL

☐

Download URL for implementation.

HTTP_DISK_CACHE_HITS

int32

HTTP Disk Cache Hits

☑

Number of HTTP disk cache hits.

HTTP_DISK_CACHE_INCORRECT_CONTENT_HITS

int32

HTTP Disk Cache Incorrect Content Hits

☑

HTTP disk cache number of incorrect content hits.

HTTP_DISK_CACHE_MISSES

int32

HTTP Disk Cache Misses

☑

Number of HTTP disk cache misses.

HTTP_DISK_CACHE_READ_BYTES

int64

HTTP Disk Cache Read (byte)

☑

Number of HTTP disk cache disk bytes.

HTTP_DISK_CACHE_READ_DECOMPRESS_OPERATIONS

int64

HTTP Disk Cache Read Decompress Operations

☑

Number of HTTP disk cache decompress operations.

HTTP_DISK_CACHE_READ_DECOMPRESSED_BYTES

int64

HTTP Disk Cache Read Decompressed (byte)

☑

Number of HTTP disk cache decompressed bytes.

HTTP_DISK_CACHE_READ_DECRYPT_DURATION_MS

int64

HTTP Disk Cache Read Decrypt Duration (ms)

☑

Number of HTTP disk cache read decrypt duration (ms).

HTTP_DISK_CACHE_READ_DECRYPT_OPERATIONS

int64

HTTP Disk Cache Read Decrypt Operations

☑

Number of HTTP disk cache decrypt operations.

HTTP_DISK_CACHE_READ_DECRYPTED_BYTES

int64

HTTP Disk Cache Read Decrypted (byte)

☑

Number of HTTP disk cache decrypted bytes.

HTTP_DISK_CACHE_READ_OPERATIONS

int64

HTTP Disk Cache Read Operations

☑

Number of HTTP disk cache operations.

HTTP_DISK_CACHE_UNSUPPORTED_ENCRYPTION_HITS

int32

HTTP Disk Cache Unsupported Encryption Hits

☑

HTTP disk cache number of unsupported encryption hits.

HTTP_DISK_CACHE_UNSUPPORTED_FORMAT_HITS

int32

HTTP Disk Cache Unsupported Format Hits

☑

HTTP disk cache number of unsupported format hits.

HTTP_DISK_CACHE_WRITE_BYTES

int64

HTTP Disk Cache Write (byte)

☑

Number of HTTP disk cache disk cache write bytes.

HTTP_DISK_CACHE_WRITE_COMPRESS_OPERATIONS

int64

HTTP Disk Cache Write Compress Operations

☑

Number of HTTP disk cache write compress operations.

HTTP_DISK_CACHE_WRITE_COMPRESSED_BYTES

int64

HTTP Disk Cache Write Compressed (byte)

☑

Number of HTTP disk cache write compressed bytes.

HTTP_DISK_CACHE_WRITE_ENCRYPT_DURATION_MS

int64

HTTP Disk Cache Write Encrypt Duration (ms)

☑

Number of HTTP disk cache write encrypt duration (ms).

HTTP_DISK_CACHE_WRITE_ENCRYPT_OPERATIONS

int64

HTTP Disk Cache Write Encrypt Operations

☑

Number of HTTP disk cache write encrypt operations.

HTTP_DISK_CACHE_WRITE_ENCRYPTED_BYTES

int64

HTTP Disk Cache Write Encrypted (byte)

☑

Number of HTTP disk cache write encrypted bytes.

HTTP_DISK_CACHE_WRITE_OPERATIONS

int64

HTTP Disk Cache Write Operations

☑

Number of HTTP disk cache write operations.

HTTP_MEMORY_CACHE_COUNT

int32

HTTP Memory Cache Count

☑

Number of entries in memory cache.

HTTP_MEMORY_CACHE_HITS

int32

HTTP Memory Cache Hits

☑

Number of memory cache hits.

HTTP_MEMORY_CACHE_INCORRECT_CONTENT_HITS

int32

HTTP Memory Cache Incorrect Content Hits

☑

Number of memory cache incorrect content hits.

HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_MAX

double

HTTP Memory Cache Misses Fetch Time Maximum (ms)

☑

Maximum original HTTP memory cache fetch time (ms).

HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_MIN

double

HTTP Memory Cache Misses Fetch Time Minimum (ms)

☑

Minimum original HTTP memory cache fetch time (ms).

HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_TOTAL

double

HTTP Memory Cache Misses Fetch Time Total (ms)

☑

Total original HTTP memory cache fetch time (ms).

HTTP_MEMORY_CACHE_MISSES

int32

HTTP Memory Cache Misses

☑

Number of memory cache misses.

HTTP_MEMORY_CACHE_SIZE

int64

HTTP Memory Cache Cache Size

☑

Estimated size of character of the memory cache.

HTTP_MEMORY_CACHE_UNSUPPORTED_FORMAT_HITS

int32

HTTP Memory Cache Unsupported Format Hits

☑

Number of memory cache unsupported format hits.

HTTP_REQUESTS_EXECUTED

int32

HTTP Requests Executed

☑

Number of HTTP requests made.

ICON_RESOURCE_NAME_16

string(240)

Icon Resource Name (16x16)

☐

Name of file with 16x16 icon.

INFLUENCES_MAXIMUM_NUMBER_JOINS

boolean

Influences Maximum Number of Joins

☑

Influences maximum number of joins?

IS_CATALOG_USED_IN_FULL_QUALIFIED_NAME

boolean

Is Catalog Used in Full Qualified Name

☑

Whether the catalog name is used in constructing the full qualified name.

IS_DEFAULT_FLAG

boolean

Is Default?

☑

Is the default provider?

IS_SCHEMA_USED_IN_FULL_QUALIFIED_NAME

boolean

Is Schema Used in Full Qualified Name

☑

Whether the schema name is used in constructing the full qualified name.

IS_SERVICE_PROVIDER_FLAG

boolean

Is Service Provider?

☑

Is the provider a service provider?

MAIN_CATEGORY

string(240)

Main Category

☑

Main category.

MAXIMUM_NUMBER_PARALLEL_REQUESTS

int32

Maximum Number of Parallel Requests

Maximum number of parallel requests.

MAXIMUM_NUMBER_USABLE_PARTITIONS

int32

Maximum Number of Usable Partitions

Maximum number of usable partitions.

NAME

string(240)

Provider Name

☑

Name of the provider.

PARTITION_CODE_COLUMN_NAME

string(240)

Partition Code Column Name

☐

Name of the partition code column.

PARTITION_LABEL_SINGULAR

string(240)

Partition Label Singular

☐

Partition label in singular form.

PRODUCTION_USE_ALLOWED

boolean

Production Use Allowed

☑

Is production use allowed?

PROVIDER_INSTANCE_UID

guid

Provider Instance UID

☑

Unique ID of the provider instance.

PUBLIC_DATA

boolean

Is Public Data?

☑

Is the data offered publicly?

SESSION_IO_BYTES_RECEIVED_OTHER

int64

I/O Execution Bytes Received Other

☑

Number of bytes sent (other).

SESSION_IO_BYTES_RECEIVED_OVERALL

int64

I/O Execution Bytes Received

☑

Number of bytes sent overall.

SESSION_IO_BYTES_RECEIVED_READ

int64

I/O Execution Bytes Received Read

☑

Number of bytes sent for read.

SESSION_IO_BYTES_RECEIVED_WRITE

int64

I/O Execution Bytes Received Write

☑

Number of bytes sent for write.

SESSION_IO_BYTES_SENT_OTHER

int64

I/O Execution Bytes Sent Other

☑

Number of bytes received (other).

SESSION_IO_BYTES_SENT_OVERALL

int64

I/O Execution Bytes Sent

☑

Number of bytes received overall.

SESSION_IO_BYTES_SENT_READ

int64

I/O Execution Bytes Sent Read

☑

Number of bytes received for read.

SESSION_IO_BYTES_SENT_WRITE

int64

I/O Execution Bytes Sent Write

☑

Number of bytes received for write.

SESSION_IO_DURATION_MS_OTHER

int64

I/O Execution Duration Other (ms)

☑

Total duration for other in milliseconds.

SESSION_IO_DURATION_MS_OVERALL

int64

I/O Execution Duration (ms)

☑

Total duration overall in milliseconds.

SESSION_IO_DURATION_MS_READ

int64

I/O Execution Duration Read (ms)

☑

Total duration for read in milliseconds.

SESSION_IO_DURATION_MS_WRITE

int64

I/O Execution Duration Write (ms)

☑

Total duration for write in milliseconds.

SESSION_IO_EXECUTION_COUNT_OTHER

int64

I/O Execution Count Other

☑

Number of I/Os executed (other).

SESSION_IO_EXECUTION_COUNT_OVERALL

int64

I/O Execution Count

☑

Number of I/Os executed overall.

SESSION_IO_EXECUTION_COUNT_READ

int64

I/O Execution Count Read

☑

Number of I/Os executed for read.

SESSION_IO_EXECUTION_COUNT_WRITE

int64

I/O Execution Count Write

☑

Number of I/Os executed for write.

SHORT_NAME

string(240)

Provider Short Name

☑

Provider short name.

SLOTBASED_RATE_LIMIT_LENGTH_MS

int64

Slot-based Rate Limit Length (ms)

☑

Length in ms of a slot-based rate limit.

SLOTBASED_RATE_LIMIT_SLOTS

int32

Slot-based Rate Limit Slots

☐

Number of slots of a slot-based rate limit, null means no limit.

SQL_PREFIX_PARAMETER

string(30)

SQL Prefix Parameter

☐

SQL parameter prefix.

STRING_COMPARISON_IS_CASE_SENSITIVE

boolean

String Comparison is Case-Sensitive

☑

Whether the provider matches string case-sensitive.

SUPPORTS_COLUMN_FILTERING

boolean

Supports Column Filtering

☑

Whether column filtering is supported; if true, the provider can filter the resulting columns itself based on a select statement.

SUPPORTS_NATIVE_SCALAR_REQUESTS

boolean

Supports Native Scalar Requests

☑

Whether the platform supports native scalar requests.

SUPPORTS_NATIVE_SQL

boolean

Supports Native SQL

☑

Whether the platform supports native SQL.

SUPPORTS_ORDERING

boolean

Supports Ordering

☑

Whether the provider supports ordering.

SUPPORTS_SIMPLE_FILTER_DELETE

boolean

Supports Simple Filter Delete

☑

Whether the provider supports delete using simple filters.

SUPPORTS_SIMPLE_FILTER_UPDATE

boolean

Supports Simple Filter Update

☑

Whether the provider supports update using simple filters.

TECHNICAL_DOCUMENTATION_URL

string(4000)

Technical Documentation (URL)

☐

Technical documentation URL.

TRY_ORDER

int32

Try Order

☑

Ascending order in which providers are tried.