This attribute group contains attributes that are related to the database operations, which are performed by the Archiving Service.This attribute group is not available in Lync Server 2013.
Historical group
This attribute group is eligible for use with Tivoli Data Warehouse.
Attribute descriptions
The following list contains information about each attribute in the Archiving Service DB Operations attribute group:
Node attribute: This attribute is a key attribute.
Description
The managed system name of the agent.
Type
String Source
The source for this attribute is the agent.
Warehouse name NODE Timestamp attribute
Description
The local time at the agent when the data was collected.
Type
String Source
The source for this attribute is the agent.
Warehouse name TIMESTAMP Queue Latency attribute
Description
The average time (in milliseconds) for which a request remains in the database queue.
Type
Real number (64-bit gauge) with two decimal places of precision with
enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Queue_Latency.
Warehouse name
QUEUE_LATENCY or ARCH_SERV0 Sproc Latency attribute
Description
The average time (in milliseconds) that is taken to run a stored procedure (SPROC) call.
Type
Real number (64-bit gauge) with two decimal places of precision with
enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Sproc_Latency.
Warehouse name
SPROC_LATENCY or ARCH_SERV1 Dropped Requests attribute
Description
The current number of requests that have been dropped by the database because the requests have timed out.
Type
Integer (64-bit gauge) with enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Dropped_Requests.
Warehouse name
DROPPED_REQUESTS or ARCH_SERV8 Deadlock Failures attribute
Description
The current number of deadlock failures that have occurred.
Type
Integer (64-bit gauge) with enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Deadlock_Failures.
Warehouse name
DEADLOCK_FAILURES or ARCH_SERV9 Severe SQL Errors attribute
Description
The current number of severe SQL errors that have occurred.
Type
Integer (64-bit gauge) with enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Severe_SQL_Errors.
Warehouse name
SEVERE_SQL_ERRORS or ARCH_SER12 Fatal SQL Errors attribute
Description
The current number of fatal SQL errors that have occurred.
Type
Integer (64-bit gauge) with enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Fatal_SQL_Errors.
Warehouse name
FATAL_SQL_ERRORS or ARCH_SER13 Throttled Requests (Per Sec) attribute
Description
The number of requests that are currently rejected by the server per second due to high database queue latency.
Type
Real number (64-bit gauge) with two decimal places of precision with
enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Throttled_Requests_Per_Sec.
Warehouse name
THROTTLED_REQUESTS_PER_SEC or ARCH_SER14 Throttled Requests attribute
Description
The current number of requests that have been rejected by the server due to high database queue latency.
Type
Integer (64-bit gauge) with enumerated values. The strings are displayed in the Tivoli Enterprise Portal. The warehouse and queries return the values that are shown in parentheses. The following values are defined:
v Value Exceeds Maximum (9223372036854775807) v Value Exceeds Minimum (-9223372036854775808)
Any other value is the value that is returned by the agent in the Tivoli Enterprise Portal.
Source
The source for this attribute is Filtered data - Throttled_Requests.
Warehouse name
THROTTLED_REQUESTS or ARCH_SER15