Monitoring Agent for Microsoft SQL Server metrics

The metrics for Monitoring Agent for Microsoft SQL Server resource types collect data for monitoring with IBM Cloud Pak for Multicloud Management. Every Monitoring Agent for Microsoft SQL Server resource type defines a set of dimensions and metrics. The descriptions provide such information as data type, dimension key, and metric unit.

Resource msSqlDatabase

Shows monitoring metrics for set of databases present on MSSQL Server Instance. The following section lists the metrics, dimensions and components of Resource msSqlDatabase.

Metrics

The following metrics are available for the resource.

Active Transactions

The number of active transactions for the database.
The type is int.
The unit is transactions.

Aggregate Database Freespace (MB)

The total amount of freespace (in MB) that is available in all the data files and on the storage device. The value format is a decimal number with two decimal places allowed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Aggregate Database Freespace Pct

The percentage of the total amount of freespace that is available in all the data files and on the storage device out of the total space allowed. The value format is a decimal number with two decimal places allowed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Data Files Freespace (MB)

The amount of freespace (in MB) that is available in all the data files. The value format is a decimal number with two decimal places allowed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Data Freespace (MB)

The number of megabytes (MB) of free space for the database. The value includes the megabytes of free data only. The value does not include the free space available in the database. The value format is a decimal number with two decimal places allowed; for example, 10.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Data Freespace Percent

The percentage of maximum available free space for the database. The value format is a percentage with two decimal places allowed; for example, 20.00. The product calculates this percentage from the maximum available free space for the database and the amount of space already allocated for the database. Consider using the alter database command to expand the database size. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Data Size (MB)

The number of megabytes (MB) allocated for the data only segments of the database. The value format is a decimal number with two decimal places allowed; for example, 50.00.
The type is double.
The unit is megabytes.

Database Growth Percent

The percentage of growth for the database from the last sample to the current sample.
The type is double.
The unit is percent.

Database Max Growth Size(MB)

The maximum size to which the database can grow in MB. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Database Space Pct Used

The amount of aggregate space (in megabytes) used in the database as a percentage of total space allowed. Use this attribute to warn you when you need to extend the database. If you run out of space, you can no longer use the database.
The type is double.
The unit is percent.

Last Database Size(MB)

The database size in MB from the previous sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Log Bytes Flushed Per Sec

The number of bytes of the log file that are flushed in the current interval. When the value of flushed bytes of the log file collected by the agent in the last interval is greater than or equal to the value of flushed bytes of the log file collected in the current interval, then 0 (zero) is displayed as the attribute value on the console. When the value of flushed bytes of the log file collected in the last interval is less than the value of flushed bytes of the log file collected in the current interval, then the value is calculated as follows: The value of flushed bytes of the log file collected in the last interval is subtracted from the value of flushed bytes of the log file collected in the current interval, and the value after subtraction is divided by the time interval between these two collections. When the value of flushed bytes of the log file collected in the last or the current interval, is negative, then Not_Collected is displayed on the console. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Log Freespace (MB)

The number of megabytes (MB) of free space in the transaction log for the database. The value includes the number of megabytes of free space on the log only partitions. The value format is a decimal number with two decimal places, for example, 8. 00. Various types of transactions, such as mass updates and bulk copying can involve extensive logging. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Log Freespace Percent

The percentage of free space in the transaction log for the database. The value format is a percentage with two decimal places, for example, 20.00. Various types of transactions, such as mass updates and bulk copying in, can involve extensive logging. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Log Growths

The total number of times the database transaction log is expanded since the SQL Server was started. The format is an integer.
The type is int.
The unit is expands.

Log Max Growth Size(MB)

The maximum size to which the log can grow in MB. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Log Size (MB)

The number of megabytes (MB) allocated for the transaction log for the database. The value includes the number of megabytes allocated for the transaction log on the log only partitions. The value format is a decimal number with two decimal places allowed; for example, 500. The appropriate size for a transaction log depends on how the database is used. Several factors, such as the number of transactions, type of transactions, and number of users, effect sizing. Evaluate the need to truncate the transaction log to prevent it from filling up.
The type is double.
The unit is megabytes.

Log Space Pct Used

The percentage of the transaction log that is full. When the log has filled up all of its allocated space, transactions that require logging are rejected. Use this attribute to set an alert based on a percent full threshold, then spawn a task to dump or truncate the transaction log or to do both.
The type is double.
The unit is percent.

Long Running Transaction Name

The long running transaction name.
The type is string.
The unit is transaction.

Long Running Transaction Process ID

The longest running transaction. The Long running transactions are transactions that are open for longer than the LongRunningTransColl standard collector parameter. The format is an integer.
The type is int.
The unit is process_id.

Long Running Transaction Time (Sec.)

The time for which the longest running transaction is active (in seconds). The format is an integer.
The type is int.
The unit is seconds.

Oldest Open Transaction(min)

The age (in minutes) of the oldest open transaction in the database transaction log. Use this attribute to determine up to which point in time the transaction log can be truncated and backed up. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minutes.

Replicated Transaction Rate

The rate per second at which transactions have been read out of the publication database transaction log and delivered to the distribution database. Use this attribute to discover if there are any bottlenecks in the replication process. Bottlenecks cause delays in the published transactions reaching the subscriber database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is operations/second.

Replicated Transactions

The number of transactions in the publication database transaction log that are marked for replication but have not yet been delivered to the distribution database. Use this attribute to discover if there are any bottlenecks in the replication process. Bottlenecks cause delays in the published transactions reaching the subscriber database.
The type is int.
The unit is transactions.

Replication Latency (ms)

The number of milliseconds between the time a transaction marked for replication is entered into the publication database transaction log and the time it is read out of the log and delivered to the distribution database. Use this attribute to discover if there are any bottlenecks in the replication process. Bottlenecks cause delays in the published transactions reaching the subscriber database.
The type is int.
The unit is milliseconds.

Table Count

The number of tables that exist in the database. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is tables.

Transactions per Sec.

The number of transactions started for the database per second for the current interval. When the number of transactions collected by the agent in the last interval is greater than or equal to the number of transactions collected in the current interval, then 0 (zero) is displayed as the attribute value on the console. When the number of transactions collected in the last interval is less than the number of transactions collected in the current interval, then the value is calculated as follows: The number of transactions collected in the last interval is subtracted from the number of transactions collected in the current interval, and the value after subtraction is divided by the time interval between these two collections. When the value of transactions collected in the last or the current interval, is negative, then Not_Collected is displayed on the console.
The type is double.
The unit is transactions/second.

Write Transactions per sec

The number of transactions written to the database and committed in the last second. The format is an integer. When the number of written transactions collected by the agent in the last interval is greater than or equal to the number of written transactions collected in the current interval, then 0 (zero) is displayed as the attribute value on the console. When the number of written transactions collected in the last interval is less than the number of written transactions collected in the current interval, then the value is calculated as follows: The number of written transactions collected in the last interval is subtracted from the number of written transactions collected in the current interval, and the value after subtraction is divided by the time interval between these two collections. When the value of written transactions, which are collected in the last or the current interval, is negative, then Not_Collected is displayed on the console.
The type is double.
The unit is transactions/second.

Dimensions

The following dimensions are available for the resource.

Accessible

Access validation of the database. When the database is in offline, restoring, or transition state, the value of this attribute is displayed as No.
The type is int.

Data File Names

The names of all physical files for data that make up this database.
The type is string.

Database Mirroring Role

Indicates whether the database is mirror or principal, or if mirroring is not applied. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Database Name

The name of the database. The value format is an alphanumeric string with a maximum of 30 characters; for example, KOQ3. Each database name is unique. The SQL server also assigns each database its own identification number.
The type is string.

Database Name (Unicode)

The name of the database. Each database name is unique. The SQL server also assigns each database its own identification number.
The type is string.

Database State

Reports the database state.
The type is string.

Database Status

Reports when the database is unavailable. If a database is offline, you cannot access it. Use this attribute to warn that the database has become unavailable. When the database is in transition state, the database status is displayed as Available.
The type is int.

DB ID

The ID for the database. The value format is an alphanumeric string with a maximum of 12 characters; for example, 2156. This value is stored in the sysdatabases table.
The type is string.

DB Owner

The SQL server-assigned user ID for the owner of the database. The value format is an alphanumeric string with a maximum of 8 characters; for example, DBO. Use the create database command to establish this identifier. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

DB Owner (Unicode)

The SQL server-assigned user ID for the owner of the database. Use the create database command to establish this identifier.
The type is string.

DBO Only Access

Indicates whether the database has a status of DBO only.
The type is string.

Dump Tran Date

The timestamp that indicates the date on which the dump transaction command was last executed for the database. The dump transaction command copies the uncommitted transactions in the transaction log. Refer to this date to determine when the latest backup of the transaction log was made. This attribute value may not be available for the SQL Server to capture. The format is YYYYMMDD, where, YYYY indicates year, MM indicates month, and DD indicates day. For example, 20020501 indicates May 1, 2002. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Error Status

Indicates whether the database has an error status. A database with an error status has a status of suspect, crashed, or recovery. Check the status bits in the sysdatabases table to determine the cause of the error. Use the database consistency checker (dbcc) to verify the database integrity.
The type is string.

Free Space Accounting Suppresed

Indicates whether the free space accounting option is disabled for the database. The no-free-space-actg option turns off free space accounting on non-log segments only. Information about free space is inaccurate when free space accounting is turned off. Use the no-free-space-actg option and the checkpoint command to speed recovery. No time is needed to count free space for non-log segments.
The type is string.

Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection.
The type is string.

Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Log File Names

The names of all physical files for logs that make up this database.
The type is string.

No CKPT After Recovery

Indicates whether a record for the checkpoint is added to the transaction log when the database is recovered. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Page Verify

The option that identifies and notifies incomplete I/O transactions that have occurred because of disk I/O errors.
The type is int.

Read Only Access

Indicates whether the database has a status of read only.
The type is string.

Recovery Model

The method used to maintain the transaction log. The three types of recovery models include Simple, Full, and Bulk-logged.
The type is int.

Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Select Into Bulkcopy Enabled

Indicates whether the select into/bulkcopy option is enabled for the database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters. For example, CFS_SVR5.
The type is string.

Single User Access

Indicates whether the database has a status of single user. A database with a status of single user can only be accessed by one user at a time.
The type is string.

Suspect Database

Reports whether a database is marked as suspect. Use this attribute to warn you that a database cannot be loaded. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Total Devices

The number of devices allocated for the database. The value format is an integer in the range 1-128; for example, 4.
The type is int.

Component: blockedSession

Information about the queries that are currently blocked on the SQL Server. The following section lists the metrics and dimensions of Component blockedSession.

Metrics

The following metrics are available for the component.

Blocked Session Total Wait Time (Sec.)

The total wait time (in seconds) since the query has been blocked on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Dimensions

The following dimensions are available for the component.

Blocked Database Query Text

The SQL text of the query that is currently blocked on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Database Session ID

The session ID that is blocking the query that is currently being run on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Blocked Database User Name (Unicode)

The name of the user who has run the blocked SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Database Name (Unicode)

The name of the database against which the blocked query is currently being run. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Blocked Session Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Parent Query Text

The SQL text of the parent of the blocking query. The value format is an alphanumeric string with a maximum of 2048 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Query Text

The SQL text of the query blocks one or more than one queries on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Reason

The reason for blocking the query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Resource

The resource for which the query is currently blocked on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Blocked Session Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Blocked Session Session ID

The ID of the session that is currently blocking the execution of a query on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Blocked Session User Name

The login name of the user who ran the blocking query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: customQuery

Information about the customized SQL queries that are defined in the properties file. The following section lists the metrics and dimensions of Component customQuery.

Metrics

The following metrics are available for the component.

Custom Query Integer Column Value 1

The value of the first column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is value.

Custom Query Integer Column Value 2

The value of the second column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is value.

Custom Query Integer Column Value 3

The value of the third column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is value.

Custom Query Integer Column Value 4

The value of the fourth column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is value.

Custom Query Integer Column Value 5

The value of the fifth column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is value.

Custom Query Last Execution Status

The status of the last execution of the SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is status.

Custom Query Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.
The unit is row.

Custom Query String Column Value 1

The value of the first column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.
The unit is value.

Custom Query String Column Value 2

The value of the second column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.
The unit is value.

Custom Query String Column Value 3

The value of the third column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.
The unit is value.

Custom Query String Column Value 4

The value of the fourth column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.
The unit is value.

Custom Query String Column Value 5

The value of the fifth column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.
The unit is value.

Custom Query Time Column Value 1

The value of the first column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.
The unit is value.

Custom Query Time Column Value 2

The value of the second column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.
The unit is value.

Custom Query Time Column Value 3

The value of the third column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.
The unit is value.

Custom Query Time Column Value 4

The value of the fourth column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.
The unit is value.

Dimensions

The following dimensions are available for the component.

Custom Query Definition File Last Modified Time

The date and time when the customized SQL queries definition file was last modified. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Custom Query Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Custom Query Integer Column Name 1

The name of the first column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Integer Column Name 2

The name of the second column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Integer Column Name 3

The name of the third column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Integer Column Name 4

The name of the fourth column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Integer Column Name 5

The name of the fifth column of integer data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Last Execution Error Message

The reason why the SQL query failed when it was last executed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Last Execution Time

The time when the SQL query was last executed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Custom Query More Columns

Indicates whether the number of columns in an SQL query result is more than five for the string and integer data types or more than four for the time data type. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Custom Query Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Result Hub Timestamp

The time when data is inserted at the hub. This is available for thresholds, but not in the UI.
The type is timestamp.

Custom Query Result Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Result Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Custom Query Result SQL ID

The customized SQL query ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query SQL Definition File

The location where the file that contains customized SQL queries is saved. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query SQL ID

The customized SQL query ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query String Column Name 1

The name of the first column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query String Column Name 2

The name of the second column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query String Column Name 3

The name of the third column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query String Column Name 4

The name of the fourth column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query String Column Name 5

The name of the fifth column of string data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Time Column Name 1

The name of the first column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Time Column Name 2

The name of the second column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Time Column Name 3

The name of the third column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custom Query Time Column Name 4

The name of the fourth column of time data type in an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custome Query Database Name

The maximum number of the availability databases that have been unsynchronized since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custome Query Result Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Custome Query Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

SQL Query

The content of the customized SQL query that is defined in the properties file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlDatabaseAdditional

The MS SQL Additional Database Details data set contains attributes that provide information about the database details for SQL Server 2012 Enterprise Edition, or later. This data set provides information about database details in addition to the MS SQL Database Details data set. The following section lists the dimensions of Component msSqlDatabaseAdditional.

Dimensions

The following dimensions are available for the component.

Additional Database Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Additional Database Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Additional Database ID

The database ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Additional Database Name

The name of the database. The value format is an alphanumeric string, for example, KOQ3. Each database name is unique. The SQL Server also assigns each database a unique identification number. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Additional Database Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Containment

Indicates whether containment is enabled for the database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Database Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Filestream Directory Name

The name of the filestream directory. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Non Transactional Access Level

The level of non-transactional access for the database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Origin Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Transaction Isolation Level of Memory Optimized Tables

Indicates whether the TRANSACTION ISOLATION LEVEL is set to SNAPSHOT. The SNAPSHOT isolation level is used to access the memory-optimized tables. The TRANSACTION ISOLATION LEVEL is set to a lower value, such as READ COMMITTED or READ UNCOMMITTED to access these tables. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Component: msSqlDevice

The MS SQL Device Detail attribute group contains attributes that you can use to monitor the usage and performance of devices. The data collection for this attribute group is limited to 10000 rows. The following section lists the metrics and dimensions of Component msSqlDevice.

Metrics

The following metrics are available for the component.

Device Autogrowth Value

Indicates the growth value of a file.
The type is int.
The unit is growth.

Device Free Space (MB)

The number of megabytes (MB) of free space on a device. The value format is a decimal with two decimal places allowed; for example, 10.00. Adequate space is required to support database and system administration activities. Set alerts for abnormal conditions. Refer to this value when estimating space needed for tables, indexes, logs, and system administration. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Device Free Space Percent

The percentage of free space on the device. The value format is a percentage with two decimal places allowed; for example, 15.00. Adequate space is required to support database and system administration activities. Set alerts for abnormal conditions. Refer to this value when estimating space needed for tables, indexes, logs, and system administration.
The type is double.
The unit is percent.

Device Size (MB)

The number of megabytes (MB) on the device. The value format is an integer; for example, 20. Use this value when analyzing the amount of free space.
The type is double.
The unit is megabytes.

Device Status

Indicates the status of a device.
The type is int.
The unit is status.

Dimensions

The following dimensions are available for the component.

Device Autogrowth

Indicates whether the autogrowth feature is enabled for a device. If the autogrowth feature is enabled, the maximum file size is displayed as restricted or unrestricted.
The type is int.

Device Autogrowth Unit

Indicates the unit of file growth. If the autogrowth feature is enabled for a device, the file growth value is displayed either in a percentage or MB.
The type is int.

Device Database Name

The name of the database. The value format is alphanumeric string with a maximum 30 characters; for example, KOQ3. Each database name is unique. The SQL server also assigns each database its own identification number. This is available for thresholds, but not in the UI.
The type is string.

Device Database Name (Unicode)

The Database name.
The type is string.

Device Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Device Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Device Mirror Device Name

The name of the mirror device for the database. The value format is an alphanumeric string with a maximum of 64 characters; for example, /dev/rsd2g . The mirror device duplicates the contents of a primary device. Refer to the logical and physical names of the device that is being mirrored.
The type is string.

Device Name

The name of the device allocated for the database. The value format is an alphanumeric string with a maximum of 64 characters; for example, DATA_1. The logical name of the device is stored in the name column of the sysdevices table. Use the device name in storage-management commands. This is available for thresholds, but not in the UI.
The type is string.

Device Name (Unicode)

The Device name.
The type is string.

Device Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Device Physical Device Name

The name of the physical device allocated for the database. The value format is an alphanumeric string with a maximum of 30 characters; for example, DATA_1.
The type is string.

Device Physical Device Name (Unicode)

The Name of the physical device. Valid values include text strings with a maximum of 192 bytes.
The type is string.

Device Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Device Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Device Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is available for thresholds, but not in the UI.
The type is string.

Device Server Version

The version of the SQL Server. The value format is the version in the format w. x. y. z; for example, 10. 0. 2531. 0. This is available for thresholds, but not in the UI.
The type is string.

Device Server Version (Superceded)

The version of the SQL Server. The value format is the version in the format x. y. z; for example, 10. 0. 253. For the complete version of the SQL Server, see the Server Version attribute. This is available for thresholds, but not in the UI.
The type is string.

Device Type

Indicates the type of device allocated for the database. The value indicates the type of data that is stored on the device. Databases are frequently spread across several devices due to size, performance, and recoverability issues.
The type is string.

Component: msSqlExpensiveQuery

The MS SQL Expensive Query Plan attribute group provides the top 10 cached query plans according to the performance statistics in the SQL server. The following section lists the metrics and dimensions of Component msSqlExpensiveQuery.

Metrics

The following metrics are available for the component.

Expensive Query Age in Minutes

The time interval (in minutes) between the last time that the query was executed and the time when the query was created. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minutes.

Expensive Query Average CPU Time(ms)

The average CPU time (in milliseconds) that is required to execute the plan since the plan was compiled.
The type is int.
The unit is milliseconds.

Expensive Query Average Duration(ms)

The average elapsed time (in milliseconds) that is required to execute this plan.
The type is int.
The unit is milliseconds.

Expensive Query Average Logical Reads

The average logical reads that are performed to execute this plan since the plan was compiled.
The type is int.
The unit is reads.

Expensive Query Average Logical Writes

The average logical writes that are performed to execute this plan since the plan was compiled.
The type is int.
The unit is writes.

Expensive Query Average Physical Reads

The average physical reads that are performed to execute this plan since the plan was compiled.
The type is int.
The unit is reads.

Expensive Query CPU Rate (percentage)

The value of CPU time in percentage (per interval) that is required to execute this plan since the last collection. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Expensive Query Execution rate

The value in percentage that is calculated by dividing the execution count by the value that is obtained after subtracting the creation time of the query from the last execution time of the query.
The type is double.
The unit is percent.

Expensive Query Executions Per Interval

The number of times that the query is executed in the sample interval. This is available for thresholds, but not in the UI.
The type is int.
The unit is executions/interval.

Expensive Query State

The state of the query that is based on the threshold (Normal/Critical).
The type is int.
The unit is state.

Expensive Query Total Elapsed Time(ms)

The total elapsed time (in milliseconds) that is required to execute this plan. This is available for thresholds, but not in the UI.
The type is int.
The unit is milliseconds.

Dimensions

The following dimensions are available for the component.

Expensive Query Database Name (Unicode)

The name of the database against which the query is executed.
The type is string.

Expensive Query Hub Timestamp

The time when this data is inserted in the hub. This is available for thresholds, but not in the UI.
The type is timestamp.

Expensive Query Node

The key to this table of the format 'serverid: hostname: MSS'.
The type is string.

Expensive Query Row Number

The row number in the sample. This is available for thresholds, but not in the UI.
The type is int.

Expensive Query Server Name

The name of the SQL server. This is available for thresholds, but not in the UI.
The type is string.

Expensive Query Sorting Criteria

The sorting criteria for top N expensive queries.
The type is int.

Expensive Query SQL Handle

The SQL handle of the SQL query that is executed on the SQL server.
The type is string.

Expensive Query Text (Unicode)

The SQL text of the expensive query plan.
The type is string.

Component: msSqlFileGroup

The MS SQL Filegroup Detail attribute group provides detail about the filegroups for each database in the SQL server instance. The data collection for this attribute group is limited to 10000 rows. The following section lists the metrics and dimensions of Component msSqlFileGroup.

Metrics

The following metrics are available for the component.

File Group Max Growth Size

The maximum amount of space (in MB) that the filegroup can grow to. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

File Group Size

The size of the filegroup in MB. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

File Group Space Pct Used

The amount of space (in MB) that is used in the filegroup as a percentage of total space allowed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Dimensions

The following dimensions are available for the component.

File Group Database Name (Unicode)

The name of the database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Group Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Group Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

File Group ID

The filegroup identification number. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

File Group Name

The name of the filegroup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Group Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Group Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

File Group Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Group Status

Indicates the status of a filegroup. If the status of a file in a filegroup is offline, the status of the filegroup is displayed as offline. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Component: msSqlIndividualQueries

The MS SQL Individual Queries Details data set contains attributes that provide information about each query in the query batch that is currently running on the SQL Server. The following section lists the metrics and dimensions of Component msSqlIndividualQueries.

Metrics

The following metrics are available for the component.

Individual Query Avg CPU Time (Sec.)

The average CPU time (in seconds) that is taken to run an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is seconds.

Individual Query Avg Logical Reads

The average number of logical read operations that are completed by an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is reads.

Individual Query Avg Logical Writes

The average number of logical write operations that are completed by an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is writes.

Individual Query Avg Physical Reads

The average number of physical read operations that are completed by an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is reads.

Individual Query Execution Count

The total number of times an SQL query has been run since the query was last compiled. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is executions.

Individual Query Max CLR Time(Sec.)

The maximum common language runtime (CLR, in seconds) that is used for a single execution of an SQL query inside the .NET framework CLR. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is seconds.

Individual Query Max CPU Time(Sec.)

The maximum CPU time (in seconds) that is used for a single execution of an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is seconds.

Individual Query Max logical Reads

The maximum number of logical read operations that are completed by a single execution of an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is reads.

Individual Query Max logical Writes

The maximum number of logical write operations that are completed by a single execution of an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is writes.

Individual Query Max Physical Reads

The maximum number of physical read operations that are completed by a single execution of an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is reads.

Individual Query Max Waiting Time(Sec.)

The maximum waiting time (in seconds) that is taken by a single execution of an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is seconds.

individual Query Total CPU Time (Sec.)

The total amount of CPU time (in seconds) that is used by all the executions of an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is seconds.

Individual Query Total Percent CPU Used

The percentage of the available CPU memory that is used for executing an SQL query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Individual Query Total Percent Waiting

The percentage of total wait operations that are completed when an SQL query is run. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Dimensions

The following dimensions are available for the component.

Individual Query Database Name (Unicode)

The name of the database against which the SQL query is running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Individual Query Hash

The query hash of an SQL query. The value format is an alphanumeric string with a maximum of 2048 characters. This attribute, with the Session ID attribute, is used to create the primary key. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Individual Query Hub Timestamp

The time when data is inserted at the hub. This is available for thresholds, but not in the UI.
The type is timestamp.

Individual Query Last Execution Time

The time when an SQL query was last run on the SQL Server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and SS indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL Server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Individual Query Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Individual Query Row Number

The row number in sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Individual Query Server Name

The name of the SQL Server. This is available for thresholds, but not in the UI.
The type is string.

Individual Query Session ID

The ID of the session in which the query is run. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Individual Query SQL Handle

The SQL handle of the query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Individual Query Text

The SQL text of a query in an SQL query batch. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlLock

The MS SQL Lock Detail data set contains attributes that you can use to monitor detailed information about lock contention by lock type. The following section lists the metrics and dimensions of Component msSqlLock.

Metrics

The following metrics are available for the component.

Lock Page Number

The page number of the table being locked. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is page.

Lock Request Status

Enumeration that identifies the Lock Request Status. The format is an integer.
The type is int.
The unit is status.

Lock Table Name

The name of the table being locked. The value format is an alphanumeric string with a maximum of 16 characters.
The type is string.
The unit is table.

Dimensions

The following dimensions are available for the component.

Lock Database Id

The ID of the database that is locked. The value format is an integer.
The type is int.

Lock Database Name

The name of the database that is locked. The value format is an alphanumeric string with a maximum of 16 characters; for example, DB12. This is available for thresholds, but not in the UI.
The type is string.

Lock Database Name (Unicode)

The name of the locked database.
The type is string.

Lock Detail Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Lock Detail Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Lock Detail Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Lock Detail Resource Type

Enumeration that identifies the Lock Resource Type. The format is an integer.
The type is int.

Lock Detail Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Lock Detail Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Lock Detail Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example CFS_SVR5. This is available for thresholds, but not in the UI.
The type is string.

Lock Process Holding Lock

The ID of the process holding the lock. The value format is an integer.
The type is int.

Lock Table Name (Unicode)

Name of Table being locked. This is available for thresholds, but not in the UI.
The type is string.

Lock Type

Indicates the type of lock on the resource that is being requested.
The type is string.

Component: msSqlRunningQueries

The MS SQL Running Queries Details data set contains attributes that provide information about the queries that are currently running on the SQL Server. The following section lists the metrics and dimensions of Component msSqlRunningQueries.

Metrics

The following metrics are available for the component.

Running Queries CPU Time (Sec.)

The CPU time (in seconds) of the SQL query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Running Queries Percent Work Complete

The percentage of completed work for the database command that is currently running. The name of the command that is currently running is displayed in the Command Type attribute. The following list displays the database commands:
- ALTER INDEX REORGANIZE
- AUTO_SHRINK option with ALTER DATABASE
- BACKUP DATABASE
- DBCC CHECKDB
- DBCC CHECKFILEGROUP
- DBCC CHECKTABLE
- DBCC INDEXDEFRAG
- DBCC SHRINKDATABASE
- DBCC SHRINKFILE
- RECOVERY
- RESTORE DATABASE
- ROLLBACK
- TDE ENCRYPTION
. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Running Queries Query Reads

The number of query read operations completed by the SQL query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is reads.

Running Queries Row Count

The number of rows returned to the client by the SQL query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Running Queries Total Elaplsed Time (Sec.)

The total time (in seconds) that has elapsed since the SQL query arrived on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Dimensions

The following dimensions are available for the component.

Running Queires Program Name

The name of the client program that initiated the request, which is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Queries Blocking Session ID

The ID of the session that is currently blocking the execution of a query on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Running Queries Client Host Name

The name of the client workstation that is associated with the SQL query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Queries Command Type

The type of command that is currently being processed by the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Queries Database Name (Unicode)

The name of the database against which the SQL query is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Queries Granted Query Memory

The number of pages that are currently allocated to the execution of a query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Running Queries Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

The name that is used to log on to the SQL Server on which the query is currently running. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Queries Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Queries Query Start Time

The time when the query arrived on the SQL Server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and SS indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL Server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Running Queries Query Status

The status of the SQL query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Running Queries Query Writes

The number of query write operations completed by the SQL query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Running Queries Row Number

The row number in sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Running Queries Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Queries Session ID

The session ID of the query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Running Queries SQL Handle

The SQL handle of the query that is currently running on the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Running Query Text

The SQL text of the query that is currently running on the SQL Server. The value format is an alphanumeric string with a maximum of 2048 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlTable

The MS SQL Table Detail data set contains attribute that you can use to monitor tables within one or more database. The data collection for this data set is limited to 10000 rows. The following section lists the metrics and dimensions of Component msSqlTable.

Metrics

The following metrics are available for the component.

Table Fragmentation

The degree of fragmentation for the table. Use this attribute to determine if fragmentation is reaching a level that causes performance degradation. Performance degradation is due to non-contiguous table reads that require additional extent switches. The format is an integer.
The type is int.
The unit is degreeOfFragmentation.

Table Number Of Rows

The number of rows that are present in a database table. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Table Optimizer Statistics Age (in Min.)

The time (in minutes) since statistics were last updated for the table. Use this attribute to ensure that queries base their query plans on up-to-date information. If query plans are based on old information, they might be inefficient. The value for this attribute is displayed as 0 (zero) when the time since statistics was last updated for the table is less than 1 minute and is displayed as Not Collected when the statistics for the table was never updated. The format is an integer.
The type is int.
The unit is minute.

Table Space Used (MB)

The amount of space (in megabytes) used by the specified table. Use this attribute to determine how much of the database space is used by a table. You can monitor the growth of individual tables and compare the actual growth to the expected growth. The format is an integer.
The type is double.
The unit is megabytes.

Dimensions

The following dimensions are available for the component.

Table Database Id

ID number of this database. The format is an integer.
The type is int.

Table Database Name

The Database name. The value format is an alphanumeric string with a maximum of 30 characters.
The type is string.

Table Detail Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Table Detail Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Table Detail Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Table Detail Server Name

The name of the SQL Server. The value format is an alphanumeric string with a maximum of 32 characters. This is available for thresholds, but not in the UI.
The type is string.

Table Durability

A numeric value that indicates whether the table is durable. This is available for thresholds, but not in the UI.
The type is int.

Table FileTable

Indicates whether the current table is a FileTable. The format is an integer.
The type is int.

Table Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Table Id

ID number of this table. The format is an integer.
The type is int.

Table Index Id

The ID number of this table index.
The type is int.

Table Index Name

The table index name.
The type is string.

Table Memory Optimized

A numeric value that indicates whether the table is optimized for memory. This is available for thresholds, but not in the UI.
The type is int.

Table Name

The table name. The value format is an alphanumeric string with a maximum of 30 characters.
The type is string.

Table Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and SS indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Component: msSqlText

The MS SQL Text data set contains attributes that you can use to monitor information about SQL text strings associated with a selected process. For custom queries, this data set displays data only for the specified available process ID. The following section lists the metrics and dimensions of Component msSqlText.

Metrics

The following metrics are available for the component.

Text Total CPU Time (Sec.)

The amount of CPU time, in seconds, the process has used on the host since the process started. The value format is an integer; for example, 60. This value is based on the statistics collected by the SQL server. Use this value to check for processes that use abnormal amounts of CPU time. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is seconds.

Dimensions

The following dimensions are available for the component.

Text

The SQL text for the process. The value format is an alphanumeric string with a maximum of 255 characters. This is available for thresholds, but not in the UI.
The type is string.

Text (Unicode)

The SQL text for the process. This is available for thresholds, but not in the UI.
The type is string.

Text Client Host Name

The host name of the client where the command was issued. The value format is an alphanumeric string with a maximum of 16 characters. This is available for thresholds, but not in the UI.
The type is string.

Text Client Process ID

The process ID assigned by the host client. The value format is an alphanumeric string with a maximum of 16 characters. This is available for thresholds, but not in the UI.
The type is string.

Text Database Name

The name of the database. The value format is an alphanumeric string with a maximum of 30 characters; for example, KOQ3. Each database name is unique. The SQL server also assigns each database its own identification number. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Text Database Name (Unicode)

The Database name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Text Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Text Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Text Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Text Process ID

The ID of the process that is requesting or holding the lock on the resource. The value format is an alphanumeric string with a maximum of 10 characters; for example, 42168. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Text Process Status

Indicates the status of the process. This is available for thresholds, but not in the UI.
The type is string.

Text Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Text Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Text Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is available for thresholds, but not in the UI.
The type is string.

Resource msSqlInstance

Shows performance data and overall status of the MSSQL Server Instances. The following section lists the metrics, dimensions and components of Resource msSqlInstance.

Metrics

The following metrics are available for the resource.

Cache Average Free Scan

The average number of buffers scanned by the LazyWriter when the LazyWriter searches the data cache for an unused buffer to replenish the free buffer pool. If Microsoft SQL Server must read a large number of buffers to find a free one, server performance might degrade. A low value indicates optimal performance. The value format is an integer.
The type is int.
The unit is buffers.

Cache Free Buffers

The current number of cache buffers in the free buffer pool. Use this attribute as an alert when the number of buffers is getting low. A low number of free buffers might degrade server performance. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is buffers.

Cache Hit Ratio

The current ratio of data cache hits to total requests. Use this attribute to check the effectiveness of the data cache. For optimal performance, the returned value must be approximately 90% or greater. The value format is an integer.
The type is double.
The unit is hits/request.

Cache Maximum Free Page Scan

The maximum value for the number of buffers scanned by the LazyWriter when the LazyWriter searches the data cache for an unused buffer to replenish the free buffer pool. Use this attribute to check the effectiveness of the data cache. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is buffers.

Checkpoint Pages per Sec

The number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is pages/second.

Collection Status

Indicates the status of the data collector on a remote node.
The type is string.
The unit is status.

CPU Idle Delta

The difference in the CPU Idle between the current and the previous samples. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is difference.

CPU Idle Sec

The time (in seconds) that the SQL Server has been idle since it was last started. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

CPU Pct Idle

The percentage of time that a database server has been idle during the current monitoring interval. Use this attribute to gauge how much of the CPU resource the database server uses so that you can allocate resources more efficiently. Also, you can use this attribute to determine how resource-intensive certain operations are. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

CPU Usage Delta

The difference in the CPU Usage between the current and the previous samples. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is difference.

CPU Usage Sec

The time (in seconds) that the CPU has spent working since the SQL Server was last started. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Current Interval (Sec.)

The number of seconds that have elapsed between the previous sample and the current sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Data Cache Size (KB)

The number of kilobytes (KB) allocated for the data cache memory. The SQL server uses the data cache to store data and index pages. The value format is an integer; for example, 1000. The cache is sometimes referred to as the buffer cache. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Lazy Writes per Sec

The number of buffers written per second by the buffer manager lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers and make them available to user processes. The lazy writer eliminates the need to perform frequent checkpoints to create available buffers. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is writes/second.

Mixed Page Allocations Per Sec

The number of pages that are allocated from mixed extents per second. These pages can be used for storing the Index Allocation Map (IAM) pages. The first eight pages from mixed extents are allocated to an allocation unit. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is pages/second.

Page Life Expectancy

The duration (in seconds) for which an SQL Server block or page is stored in the memory.
The type is int.
The unit is seconds.

Page Reads per Sec

The number of physical database page reads that are issued per second. This statistic displays the total number of physical page reads across all databases. Because physical IO is expensive, you might be able to minimize the cost, either by using a larger data cache, intelligent indexes, and more efficient queries, or by changing the database design. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is reads/second.

Page Splits per Sec

The number of page splits that occur per second because the space in an index page is insufficient. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is pages/second.

Page Writes per Sec

The number of physical database page writes issued. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is writes/second.

Pct Max Locks

The percentage of locks on resources of the maximum number of locks allowed by the SQL server. The value format is a percentage with two decimal places allowed; for example, 10.00. Setting a higher limit for the maximum number of locks does not impair performance. If your operations exceed the number of available locks, you can increase this limit.
The type is double.
The unit is percent.

Plan Cache Hit Ratio

The ratio between the cache hits and the cache lookups. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is hits/lookups.

Procedure Cache Size (KB)

The number of kilobytes (KB) allocated for the procedure cache. The SQL server uses the procedure cache to compile queries and store procedures that are compiled. The value format is an integer; for example, 1000. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Readahead Pages per Sec

The number of pages read in anticipation of use. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is pages/second.

Repl Dist Delivered Cmds per Sec

The number of distribution commands delivered per second to the Subscriber. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is commands/second.

Repl Dist Delivered Trans per Sec

The number of distribution transactions delivered per second to the Subscriber. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is transactions/second.

Repl Dist Delivery Latency

The distribution latency (in MS), the time it takes for transactions to be delivered to the Distributor and applied at the Subscriber. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is milliseconds.

Repl Logreader Delivered Cmds per Sec

The number of Log Reader Agent commands delivered per second to the Distributor. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is commands/second.

Repl Logreader Delivered Trans per Sec

The number of Log Reader Agent transactions delivered per second to the Distributor. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is transactions/second.

Repl Logreader Delivery Latency

The current amount of time (in MS) elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is milliseconds.

Repl Merge Conflicts per Sec

The number of conflicts per second that occurred in the Publisher or Subscriber upload and download. If the value is not zero, the value might require notifying the losing side, overriding the conflict, and so on. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is conflicts/second.

Repl Merge Downloaded Changes per Sec

The number of rows merged (inserted, updated, and deleted) per second from the Publisher to the Subscriber. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Repl Merge Uploaded Changes per Sec

The number of rows merged (inserted, updated, and deleted) per second from the Subscriber to the Publisher. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server CPU Pct IO

The percentage of time used for I/O operations during the current monitoring interval. Use this attribute to gauge how much of the CPU resource the database server uses for I/O so you can allocate resources more efficiently. You also can use this attribute to determine how I/O resource-intensive certain operations are. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Server CPU Percent

The percentage of CPU time the SQL server process is using on the host. The value format is a percentage with two decimal places allowed; for example, 20.00.
The type is double.
The unit is percent.

Server Status

Indicates the status of the SQL server. The server status is displayed as Unknown when the collector process of the SQL Server agent is not running. The server status is displayed as Inactive when the collector process of the SQL Server agent is running, but the SQL Server is not responding to the request.
The type is string.
The unit is status.

SQLServerAgent Failed Jobs

Reports any jobs run by the SQLServerAgent service that have failed in the last monitoring interval. The first time you retrieve this attribute, it returns 0. The next time you retrieve it, it returns the total number of SQLServerAgent failed jobs found in the system history tables since the first run. These jobs include replication and user-defined jobs, such as maintenance or backup tasks. Use this attribute to alert you when scheduled tasks have failed. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is jobs.

Stolen Pages

The number of pages used for miscellaneous server purposes. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is pages.

Stolen Pages Growth

The growth of the number of stolen pages between the current sample and previous sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is pages.

Time Since Startup (Min.)

The number of minutes that have elapsed since the SQL server was started. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minutes.

Total Blocking Lock Requests

The total number of current locks blocking other processes.
The type is int.
The unit is requests.

Total Locks Remaining

The total number of locks that can still be taken out. The maximum number of locks is configurable. In Microsoft SQL Server Version 8. 0, you can have the number of locks configured automatically. Use this attribute to show the number of locks active during server activity. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is locks.

Total OS CPU Percent

The percentage of CPU time being used by all processes on the host. The value format is a percentage with two decimal places allowed; for example, 40. 00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Total Pages

The total number of stolen, free, and database pages in the buffer pool. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is pages.

Total Server Memory (KB)

The total amount of dynamic memory (in KB) that the server is using currently. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Dimensions

The following dimensions are available for the resource.

Fully Qualified Domain Name

The fully qualified DNS name that uniquely identifies the local computer. If the local computer is a node in a cluster, it provides the fully qualified DNS name of the cluster virtual server.
The type is string.

Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection.
The type is string.

Properties Collation

The name of the default collation for the server. The value format is a string.
The type is string.

Properties Collation ID

The identification number of this SQL Server collation.
The type is int.

Properties Database Engine Edition

The database engine edition of the instance of the SQL Server that is currently installed. The value format is an integer.
The type is int.

Properties Edition ID

The identification number that represents the installed product edition of this instance of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Properties Filestream Level

The current level of FileStream support that is enabled for the SQL Server instance.
The type is int.

The Windows share name where the FileStream data is stored. The value format is an alphanumeric string.
The type is string.

Properties HADR Manager Status

Indicates whether the HADR manager for the AlwaysOn availability group has started. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Properties Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is available for thresholds, but not in the UI.
The type is timestamp.

Properties Instance Path

Path of the sql server instance. Indicates the path of the SQL Server instance.
The type is string.

Properties Instance Port

Indicates the port of the SQL Server instance.
The type is int.

Properties Is Clustered

Indicates whether the SQL Server instance is configured in the Windows Server Failover Clustering (WSFC) cluster. The value format is an integer.
The type is int.

Properties Is HADR Enabled

Indicates whether the AlwaysOn Availability Group feature is enabled on the SQL Server instance. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Properties Is Single User

The server is currently in the single-user mode, in which only a single user can connect to the server. The value format is an integer.
The type is int.

Properties IsIntegrated Security Only

The server is in the integrated security mode. The value format is an integer.
The type is int.

Properties License Type

The mode of this instance of the SQL Server. The mode can be per-seat or per-processor.
The type is string.

Properties Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries.
The type is string.

Properties Num Licenses

The number of client licenses that are currently registered for this instance of the SQL Server if the SQL Server is in the per-seat mode. The number of processors that are currently licensed for this instance of the SQL Server if the SQL Server is in the per-processor mode.
The type is int.

Properties Physical NetBIOS Name

The NetBIOS name of the machine where this instance of the SQL Server is currently running.
The type is string.

Properties Product Edition

The installed product edition of this instance of the SQL Server.
The type is string.

Properties Product Level

The level of the version of this instance of the SQL Server, for example, the original release version and the service pack version.
The type is int.

Properties Qualified Server Name

The name of the qualified SQL Server instance in the format hostname:SQL server instance. For the default SQL Server instance, the format is hostname. The value format is an alphanumeric string with a maximum of 128 characters.
The type is string.

Properties Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters.
The type is string.

Properties Server Version

The version of the SQL Server. The value format is the version in the format w. x. y. z; for example, 10. 0. 2531. 0. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. This is available for thresholds, but not in the UI.
The type is timestamp.

Server Description

The attribute name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Type

The type of SQL server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Version

The version of the SQL Server. The value format is the version in the format w. x. y. z; for example, 10. 0. 2531. 0.
The type is string.

Value

The attribute value. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: auditEvents

Information about the availability databases that are hosted by the SQL Server instance. The following section lists the dimensions of Component auditEvents.

Dimensions

The following dimensions are available for the component.

Audit Events Action ID

The ID of the audit action. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Audit Action Name

The name of the audit action. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Audit Database Name

The database context in which the action occurred. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Audit Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Audit Events Audit Name

The name of the audit. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Audit Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Audit Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Audit Events Audit Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Audit Specification Name

The name of the audit specification. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Audit Specification Type

The type of the audit specification. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Class Type

The type of the entity that is being audited. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Database Principal Name

The name of the owner of the audit that is registered on the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Event Time

The local date and time when the audit action is triggered. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Audit Events File Name

The name and location of the audit log file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Object Name

The name of the entity on which the audit action occurred. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Schema Name

The schema context in which the audit action occurred. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Server Principal Name

The current login to the SQL Server where the audit action occurred. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Statement

The Transact-SQL statement that is specified by the user. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Audit Events Succeeded

Indicates whether the audit action succeeded. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Audit Events User Defined Event ID

The event ID that is specified by the user. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Audit Events User Defined Information

Additional information that the user wants to record in the audit log file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: availabilityGroup

Information about the availability databases that are hosted by the SQL Server instance. The following section lists the metrics and dimensions of Component availabilityGroup.

Metrics

The following metrics are available for the component.

Availability Group Bytes Received Per Sec

The number of bytes that are currently being received from the availability replica per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Availability Group Bytes Sent To Transport Per Sec

The number of bytes that are currently being sent per second through the network from the primary replica to the secondary replica, or from the secondary replica to the primary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Availability Group Cluster Wait Timeout (ms)

The duration (in milliseconds) that the system waits for the sp_server_diagnostics stored procedure to return the health information of the SQL Server instance before the server instance is assumed to be slow or not responding. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is milliseconds.

Availability Group Database Count

The total number of databases that are connected to the availability group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group File Bytes Received Per Sec

The amount of filestream data that is currently being received per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Availability Group Filestream Send Rate (KB Per Sec)

The rate (in KB per second) at which filestream data is sent to the secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes/second.

Availability Group Flow Control Per Sec

The number of flow control operations that have been currently initiated per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is operations/second.

Availability Group Flow Control Time (ms)

The time (in milliseconds) that the log stream messages waited to send the flow control information to the availability database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is milliseconds.

Availability Group Log Bytes Received Per Sec

The amount of log bytes that is currently being received per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Availability Group Log Bytes Sent Rate (KB Per Sec)

The rate (in KB per second) at which log records are currently being sent to the secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes/second.

Availability Group Log Send Queue (KB)

The amount of log bytes (in KB) that has been sent by the primary replica, but has not been received by the secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes.

Availability Group Log Send Queue Size (KB)

The amount of log bytes (in KB) in the log files of the primary database that has not been sent to the secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Availability Group Max Disconnected Replicas Summary

The maximum number of replicas that have been disconnected since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Max Local Failed Replicas Summary

The maximum number of local replicas that have failed since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Max Non Healthy Databases

The maximum number of the availability databases that have been non-healthy since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Max Non Healthy Groups

The maximum number of availability groups in which at least one availability replica that is hosted by the SQL Server instance has not been healthy since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Max Non Healthy Replicas Summary

The maximum number of replicas that have not been healthy since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Max Non Online Local Replica Groups

The maximum number of availability groups in which at least one availability replica that is hosted by the SQL Server instance has not been online since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Max Non-Online Databases

The maximum number of databases that have not been online since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Max Secondary Replicas Summary

The maximum number of secondary replicas that have been connected since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Max Unsynchronized Commit DB Replicas

The maximum number of availability database replicas on which the transaction commit operation has not been synchronized since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Max Unsynchronized Databases

The maximum number of the availability databases that have been unsynchronized since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Messages Sent To Transport Per Sec

The number of AlwaysOn messages that are currently being sent per second through the network from the primary replica to the secondary replica, or from the secondary replica to the primary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Availability Group Min Disconnected Replicas Summary

The minimum number of replicas that have been disconnected since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Min Local Failed Replicas Summary

The minimum number of local replicas that have failed since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Min Non Healthy Databases

The minimum number of the availability databases that have been non-healthy since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Min Non Healthy Groups

The minimum number of availability groups in which at least one availability replica that is hosted by the SQL Server instance has not been healthy since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Min Non Healthy Replicas Summary

The minimum number of replicas that have not been healthy since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Min Non Online Local Replica Groups

The minimum number of availability groups in which at least one availability replica that is hosted by the SQL Server instance has not been online since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Min Non-Online Databases

The minimum number of databases that have not been online since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Min Secondary Replicas Summary

The minimum number of secondary replicas that have been connected since the agent startup in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Min Unsynchronized Commit DB Replicas

The minimum number of availability database replicas on which the transaction commit operation has not been synchronized since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Min Unsynchronized Databases

The minimum number of the availability databases that have been unsynchronized since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Mirrored Write Transaction Per Sec

The number of transactions that have been written to the mirrored database in the last second, and are waiting for the logs to be sent to the mirrored database to complete the commit operation. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is transactions/second.

Availability Group Received Messages Per Sec

The number of AlwaysOn messages that are currently being received from the primary replica per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Availability Group Recovery Queue

The number of log records that are in the recovery queue because they are not redone. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is records.

Availability Group Redo Blocked Per Sec

The number of times that the redo operation is currently being blocked per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is operations/second.

Availability Group Redo Bytes Remaining (KB)

The amount of log bytes (in KB) that has not completed the redo phase. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes.

Availability Group Redo Queue Size (KB)

The amount of log bytes (in KB) that is not yet redone in the log files of the secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Availability Group Redo Rate (KB Per Sec)

The rate (in KB per second) at which log records are being redone. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes/second.

Availability Group Redone Bytes Per Sec

The amount of log bytes that was redone on the secondary database in the last second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Availability Group Replicas Session Timeout

The duration (in seconds) that the replica waits to receive a message from another replica before assuming that the connection between the primary and the secondary replica has failed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Availability Group Replicas Statistics Bytes Sent Per Sec

The number of bytes that are currently being sent per second from the primary replica to the secondary replica, or from the secondary replica to the primary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Availability Group Replicas Status Total Databases

The total number of databases that are hosted by the availability replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Resent Messages Per Sec

The number of AlwaysOn messages that are currently being resent to the availability replica per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Availability Group Secondary Replicas Count

The number of secondary replicas in the availability group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Sent Messages Per Sec

The number of AlwaysOn messages that are currently being sent to the availability replica per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Availability Group Total Connected Replicas Summary

The total number of connected replicas in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Databases Summary

The total number of availability databases that are hosted by the SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Total Disconnected Replicas Summary

The total number of disconnected replicas in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Groups

The total number of availability groups that are available on the SQL Server instance in the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Total Local Failed Replicas Summary

The total number of local replicas that failed in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Local Replicas Summary

The total number of local replicas in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Log Requiring Undo (KB)

The amount of log data (in KB) that must be undone. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes.

Availability Group Total Non Healthy Databases

The total number of the availability databases that have been non-healthy since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Total Non Healthy Groups

The total number of availability groups that are currently not healthy in the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Total Non Healthy Replicas Summary

The total number of non-healthy replicas in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Non Online Local Replica Groups

The total number of availability groups in which at least one availability replica that is hosted by the SQL Server instance is not online in the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Total Non-Online Databases

The total number of databases that have not been online since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Total Primary Databases

The total number of primary availability databases that are hosted by the SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Total Primary Replicas Summary

The total number of primary replicas in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Primary Role Group

The total number of availability groups in which the SQL Server instance is the primary replica in the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Total Secondary Databases

The total number of secondary availability databases that are hosted by the SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Total Secondary Replicas Summary

The total number of secondary replicas in all the availability groups that are hosted on the local server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Secondary Role Group

The total number of availability groups in which the SQL Server instance is the secondary replica in the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is groups.

Availability Group Total Unsynchronized Commit DB Replicas

The total number of availability database replicas on which the transaction commit operation has not been synchronized since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is replicas.

Availability Group Total Unsynchronized Databases

The total number of availability databases that have been unsynchronized since the agent startup. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Availability Group Undo Log Remaining (KB)

The amount of log data (in KB) that remains to be undone. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes.

Availability Group Wait Timeout (ms)

The duration (in milliseconds) that the system waits for a response from the SQL Server instance before the instance is assumed to be slow or not responding. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is milliseconds.

Dimensions

The following dimensions are available for the component.

Availability Group Additional Availability Database Name

The name of the availability database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Additional Availability Group Database ID

The ID of the availability group database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Additional Database Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Additional DB Hub Timestamp

The time when data is inserted at the hub. This is available for thresholds, but not in the UI.
The type is timestamp.

Availability Group Additional DB Role

Indicates whether a replica is currently a primary or secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Additional DB Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Additional DB Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Availability Database ID

The ID of the availability database that is hosted by the SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Availability Database Name

The name of the availability database that is hosted by the SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Availability Database State

Indicates the current state of the availability database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Availability Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Availability Local

Indicates whether the availability replica is hosted by the local SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Availability Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Availability Replica ID

The ID of the availability replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Availability Role

Indicates whether the availability database is a primary or a secondary database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Availability Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Availability Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Availability Suspend Reason

The reason for a database to enter the suspended state. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Availability Synchronization Health

Indicates the health of the availability database replica. The replica is healthy if the synchronized and the asynchronized replicas are in the Synchronized state. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Availability Synchronization State

The current synchronization state of the availability database replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Availability Synchronized Commit

Indicates whether the transaction commit is synchronized with the database replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Backup Preference

The preferred location to perform backup operations on the availability databases that are available in the availability group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Backup Preference In Cluster

The preferred location that is specified for performing backup operations on the availability database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Cluster Failure Condition

The value that indicates when an automatic failover occurs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Cluster Group ID

The availability group ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Cluster Group Name

The availability group name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Cluster Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Cluster Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Cluster Resource Group ID

The WSFC cluster resource group ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Cluster Resource ID

The WSFC cluster resource ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Cluster Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Cluster Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Cluster Failover Ready

Indicates whether the secondary database is synchronized with the primary database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Database Cluster Group Database ID

The availability group database ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Cluster Group ID

The availability group ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Cluster Group Name

The availability group name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Cluster Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Database Cluster Join State

Indicates whether the availability database on the availability replica is joined to the availability group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Database Cluster Name

The name of the availability database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Cluster Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Cluster Replica ID

The replica ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Cluster Row Number

The row number in sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Database Cluster Secondary Suspension Pending

Indicates whether the database is pending suspension after a forced failover. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Database Cluster Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Hub Timestamp Summary

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Database ID

The ID of the availability group database that is hosted by the SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Node Summary

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Server Summary

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Statistics Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Database Statistics Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Database Statistics Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Database Statistics Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Databse Row Number Summary

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Failure Condition

The condition level that is specified for triggering an automatic failure of the availability group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Group Host Name Summary

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Hub TimeStamp Summary

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Group ID

The ID of the availability group to which the availability database belongs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Listener Group ID

The availability group ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Listener Group Name

The availability group name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Listener Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Group Listener Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Listener Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Group Listener Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Name

The name of the availability group to which the replica belongs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Node Summary

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Group Role

Indicates whether the local server instance is a primary or a secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Group Row Number Summary

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Group Server Summary

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Groups ID

The ID of the availability group to which the replica belongs. The value format is an alphanumeric string with a maximum of 128 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group ID

The ID of the availability group to which the availability database belongs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Is Conformant

Indicates whether the IP address of the availability groups listener is conformant. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Is DHCP

Indicates whether the IP address of the availability groups listener is configured by the Dynamic Host Configuration Protocol (DHCP). This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Last Group Role

Indicates whether the local server instance is a primary or a secondary replica for the availability group in the last sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Listener ID

The resource ID of the availability group listener in the WSFC cluster. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Listener IP Address

The IP address of the availability group listener. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Listener Name

The name of the availability group listener. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Listener Subnet IP

The IP address of the subnet to which the availability group listener belongs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Local Replica Recovery Health

The recovery health status of the replica that is hosted by the local SQL Server instance in the availability group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Name

The name of the availability group to which the availability database belongs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Port

The TCP port number of the availability group listener. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Primary Replica

The name of the primary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Primary Replica ID

The ID of the primary replica. The format is an alphanumeric string with a maximum of 128 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replica ID

The ID of the replica. The value format is an alphanumeric string. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replica Server

The server and instance name of the location that hosts the replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Availability Mode

Indicates whether the availability replica is running in the synchronous-commit mode or the asynchronous-commit mode. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Backup Priority

The priority that is specified to perform backup operations on the replica. The value of this attribute is displayed as 0 if you select the Exclude Replica check box while configuring an availability replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Cluster Group ID

The availability group ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Cluster Group Name

The availability group name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Cluster Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Replicas Cluster Join State

Indicates whether the availability replica is joined to the availability group in the WSFC cluster. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Cluster Node

The name of the cluster node where the availability replica is located. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Cluster Originnode

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Cluster Replica ID

The availability replica ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Cluster Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Replicas Cluster Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Cluster Server Name

The server and instance name of the location where the availability replica is hosted. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Create Date

The date when the replica was created. This attribute shows No Data if the SQL Server query returns the NULL value. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and SS indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL Server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Replicas Endpoint URL

The database mirroring endpoint that is specified by the user. The value format is an alphanumeric string. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Failover Mode

Indicates whether the failover mode of the availability replica is manual or automatic. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Group ID

The ID of the availability group to which the replica belongs. The value format is an alphanumeric string. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Group Name

The name of the availability group to which the replica belongs. The value format is an alphanumeric string. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Replicas Hub Timestamp Summary

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Replicas Modify Date

The date when the replica was last modified. This attribute shows No Data if the SQL Server query returns the NULL value. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Replicas Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Node Summary

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Owner SID

The security identifier (SID) of the external owner of the replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Primary Connection Type

Indicates the type of connection that is allowed for a primary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Role

Indicates whether a replica is currently a primary or secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Replicas Rows Number Summary

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Replicas Secondary Connection Type

Indicates the type of connection that is allowed for a secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Server Summary

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Statistics Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Replicas Statistics Instance

The name of the local SQL Server instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Statistics Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Statistics Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Replicas Statistics Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Status Connection State

The current connection state of the availability replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Status Group ID

The ID of the availability group to which the replica belongs. The value format is an alphanumeric string with a maximum of 64 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Status Group Name

The name of the availability group to which the replica belongs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Status Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Group Replicas Status Last Connect Error Number

The last connection error number. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Status Local

Indicates whether the replica is hosted by the local instance. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Status Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Status Operational State

The current operational state of the availability replica. This attribute shows the value No Data on the replica that is not local. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Status Recovery Health

Indicates whether the databases that are connected to the availability group are online or are being recovered after a failover. This attribute shows the value No Data on the replica that is not local. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Status Replica ID

The ID of the replica. The value format is an alphanumeric string with a maximum of 64 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Status Role

Indicates whether the replica is a primary or a secondary replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Replicas Status Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Group Replicas Status Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Replicas Status Synchronization Health

The synchronization state of all the databases that are connected to the availability group on the availability replica. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group State

The state of the availability group listener in the WSFC cluster. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Group Statistics Database Name

The name of the availability database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Availability Group Synchronization Health

A summary of the synchronization health of all the replicas in the availability group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Availability Groups Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Availability Groups Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Availability Groups Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: configuration

Information about the configuration of a SQL server. The following section lists the dimensions of Component configuration.

Dimensions

The following dimensions are available for the component.

Configuration Config Parameter

The name of the configuration parameter. The value format is an alphanumeric string with a maximum of 30 characters; for example, Partition group. The sysconfigures and syscurconfigs system tables store the configuration parameters. Use the parameter name to track the performance of a particular configuration parameter. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Config Value

The value for the configuration parameter. The value format is an alphanumeric string with a maximum of 12 characters; for example, 1000. The value was initially specified in the sysconfigures system table. Monitor this value to track its effect on performance, and to compare the initial setting to the maximum, minimum, and run values. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Configuration Maximum Value

The maximum value that can be specified for the configuration parameter. The value format is an alphanumeric string with a maximum of 12 characters; for example, 2147483647. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Minimum Value

The minimum value that can be specified for the configuration parameter. The value format is an alphanumeric string with a maximum of 12 characters; for example, 1. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Parm Type

The type of configuration parameter. If the configuration parameter is dynamic, a server restart is not required. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Configuration Run Value

The value the SQL server is using for the configuration parameter. The value format is an alphanumeric string with a maximum of 12 characters; for example, 1000. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Configuration Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Configuration Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: ErrorEventDetail

The MS SQL Error Event Details data set provides detailed informationabout the selected erros in the SQL Server error log. The data is collected at the time that the error occurred. This data set is an event-type data set. The following section lists the metrics and dimensions of Component ErrorEventDetail.

Metrics

The following metrics are available for the component.

Error Event Detail Message Age (Min.)

The number of minutes that have elapsed since the error occurred. The format is an integer, for example, 2. Use this attribute to help identify the current messages. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minute.

Dimensions

The following dimensions are available for the component.

Error Event Detail Event Hub Timestamp

The time at which data was inserted in the hub. This attribute is available for reports and queries, but not for eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Error Event Detail Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Error Event Detail ID

The ID of the error message. The value format is an integer. For example, 2520. The errors with text that are not numbered are written to the SQL Server message logs. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Error Event Detail Message Issuer

The source of the error message. The value format is an alphanumeric string with a maximum of 8 characters, for example, JSMITH. This is available for thresholds, but not in the UI.
The type is string.

Error Event Detail Message Text (Unicode)

The message text. This attribute is available for reports and queries, but not for eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Error Event Detail Message Timestamp

The timestamp that indicates the date and time at which the error occurred. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and SS indicates second. For example, 01/25/02 08:00:00 indicates that the agent collected data from the SQL Server on January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Error Event Detail Node

The key for the table view. The format is serverid:hostname:MSS. This attribute is available for reports and queries, but not for eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Error Event Detail Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Error Event Detail Sample Timestamp

The timestamp that indicates the date and time at which the agent collected sample data for the SQL Server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and SS indicates second. For example, 01/25/02 08:00:00 indicates that the agent collected the data from the SQL Server on January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Error Event Detail Server Name

The name of the SQL Server. The value format is an alphanumeric string with a maximum of 32 characters. For example, CFS_SVR. This is available for thresholds, but not in the UI.
The type is string.

Error Event Detail Severity Level

The severity level of the error. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Error Event Detail SPID

The ID of the session in which the event has occurred. This attribute is available for reports and queries, but not for eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Error Event Detail SQL State Code

The value that represents state of the SQL Server when the error occurred. The value format is an integer. For example, 37. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Component: msSqlBatchStatistics

Information about batch requests. The following section lists the metrics and dimensions of Component msSqlBatchStatistics.

Metrics

The following metrics are available for the component.

Batch Auto-Param Attempts Per Sec

The number of auto-parameterization attempts per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is attempts/second.

Batch Failed Auto-Params Per Sec

The number of failed auto-parameterization attempts per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is attempts/second.

Batch Forced Parameterization Per Sec

The number of successful forced parameterization attempts per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is attempts/second.

Batch Requests Per Sec

The number of Transact-SQL command batch requests received per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is requests/second.

Batch Safe Auto-Params Per Sec

The number of safe auto-parameterization attempts per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is attempts/second.

Batch Server Attention Rate

The number of attentions per second. An attention is a request by the client to end the currently running request. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is attentions/second.

Batch Server Compilations Per Sec

The number of server compilations per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is compilations/second.

Batch Server Re-Compilations Per Sec

The number of times the server recompiles per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is recompiles/second.

Batch Unsafe Auto-Params Per Sec

The number of unsafe auto-parameterization attempts per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is attempts/second.

Dimensions

The following dimensions are available for the component.

Batch Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Batch Hub Timestamp

The time when data is inserted at the hub. This is available for thresholds, but not in the UI.
The type is timestamp.

Batch Node

The key for the table view of the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Batch Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Batch Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlDatabaseSummary

Information about SQL server databases. The following section lists the metrics and dimensions of Component msSqlDatabaseSummary.

Metrics

The following metrics are available for the component.

Database Current Interval (Sec.)

The number of seconds that have elapsed between the previous sample and the current sample. The value format is an integer; for example, 90. A sample contains the data that IBM Tivoli Monitoring for Microsoft SQL Server collects about each SQL server. New data becomes available if a new interval has occurred and data has been refreshed at the CMS hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Database Minimum Pct Data Freespace

The lowest percentage of aggregate free space in data only and data and log segments on a device allocated to a database. The value format is a percentage with two decimal places allowed; for example, 5.00. The amount of space needed by the database depends on its anticipated activity. Set alerts for abnormal conditions. Evaluate the possibility of adding more space to the database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Database Minimum Pct Log Freespace

The lowest percentage of free space in log only and data and log segments on a device allocated for the database transaction log. The value format is a percentage with two decimal places allowed; for example, 5.00. The amount of space needed by the transaction log depends on the type and quantity of the transactions and the frequency of backups. Set alerts for abnormal conditions. Evaluate the possibility of expanding the log. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Database Total Databases

The number of databases for the SQL server. The value format is an integer; for example, 10.
The type is int.
The unit is databases.

Database Total Databases Critical

The total number of databases that are in the critical state. A database is in the critical state when the (log space percent that is used exceeds 90), or (database space percent that is used exceeds 90), or (database status is equal to 1), or (database state is equal to offline or emergency), or (database error status is equal to yes).
The type is int.
The unit is databases.

Database Total Databases Warning

The total number of databases that are in the warning state. A database is in the warning state when the (log space percent that is used is greater than 70 and less than equal to 90), or (database space percent that is used is greater than 70 and less than equal to 90), or (database state is not equal to offline, online, and emergency).
The type is int.
The unit is databases.

Database Total DBs DBO Only

The number of databases with a status of DBO only. A database with a status of database owner can be accessed only by users with DBO authority. The value format is an integer; for example, 5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Database Total DBs in Error

The number of databases with an error status. A database with an error status is a database with a status of suspect, crashed, or recovery. The value format is an integer; for example, 2. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Database Total DBs No Free Space Accounting

The number of databases that have the free space accounting option disabled. The value format is an integer; for example, 5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Database Total DBs Read Only

The number of databases with a status of read only. The value format is an integer; for example, 5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Database Total DBs Single User

The number of databases with a status of single user. A database with a status of single user can be accessed by only one user at a time. The value format is an integer; for example, 2. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is databases.

Dimensions

The following dimensions are available for the component.

Database Description

The attribute name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Database Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Database Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Database Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Database Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Database Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Database Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters. For example: CFS_SVR5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Database Value

The attribute value. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlFileTable

The MS SQL FileTable Detail data set contains attributes that provide information about each FileTable in the SQL Server. The following section lists the dimensions of Component msSqlFileTable.

Dimensions

The following dimensions are available for the component.

File Table Database Id

The database ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

File Table Directory

The name of the directory of the FileTable. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Table Enabled

Indicates whether the FileTable data is available for non-transactional access. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

File Table Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

File Table Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

File Table Id

The table ID. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

File Table Name

The table name. The value format is an alphanumeric string with a maximum of 30 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Table Node

The key for the table view in the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

File Table Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

File Table Server Name

The name of the SQL Server. This is available for thresholds, but not in the UI.
The type is string.

File Table Total Non Transactional Handles Opened

The total number of non-transactional file handles that are currently open and that are associated with the FileTable. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Component: msSqlIntegrationServiceDetails

The MS SQL Integration Service Details data set provides details about the SQL Server integration service pipeline for an instance of the SQL Server. The following section lists the metrics and dimensions of Component msSqlIntegrationServiceDetails.

Metrics

The following metrics are available for the component.

Integration Service Buffer In Use

The number of buffers that are currently used for the pipeline. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is buffers.

Integration Service Buffer Memory (MB)

The amount of memory in MB that is currently allocated to the buffers that are in the pipeline. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Integration Service Buffer Spooled

The number of buffers that are currently spooled to disk. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is buffers.

Integration Service Flat Buffer Memory (MB)

The amount of memory that is currently allocated to flat memory buffers. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Integration Service Flat Buffers In Use

The number of flat memory buffers that are currently used for the pipeline. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is buffers.

Integration Service Private Buffer Memory (MB)

The amount of memory that is currently allocated to private transformation buffers. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Integration Service Private Buffers In Use

The number of private transformation buffers that are currently used for the pipeline. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is buffers.

Integration Service Total Rows Read

The total number of rows that are currently being read from all data sources. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Integration Service Total Rows Written

The total number of rows that are currently being written to all data destinations. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Dimensions

The following dimensions are available for the component.

Integration Service Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, it is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Integration Service Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Integration Service Row Number

The row number in sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Integration Service Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlJobDetail

The MS SQL Job Detail data set contains attributes that we can use to monitor SQL Server jobs. The following section lists the metrics and dimensions of Component msSqlJobDetail.

Metrics

The following metrics are available for the component.

Job Current Execution Status

The current execution status of the job. This is available for thresholds, but not in the UI.
The type is int.
The unit is status.

Job Current Execution Step

The current step that is being executed in the job. The value format is an alphanumeric string with a maximum of 128 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.
The unit is executionStep.

Job Current Retry Attempt

The current number of retry attempts that are done on a step of a running job. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is retryAttempts.

Job Current Status

The current job status. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is status.

Job Duration

The amount of time it took for the job to complete (in seconds).
The type is int.
The unit is seconds.

Job Enabled

Whether or not the job is enabled to run. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is status.

Job Error Code

Error code for the last completion of the job.
The type is string.
The unit is errorCode.

Job Execution Duration

The time (in seconds) that has elapsed since the job started. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Job Failure Count

The number of unsuccessful executions of the job.
The type is int.
The unit is count.

Job Last Run Outcome

The last job execution status.
The type is int.
The unit is status.

Job Last Run Timestamp

The timestamp of last job execution. If the job has not been run at all, the Last Run Timestamp value is 'N/P' (Not Present). If there is an error retrieving the job information, the Last Run Timestamp value is 'N/P'.
The type is timestamp.
The unit is timestamp.

Job Status

Current status of the job. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is status.

Job Success Count

The number of successful executions of the job.
The type is int.
The unit is count.

Dimensions

The following dimensions are available for the component.

Job Category ID

Job category ID for the job. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Job Category Name

Job category name for the job. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Job Description

The description of the job. The value format is an alphanumeric string with a maximum of 512 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Job Detail Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Job Detail Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Job Detail Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Job Detail Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Job Detail Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Job Detail Server Name

The name of the SQL Server. This is available for thresholds, but not in the UI.
The type is string.

Job Id

The SQL Server job ID.
The type is string.

Job Name

The SQL Server job name.
The type is string.

Job Next Run Timestamp

The timestamp of the next scheduled job execution. If a job is not scheduled to run, its Next Run Timestamp is 'N/C' (Not Configured). If there is an error retrieving the job information, the Next Run Timestamp values is 'N/P'(Not Present). This is available for thresholds, but not in the UI.
The type is timestamp.

Job Notify Level Eventlog

The value that indicates when a notification event must be sent to the Microsoft Windows application log. This is available for thresholds, but not in the UI.
The type is int.

Job Number of Steps

The current number of steps in the job. This is available for thresholds, but not in the UI.
The type is int.

Job Owner

The name of the owner of the job. The value format is an alphanumeric string with a maximum of 128 characters.
The type is string.

Job Start Step ID

The step identifier from where the execution of the job starts. This is available for thresholds, but not in the UI.
The type is int.

Job Type

The type of the job. This is available for thresholds, but not in the UI.
The type is int.

Job Version number

The version number of the job. The version number is automatically updated every time that the job is modified. This is available for thresholds, but not in the UI.
The type is int.

Component: msSqlJobSummary

The MS SQL Job Summary data set contains attributes that we can use to monitor jobs. The following section lists the metrics and dimensions of Component msSqlJobSummary.

Metrics

The following metrics are available for the component.

Job Summary Active Jobs

The number of active jobs since the agent was started. The format is an integer.
The type is int.
The unit is jobs.

Job Summary Failed Jobs

The number of failed jobs since the SQL Server agent was started. The format is an integer.
The type is int.
The unit is jobs.

Job Summary Job Success Rate

The rate at which jobs are successful since the agent was started. The format is an integer.
The type is double.
The unit is statusRate.

Job Summary Jobs Executed Current Interval

The number of processed jobs in the current sampling interval.
The type is int.
The unit is jobs.

Job Summary Jobs Failed Current Interval

The number of jobs that failed in the current sample interval.
The type is int.
The unit is jobs.

Job Summary Jobs Failed Since Startup

The number of failed jobs since the agent was started. This is available for thresholds, but not in the UI.
The type is int.
The unit is jobs.

Job Summary Max Jobs Failed Interval

Maximum number of failed jobs across all samples since the agent was started. This is available for thresholds, but not in the UI.
The type is int.
The unit is jobs.

Job Summary Max Running Jobs Interval

Maximum number of running jobs across all samples since the agent was started. This is available for thresholds, but not in the UI.
The type is int.
The unit is jobs.

Job Summary Queued Jobs

The number of jobs in a queue since the agent was started. The format is an integer.
The type is int.
The unit is jobs.

Job Summary Running Jobs Current Interval

The number of running jobs for the current sample interval. This is available for thresholds, but not in the UI.
The type is int.
The unit is jobs.

Job Summary Successful Jobs

The number of successful jobs since the agent was started. The format is an integer.
The type is int.
The unit is jobs.

Job Summary Warning Jobs Current Interval

The number of processed jobs in the current sampling interval with the status as unknown or canceled.
The type is int.
The unit is jobs.

Dimensions

The following dimensions are available for the component.

Job Summary Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Job Summary Job Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Job Summary Job Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Job Summary Job Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Job Summary Job Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Job Summary Job Server Name

The name of the SQL Server. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlLockConflict

The MS SQL Lock Conflict Detail data set contains attributes that you can use to monitor detailed information about a selected lock conflict. The following section lists the metrics and dimensions of Component msSqlLockConflict.

Metrics

The following metrics are available for the component.

Lock Conflict Blocking Process ID

The identifier for the process that is blocking a request for a lock. The value format is an alphanumeric string with a maximum of 8 characters; for example, 12. Some blocking processes can become stranded. Investigate eventing thresholds in which a process is being blocked for an extended period of time. For more information on a blocking process, query the sysprocesses and use the sp-lock procedure.
The type is int.
The unit is process_id.

Requestor Process ID

The ID of the blocked process. The value format is an alphanumeric string with a maximum of 16 characters; for example, 21.
The type is int.
The unit is process_id.

Dimensions

The following dimensions are available for the component.

Lock Conflict Client Group ID

The group ID of the user executing the process. This value does not apply to Microsoft SQL Server version 7. The value format is an alphanumeric string with a maximum of 8 characters; for example, ACCT_1.
The type is string.

Lock Conflict Client User ID

ID of the user who executed the command. The value format is an alphanumeric string with a maximum of 8 characters.
The type is string.

Lock Conflict Database Id

ID of the database that is locked. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Lock Conflict Database Name

The name of the database. The value format is an alphanumeric string with a maximum of 30 characters; for example, KOQ3. Each database name is unique. The SQL server also assigns each database its own identification number. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Lock Conflict Database Name (Unicode)

The name of the database.
The type is string.

Lock Conflict Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Lock Conflict Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Lock Conflict Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Lock Conflict Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Lock Conflict Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Lock Conflict Server Name

The number of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is available for thresholds, but not in the UI.
The type is string.

Lock Conflict Server User ID

The ID of the server user. The value format is an alphanumeric string with a maximum of 8 characters. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlLockResourceTypeSummary

The MS SQL Lock Resource Type Summary data set provides information about locks on individual resource types. The following section lists the metrics and dimensions of Component msSqlLockResourceTypeSummary.

Metrics

The following metrics are available for the component.

Lock Type Summary Average Wait Time locks (ms)

The average amount of wait time (in milliseconds) for each lock request that resulted in a wait. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is milliseconds.

Lock Type Summary Lock Requests per Sec.

The number of new locks and lock conversions per second requested from the lock manager. This value is calculated on an interval, and does not reflect a total value. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is conversions/second.

Lock Type Summary Lock Timeouts per Sec.

The number of lock requests per second that timed out, including requests for NOWAIT locks. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is requests/second.

Lock Type Summary Lock Wait Time (ms)

The total wait time (in milliseconds) for locks in the last second.
The type is int.
The unit is milliseconds.

Lock Type Summary Number Deadlocks per Second

The number of Deadlocks per second for the current sample interval.
The type is double.
The unit is deadlocks/second.

Dimensions

The following dimensions are available for the component.

Lock Type Summary Lock Resource Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Lock Type Summary Lock Resource Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Lock Type Summary Lock Resource Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Lock Type Summary Lock Resource Row Number

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Lock Type Summary Lock Resource Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Lock Type Summary Lock Resource Type

An enumeration of the resources that the SQL Server can lock.
The type is int.

Component: msSqlLockSummary

The MS SQL Lock Summary data set contains attributes that you can use to monitor the number of database locks that are currently open. The following section lists the metrics and dimensions of Component msSqlLockSummary.

Metrics

The following metrics are available for the component.

Lock Summary Exclusive Extent Locks

The number of granted Exclusive Extent locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Exclusive Intent Locks

The number of granted Exclusive Intent locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Exclusive Locks

The number of granted Exclusive locks.
The type is int.
The unit is locks.

Lock Summary Exclusive Page Locks

The number of granted Exclusive Page locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Exclusive Table Locks

The number of granted Exclusive Table locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Extent Locks

The number of granted Extent locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Intent Locks

The number of granted Intent locks.
The type is int.
The unit is locks.

Lock Summary Page Locks

The number of granted Page locks.
The type is int.
The unit is locks.

Lock Summary Pct Max Locks Summary

The percentage of locks on resources of the maximum number of locks allowed by the SQL server. The value format is a percentage with two decimal places allowed; for example, 10.00. Setting a higher limit for the maximum number of locks does not impair performance. If your operations exceed the number of available locks, you can increase this limit. This attribute is not available for use in eventing thresholds or for historical data collection. To create a eventing threshold, use the MS SQL Server Enterprise View data set. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Lock Summary Shared Intent Locks

The number of granted Shared Intent locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Shared Locks

The number of granted Shared locks.
The type is int.
The unit is locks.

Lock Summary Shared Page Locks

The number of granted Shared Page locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Shared Table Locks

The number of granted Shared Table locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Table Lock Escalations per Sec

The number of times that the locks on a table were escalated. This is available for thresholds, but not in the UI.
The type is double.
The unit is escalations/seconds.

Lock Summary Table Locks

The number of granted Table locks.
The type is int.
The unit is locks.

Lock Summary Total Lock Conflicts

The total number of processes involved in lock conflicts. The value format is an integer. This attribute is not available for use in eventing thresholds or for historical data collection. To create a eventing threshold, use the MS SQL Server Enterprise View data set. This is available for thresholds, but not in the UI.
The type is int.
The unit is conflicts.

Lock Summary Update Extent Locks

The number of granted Update Extent locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Lock Summary Update Page Locks

The number of granted Update Page Locks. This is available for thresholds, but not in the UI.
The type is int.
The unit is locks.

Dimensions

The following dimensions are available for the component.

Lock Summary Lock Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Lock Summary Lock Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Lock Summary Lock Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Lock Summary Lock Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Lock Summary Lock Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Lock Summary Lock Server Name

The name of the SQL Server. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlLogShippingErrors

The MS SQL Log Shipping Errors data set provides detailed information about log shipping errors. This data set is not supported on the SQL Server 2005 and 2008 Express Edition. The following section lists the dimensions of Component msSqlLogShippingErrors.

Dimensions

The following dimensions are available for the component.

Log Shipping Errors Database ID

The ID of the primary or secondary database for the log shipping configuration. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Log Shipping Errors Database Name

The name of the database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Errors Error Source

The source of the error message or event. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Errors Errors Agent Type

The type of log shipping job. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Log Shipping Errors Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Log Shipping Errors Log Time

The date and time at which the record is created. The format is YY/MM/DD HH:mm, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, and mm indicates minute. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Errors Message

The job completion message text. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Errors Node

The key to this table of the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Errors Sequence Number

An incremental number that indicates the correct order of information for errors that span multiple records. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Log Shipping Errors Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Errors Timestamp

The time when data is collected. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Component: msSqlLogShippingJobDetail

The MS SQL Log Shipping Jobs Detail data set provides detailed information about log shipping jobs. This data set is not supported on the SQL Server 2005 and 2008 Express Edition. The following section lists the dimensions of Component msSqlLogShippingJobDetail.

Dimensions

The following dimensions are available for the component.

Log Shipping Job Database ID

The ID of the primary or secondary database for the log shipping configuration. For jobs that do not have an associated database, the value for the Database ID attribute is displayed as -1. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Log Shipping Job Database Name

The name of the database. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Job Hub Timestamp

The time when data is inserted at the hub. This is available for thresholds, but not in the UI.
The type is timestamp.

Log Shipping Job Job Agent Type

The type of log shipping job. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Log Shipping Job Log Time

The date and time at which the record is created. The format is YY/MM/DD HH:mm, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, and mm indicates minute. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Job Message

The job completion message text. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Job Name

The log shipping job name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Job Node

The key to this table of the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Job Server

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Log Shipping Job Session ID

The primary ID for backup or the secondary ID for copy or restore. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Log Shipping Job Status

The status of the session. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Log Shipping Job Timestamp

The time when data is collected. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Component: msSqlMemoryManager

The MS SQL Memory Manager data set provides information about the memory usage. The following section lists the metrics and dimensions of Component msSqlMemoryManager.

Metrics

The following metrics are available for the component.

Memory Manager Connection Memory(MB)

The total amount of dynamic memory the server is using for maintaining connections in megabytes. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Memory Manager Granted Workspace Memory(MB)

The total amount of memory granted to running processes. This memory is used for the hash, sort, and create index operations in megabytes. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is megabytes.

Memory Manager Lock Blocks

The current number of lock blocks that are in use on the server. Refreshed periodically. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is blocks.

Memory Manager Lock Blocks Allocated

The current number of allocated lock blocks. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is blocks.

Memory Manager Lock Memory(MB)

The total amount of dynamic memory the server is using for locks in megabytes. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Memory Manager Lock Owner Blocks

The number of lock owner blocks that are in use on the server. The blocks are refreshed periodically. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is lockOwnerBlocks.

Memory Manager Lock Owner Blocks Allocated

The current number of allocated lock owner blocks. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is ownerBlocks.

Memory Manager Maximum Workspace Memory(MB)

The total amount of memory granted to running processes. This memory is used primarily for the hash, sort, and create index operations in megabytes. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is megabytes.

Memory Manager Memory Grants Outstanding

The current number of processes that have successfully acquired a workspace memory. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is processes.

Memory Manager Memory Grants Pending

The current number of processes waiting for a workspace memory grant. The format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is processes.

Memory Manager Optimizer Memory(MB)

The total amount of dynamic memory the server is using for query optimization in megabytes. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Memory Manager SQL Cache Memory(MB)

The total amount of dynamic memory the server is using for the dynamic SQL cache in megabytes. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Memory Manager Target Server Memory(MB)

The total amount of dynamic memory the server is willing to consume in megabytes. The format is an integer.
The type is double.
The unit is megabytes.

Memory Manager Total Server Memory(MB)

The total amount of dynamic memory the server is currently consuming in megabytes. The format is an integer.
The type is double.
The unit is megabytes.

Dimensions

The following dimensions are available for the component.

Memory Manager Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Memory Manager Hub Timestamp

The time when data is inserted at the hub. This is available for thresholds, but not in the UI.
The type is timestamp.

Memory Manager Node

The key to this table of the format serverid:hostname:MSS.
The type is string.

Memory Manager Sample Timestamp

The time when data is collected. This is available for thresholds, but not in the UI.
The type is timestamp.

Memory Manager Server Name

The name of the SQL Server. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlProblemDetail

The MS SQL Problem Detail data set contains attributes that we can use to display detailed information about a selected error. The following section lists the metrics and dimensions of Component msSqlProblemDetail.

Metrics

The following metrics are available for the component.

Problem Detail Message Age (Min.)

The number of minutes that have elapsed since the error occurred. The value format is an integer; for example, 2. Monitor this value to track current messages.
The type is int.
The unit is minutes.

Dimensions

The following dimensions are available for the component.

Problem Detail Error ID

The ID of the error message. The value format is an integer; for example, 2520. The unnumbered errors with text explanations are written to the SQL server message logs.
The type is string.

Problem Detail Error SPID

The ID of the session when an event occurs. It is prefixed with spid. For example, spid34s, spid57. When the ID of the session is unavailable, the source of error is showed as it is. For example, logon. This attribute is not applicable for eventing thresholds.
The type is string.

Problem Detail Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Problem Detail Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Problem Detail Message Issuer

The source of the error message. The value format is an alphanumeric string with a maximum of 8 characters; for example, JSMITH. This is available for thresholds, but not in the UI.
The type is string.

Problem Detail Message Text

The message text. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is string.

Problem Detail Message Text (Unicode)

The message text. This attribute is not available for use in eventing thresholds.
The type is string.

Problem Detail Message Timestamp

The timestamp that indicates the date and time the error occurred. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m.
The type is timestamp.

Problem Detail Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Problem Detail Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Problem Detail Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Problem Detail Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Problem Detail Severity Level

Indicates the severity level of the error.
The type is string.

Problem Detail SQL State Code

The SQL state value for the error message. The value format is an integer; for example, 37.
The type is int.

Component: msSqlProblemSummary

The MS SQL Problem Summary data set contains attributes that you can use to monitor summary information about SQL server errors. The following section lists the metrics and dimensions of Component msSqlProblemSummary.

Metrics

The following metrics are available for the component.

Problem Summary Age of Last Error (Min.)

The number of minutes that have elapsed since the last error message occurred. The value format is an integer; for example, 2. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minutes.

Problem Summary Current Interval (Sec.)

The number of seconds that have elapsed between the previous sample and the current sample. The value format is an integer; for example, 90. A sample contains the data that IBM Tivoli Monitoring for Microsoft SQL Server collects about each SQL server. New data becomes available if a new interval has occurred and data has been refreshed at the CMS hub. This is available for thresholds, but not in the UI.
The type is int.
The unit is seconds.

Problem Summary Error Log Size (Bytes)

The number of bytes in the error log file. The value format is an integer; for example, 50000. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is bytes.

Problem Summary Total Error Messages

The number of error messages that have occurred since the SQL server was started. The value format is an integer; for example, 3. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Problem Summary Total Errors Cur Intvl

The number of error messages that occurred during the current interval. The value format is an integer; for example, 1.
The type is int.
The unit is errors.

Problem Summary Total Errors High Sev

The number of error messages with a severity level of 17 or higher that have occurred since the SQL server was started. The value format is an integer; for example, 2. This is available for thresholds, but not in the UI.
The type is int.
The unit is errors.

Problem Summary Total Errors Other

The number of error messages with a severity level of less than 17 that have occurred since the SQL server was started. The value format is an integer; for example, 3. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is errors.

Dimensions

The following dimensions are available for the component.

Problem Summary Attribute Name

The attribute name. This is available for thresholds, but not in the UI.
The type is string.

Problem Summary Attribute Value

The attribute value. This is available for thresholds, but not in the UI.
The type is string.

Problem Summary Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Problem Summary Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Problem Summary Maximum Sev Current Interval

The error message of the highest severity level encountered during the current interval. The value format is an integer in the range 10 through 24; for example, 19.
The type is string.

Problem Summary Maximum Sev Level

The level of highest severity encountered since the SQL server started. The value format is an integer in the range 10 through 24; for example, 22. This is available for thresholds, but not in the UI.
The type is string.

Problem Summary Maximum Sev Timestamp

The timestamp that indicates the date and time the error message with the highest severity level occurred. The format is MM/DD/YY HH:mm:SS, where MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m.
The type is timestamp.

Problem Summary Problem Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Problem Summary Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Problem Summary Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, where MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Problem Summary Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlProcess

The MS SQL Process Detail data set contains attributes that you can use to monitor detailed information about a selected SQL server process. The following section lists the metrics and dimensions of Component msSqlProcess.

Metrics

The following metrics are available for the component.

Process Blocking Process Duration(Mins.)

The total time (mins) for which the current blocking process has blocked a request since the agent start up. If a request is blocked by multiple processes during the data collection interval, the process ID of the blocking process that first blocked a request, and the total blocking process duration of all the blocking processes are displayed.
The type is int.
The unit is minutes.

Process Blocking Resource Duration(Mins.)

The total time (mins) for which the blocking process is currently blocking a request for a resource type. This is available for thresholds, but not in the UI.
The type is int.
The unit is minutes.

Process Current CPU Pct Used

Relative percent of the CPU used by this SQL Server process compared to all other SQL Server processes. The value format is a percentage with two decimal places allowed; for example, 80. 00. This dynamic information is from the sysprocesses table. Set alerts for processes using an abnormal amount of CPU, relative to all other SQL Server processes.
The type is double.
The unit is percent.

Process Duration (Sec.)

The time (in seconds) for which the process has been running. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Process Status

Indicates the status of the process.
The type is string.
The unit is status.

Process Total CPU Time (Sec.)

The amount of CPU time, in seconds, the process has used on the host since the process started. The value format is an integer; for example, 60. This value is based on the statistics collected by the SQL server. Use this value to check for processes that use abnormal amounts of CPU time. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is seconds.

Process Total Disk IO

The number of accesses to hard disk since the process started. The value includes accesses to hard disk for physical reads and physical writes. The value format is an integer; for example, 10.
The type is int.
The unit is accesses .

Process Total Memory Alloc (KB)

The number of KB allocated for this process, based on the number of pages in the procedure cache. A negative number indicates that the process is freeing memory allocated by another process. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Dimensions

The following dimensions are available for the component.

Process Blocking Process ID

The identifier for the process that is blocking a request for a lock. The value format is an alphanumeric string with a maximum of 8 characters; for example, 12. Some blocking processes can become stranded. Investigate eventing thresholds in which a process is being blocked for an extended period of time. For more information on a blocking process, query the sysprocesses and use the sp-lock procedure.
The type is string.

Process Blocking Resource Type

The resource type of the request that is currently blocked by the blocking process. This is available for thresholds, but not in the UI.
The type is string.

Process Client Group ID

The group ID of the user executing the process. This value does not apply to Microsoft SQL Server version 7. The value format is an alphanumeric string with a maximum of 8 characters; for example, ACCT_1. This is available for thresholds, but not in the UI.
The type is string.

Process Client Host Name

The name of the host for the client. The value format is an alphanumeric string with a maximum of 16 characters; for example, Rocket.
The type is string.

Process Client Process ID

The ID the client assigned to the process. The value format is an alphanumeric string with a maximum of 16 characters; for example, amc_2236.
The type is string.

Process Client User ID

The ID of the user executing the process. The value format is an alphanumeric string with a maximum of 8 characters; for example, J_Kelly.
The type is string.

Process Command

The name of the command being executed by the process. The value format is an alphanumeric string with a maximum of 16 characters; for example, CREATE VIEW.
The type is string.

Process Command (Unicode)

The name of the executing command. The value format is an alphanumeric string with a maximum of 48 bytes. This is available for thresholds, but not in the UI.
The type is string.

Process Database Name

The name of the database. The value format is an alphanumeric string with a maximum of 30 characters; for example, KOQ3. Each database name is unique. The SQL server also assigns each database its own identification number. This is available for thresholds, but not in the UI.
The type is string.

Process Database Name (Unicode)

The database name. The value format is an alphanumeric string with a maximum of 384 bytes.
The type is string.

Process Detail Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Process Detail Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Process Detail Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Process Detail Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Process Detail Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Process Detail Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is available for thresholds, but not in the UI.
The type is string.

Process ID

The ID of the process. The value format is an alphanumeric string with a maximum of 10 characters; for example, 42168.
The type is int.

ID used by the process to log in to the SQL Server. The value format is an alphanumeric string with a maximum of 30 characters. This is available for thresholds, but not in the UI.
The type is string.

Process NT User

User name associated with the process. This is available for thresholds, but not in the UI.
The type is string.

Process OS Process ID

The Microsoft Windows thread ID. This is available for thresholds, but not in the UI.
The type is string.

Process Program Name

The name of the program (front-end module) for the process. The value format is an alphanumeric string with a maximum of 16 characters; for example, ISQL. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Process Program Name (Unicode)

The Program Name. The value format is an alphanumeric string with a maximum of 384 bytes.
The type is string.

Process Server User ID

The SQL server-assigned ID for the user executing the process. The value format is an alphanumeric string with a maximum of 8 characters; for example, S.
The type is string.

Component: msSqlProcessSummary

The MS SQL Process Summary data set contains attributes that you can use to monitor summary information about processes. The following section lists the metrics and dimensions of Component msSqlProcessSummary.

Metrics

The following metrics are available for the component.

Process Summary Percent Processes Bad

The percentage of processes with a status of bad. The value format is a percentage with two decimal places allowed; for example, 2.00. This value is based on information from the sysprocesses table. Bad processes are often associated with a process ID problem. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Process Summary Percent Processes Blocked

The percentage of processes that are being blocked. The value format is a percentage with two decimal places allowed; for example, 4.00. This value is based on information from the sysprocesses table. The value includes all processes currently in a waiting state.
The type is double.
The unit is percent.

Process Summary Percent Processes Infected

The percentage of processes with a status of infected. The value format is a percentage with two decimal places allowed; for example, 2.00. This value is based on information from the sysprocesses table. An infected process is associated with a serious error condition. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Process Summary Percent Processes Locksleep

The percentage of processes with a status of locksleep. The value format is a percentage with two decimal places allowed; for example, 10.00. This value is based on information from the sysprocesses table. The processes are waiting to obtain locks on resources. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Process Summary Percent Processes Othersleep

The percentage of processes with a status of alarm sleep, recv sleep, send sleep, or sleeping. The value format is a percentage with two decimal places allowed; for example, 10.00. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Process Summary Percent Processes Sleeping

The percentage of processes with a status of sleep. The value format is a percentage with two decimal places allowed; for example, 20.00. This value is based on information from the sysprocesses table. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Process Summary Percent Processes Stopped

The percentage of processes with a status of stopped. The value format is a percentage with two decimal places allowed; for example, 2.00. This value is based on information from the sysprocesses table. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Process Summary Process Current Interval (Sec.)

The number of seconds that have elapsed between the previous sample and the current sample. The value format is an integer; for example, 90. A sample contains the data that IBM Tivoli Monitoring for Microsoft SQL Server collects about each SQL server. New data becomes available if a new interval has occurred and data has been refreshed at the CMS hub. This is available for thresholds, but not in the UI.
The type is int.
The unit is seconds.

Process Summary Server CPU Pct System

The percentage of CPU time the SQL server processes are using on the host. The value format is a percentage with two decimal places allowed; for example, 25.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Process Summary Server CPU Percent Application

The percentage of CPU time the SQL server application processes are using on the host. The value format is a percentage with two decimal places allowed; for example, 20.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Process Summary Total Log Suspend

The number of processes with a status of log suspend. A process with a status of log suspend is a process that cannot complete until there is free space in the transaction log. The value format is an integer; for example, 1. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Process Summary Total Other Sleep

The number of processes with a status of othersleep. The value format is an integer; for example, 2. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Process Summary Total Processes

The number of processes. The value includes background processes, processes for applications, and user processes. The value format is an integer; for example, 50. This value includes background processes, processes for applications, and user processes. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Process Summary Total Processes Bad

The number of processes with a status of bad. The value format is an integer; for example, 1. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Process Summary Total Processes Blocked

The number of processes that are being blocked. The value format is an integer; for example, 2. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Process Summary Total Processes Infected

The number of processes with a status of infected. A process with a status of infected is a process that cannot be completed. The value format is an integer; for example, 1. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Process Summary Total Processes Locksleep

The number of processes with a status of locksleep. A process with a status of locksleep is a process waiting for a lock on a resource to be released. The value format is an integer; for example, 5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Process Summary Total Processes Stopped

The number of processes with a status of stopped. The value format is an integer; for example, 1. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is count.

Dimensions

The following dimensions are available for the component.

Process Summary Process Description

The attribute name. This is available for thresholds, but not in the UI.
The type is string.

Process Summary Process Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Process Summary Process Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Process Summary Process Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Process Summary Process Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Process Summary Process Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Process Summary Process Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is available for thresholds, but not in the UI.
The type is string.

Process Summary Process Value

The attribute value. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlResourcePoolStats

The MS SQL Resource Pool Stats data set provides statistics associated with resource pools. This data set is not supported on the SQL Server 2005 and 2008 Express Edition. The following section lists the metrics and dimensions of Component msSqlResourcePoolStats.

Metrics

The following metrics are available for the component.

Resource Pool Active Memory Grant Amount(MB)

The total amount of granted memory in megabytes in the resource pool. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Resource Pool Active Memory Grants Count

The count of memory grants that are assigned to pool workers. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is grants.

Resource Pool Cache Memory Target(MB)

The current memory target for cache memory in megabytes. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Resource Pool Compile Memory Target(MB)

The current memory target for compile memory in megabytes. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Resource Pool CPU Control Effect Pct

The effect of the resource governor on the resource pool calculated as (CPU Usage Percent)/(CPU Usage Percent without RG). The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Resource Pool CPU Usage Pct

The system CPU Usage by all requests in the specified instance of the performance object. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Resource Pool CPU Usage Target Pct

The target value of CPU Usage Percent for the resource pool based on the configuration settings and the system load. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Resource Pool Max Memory(MB)

The maximum amount of memory in megabytes the resource pool can have based on the settings and the server state. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Resource Pool Memory Grant Timeouts Per Sec

The number of query memory grant timeouts per second occurring in the resource pool. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is timeouts/second.

Resource Pool Memory Grants Per Sec

The number of query memory grants per second occurring in the resource pool. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is grants/second.

Resource Pool Pending Memory Grants Count

The number of queries waiting for memory grants in the resource pool. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries.

Resource Pool Query Exec Memory Target(MB)

The current memory target for query execution in megabytes. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Resource Pool Target Memory(MB)

The target amount of memory in megabytes the resource pool tries to attain based on the settings and the server state. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Resource Pool Used Memory(MB)

The used amount of memory in megabytes in the resource pool. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Dimensions

The following dimensions are available for the component.

Resource Pool Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Resource Pool Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Resource Pool Name (Unicode)

The resource governor resource pool name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Resource Pool Node

The key to this table of the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Resource Pool Sample Timestamp

The time when data is collected. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Resource Pool Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlServerDetail

Information about the SQL server. The following section lists the metrics and dimensions of Component msSqlServerDetail.

Metrics

The following metrics are available for the component.

Server Detail Current Locks

The number of current locks for the SQL server. The value format is an integer; for example, 73. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is locks.

Server Detail Percent Max Locks

The percentage of locks on resources of the maximum number of locks allowed by the SQL server. The value format is a percentage with two decimal places allowed; for example, 10.00. Setting a higher limit for the maximum number of locks does not impair performance. If your operations exceed the number of available locks, you can increase this limit. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Server Detail Procedure Buffers Pct Active

The percentage of slots with a procedure that is currently executing. Use this attribute to see how much of the cache these procedures use in relation to the cache size as a whole. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Server Detail Procedure Buffers Pct Used

The percentage of slots that have a procedure in them. A procedure buffer is considered used when it is associated with a procedure cache entry. A used procedure buffer can be active or not active. Use this attribute to see how much of the cache is being used by currently compiled procedures in relation to the cache size as a whole. The value format is an integer.
The type is double.
The unit is percent.

Server Detail Procedure Buffers Total

The number of procedure buffers that are in the procedure cache. This number is a fixed number based on the procedure cache that is allocated. Use this attribute to see how much of the cache currently executing procedures use in relation to the cache size as a whole. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is buffers.

Server Detail Procedure Cache Pages

The number of pages that are allocated for the procedure cache. The SQL server uses the procedure cache to compile queries and store procedures that are compiled. The value format is an integer; for example 1000. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is pages.

Server Detail Procedure Cache Pct Active

The total size of the procedure cache in pages. The size of the procedure cache can fluctuate depending on the activity of other database server processes that might require procedure cache slots, such as query plans. Use the attribute to see the current size of the procedure cache. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Server Detail Procedure Cache Pct Used

The percentage of the procedure cache that has procedures in it. Use this attribute to see how much of the cache currently executing procedures use in relation to the cache size as a whole. The value format is an integer.
The type is double.
The unit is percent.

Server Detail Procedure Cache Percent

The percentage of cache memory the SQL server uses for the procedure cache. This value does not apply to Microsoft SQL Server version 7. The value format is a percentage with two decimal places allowed; for example, 20.00. This attribute is deprecated from the SQL Server agent V6. 2. 1. 1. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Server Detail Server Data Cache Size (KB)

The number of kilobytes (KB) allocated for the data cache memory. The SQL server uses the data cache to store data and index pages. The value format is an integer; for example, 1000. The cache is sometimes referred to as the buffer cache. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Detail Server Error Log Size (Bytes)

The number of bytes in the error log file. The value format is an integer; for example, 50000. The error log contains the fatal error and kernel error messages issued by the SQL server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is bytes.

Server Detail Server Procedure Cache Size (KB)

The number of kilobytes (KB) that are allocated for the procedure cache. The SQL server uses the procedure cache to compile queries and store procedures that are compiled. The value format is an integer; for example 1000. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Detail Server Time Since Startup (Min.)

The number of minutes that have elapsed since the SQL server was started. The value format is an integer; for example, 360. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minutes.

Dimensions

The following dimensions are available for the component.

Server Detail Error Log Name

The name of the file that contains the error log for the SQL server. The value format is an alphanumeric string with a maximum of 64 characters; for example, SQL_Error_Log. The error log tracks fatal and kernel errors. It also contains startup and system information. Check the error log for message content and details. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Detail Error Log Name (Unicode)

The name of the file that contains the error log for the SQL server (Unicode). This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Detail Max Locks Allowed

The maximum number of allowable locks. The value format is an integer; for example, 2000. This value is a configuration parameter.
The type is int.

Server Detail OS Type

The operating system for the SQL server. The value format is an alphanumeric string; for example, AIX .
The type is string.

Server Detail OS Version

The version of the operating system for the SQL server. The value format is the version in the format version. release; for example, 2. 5.
The type is string.

Server Detail Server deatil Status

Indicates the status of the SQL server. The server status is displayed as Unknown when the collector process of the SQL Server agent is not running. The server status is displayed as Inactive when the collector process of the SQL Server agent is running, but the SQL Server is not responding to the request. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Detail Server detail Type

The type of SQL server. The value format is an alphanumeric string; for example, SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Detail Server detail Version

The version of the SQL Server. The value format is the version in the format w. x. y. z; for example, 10. 0. 2531. 0. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Detail Server Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Detail Server Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Server Detail Server Node

The key for the table view in the format serverid:hostname:MSS.
The type is string.

Server Detail Server Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Server Detail Server Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Server Detail SQL Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Detail Startup Timestamp

The timestamp that indicates the date and time the SQL server was started. The format is YYY/MM/DD HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m.
The type is timestamp.

Server Detail Version (Superceded)

The version of the SQL Server. The value format is the version in the format x. y. z; for example, 10. 0. 253. For the complete version of the SQL Server, see the Server Version attribute. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlServerTransactionSummary

The MS SQL Server Transactions Summary data set contains attributes that you can use to monitor the transaction summary information for SQL Servers. The following section lists the metrics and dimensions of Component msSqlServerTransactionSummary.

Metrics

The following metrics are available for the component.

Transaction Summary Longest Transaction Running Time (Sec.)

The transaction that is currently active for the longest duration of time (in seconds). The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is seconds.

Transaction Summary Tempdb Free Space (KB)

The amount of free space (in KB) that is currently available in the tempdb database. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is kilobytes.

Transaction Summary Total Active Transactions

The number of transaction enlistments (local, dtc, and bound) that are currently active. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is active_transaction.

Transaction Summary Total Non-Snapshot Version Transactions

The number of currently active non-snapshot transactions that generate version records. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is count.

Transaction Summary Total Snapshot Transactions

The number of snapshot transactions that are currently active. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is count.

Transaction Summary Total Update Snapshot Transactions

The number of currently active snapshot transactions that perform update operations. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is count.

Transaction Summary Update Conflict Ratio

The percentage of snapshot transactions that currently have update conflicts. The value format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is percent.

Transaction Summary Version Cleanup Rate (KB/sec)

The current rate (in KB per second) at which versions are removed from the version store. The value format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is kilobytes per seconds.

Transaction Summary Version Generation Rate (KB/sec)

The current rate (in KB per second) at which versions are generated in the version store. The value format is an integer. This is available for thresholds, but not in the UI.
The type is double.
The unit is kilobytes per seconds.

Transaction Summary Version Store Size

The amount of space (in KB) that is currently available in the version store. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is kilobytes.

Transaction Summary Version Store Unit Count

The number of allocation units that are currently active in the version store. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is count.

Transaction Summary Version Store Unit Creation

The number of units that are currently created in the version store. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is count.

Transaction Summary Version Store Unit Truncation

The number of units that are currently truncated in the version store. The value format is an integer. This is available for thresholds, but not in the UI.
The type is int.
The unit is count.

Dimensions

The following dimensions are available for the component.

Transaction Summary Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Transaction Summary Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is available for thresholds, but not in the UI.
The type is timestamp.

Transaction Summary Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Transaction Summary Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Transaction Summary Server Name

The name of the SQL Server. The value is an alphanumeric string with a maximum of 30 characters. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlServiceBrokerActivation

The MS SQL Service Broker Activation data set monitors the details of the Service Broker activation for each database in an SQL Server instance. The following section lists the metrics and dimensions of Component msSqlServiceBrokerActivation.

Metrics

The following metrics are available for the component.

Service Broker Activation Stored Procedure Invoked Per sec

The number of stored procedures that are currently called per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is procedures/second.

Service Broker Activation Task Limit Reached Per sec

The number of times that the task limit that is currently activated for a queue has been reached per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is limits/second.

Service Broker Activation Tasks Aborted Per sec

The number of activated tasks that are currently ended per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is tasks/second.

Service Broker Activation Tasks Started Per sec

The number of activated tasks that are currently being started per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is tasks.

Service Broker Activation Total Task Limit Reached

The number of times that the task limit that is currently activated for a queue has been reached. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is limits.

Service Broker Activation Total Tasks Started

The total number of activated tasks that are currently started. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is tasks.

Dimensions

The following dimensions are available for the component.

Service Broker Activation Database Name (Unicode)

The name of the database in the Unicode format. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Service Broker Activation Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is available for thresholds, but not in the UI.
The type is timestamp.

Service Broker Activation Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Service Broker Activation Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Service Broker Activation Server Name

The name of the SQL Server. The value is an alphanumeric string with a maximum of 30 characters. This is available for thresholds, but not in the UI.
The type is string.

Component: msSqlServiceBrokerStatistics

The MS SQL Service Broker Statistics data set displays the summary of the Service Broker statistics. The following section lists the metrics and dimensions of Component msSqlServiceBrokerStatistics.

Metrics

The following metrics are available for the component.

Service Broker Statistics Enqueued Local Messages Per Sec

The number of messages per second from local endpoints that are currently being delivered into the queues. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Service Broker Statistics Enqueued Messages Per Sec

The number of messages from local endpoints and the transport that are currently delivered into the queues per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Service Broker Statistics Enqueued Transport Messages Per Sec

The number of messages from the transport that are being delivered into the queues per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Service Broker Statistics Forwarded Messages Discarded Per Sec

The number of forwarded messages that are currently discarded per second because of memory limits for forwarded messages, age limits, and so on. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messages/second.

Service Broker Statistics Forwarded Pending Messages

The number of forwarded messages that are currently in the queue, and that are not yet sent. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Service Broker Statistics SQL Receives Per Sec

The number of SQL RECEIVE commands that are processed per second by the Service Broker. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is receives/second.

Service Broker Statistics SQL Sends Per Sec

The number of SQL SEND commands that are processed per second by the Service Broker. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is sends/second.

Service Broker Statistics Total Enqueued Local Messages

The total number of message fragments from the local endpoints that are currently being delivered into the queues. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Service Broker Statistics Total Enqueued Messages

The total number of message fragments from the local endpoints and the transport that are currently being delivered into the queues. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Service Broker Statistics Total Enqueued Transport Messages

The total number of messages from the transport that are currently delivered into the queues. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Service Broker Statistics Total Forwarded Messages

The total number of forwarded messages from the local endpoints and the transport that are currently being sent. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Service Broker Statistics Total Forwarded Messages Discarded

The total number of forwarded messages that are currently discarded because of memory limits for forwarded messages, age limits, and so on. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Service Broker Statistics Total SQL Receives

The total number of SQL RECEIVE commands that are currently processed by the Service Broker. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is commands.

Service Broker Statistics Total SQL Sends

The total number of SQL SEND commands that are currently processed by the Service Broker. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is commands.

Service Broker Statistics Transaction Rollbacks

The current number of transactions related to the Service Broker that have been rolled back. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rollbacks.

Dimensions

The following dimensions are available for the component.

Service Broker Statistics Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is available for thresholds, but not in the UI.
The type is timestamp.

Service Broker Statistics Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Service Broker Statistics Row Number

The row number in sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Service Broker Statistics Server Name

The name of the SQL Server. The value is an alphanumeric string with a maximum of 30 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlServiceBrokerTransport

The MS SQL Service Broker Transport data set monitors the details of the Service Broker transport for the SQL Server. The following section lists the metrics and dimensions of Component msSqlServiceBrokerTransport.

Metrics

The following metrics are available for the component.

Service Broker Transport Avg Size Message Fragments Received

The average byte size of the message fragments that are received by the transport receive I/O operations. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes.

Service Broker Transport Avg Size Message Fragments Sent

The average byte size of the message fragments that are sent by the transport send I/O operations. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes.

Service Broker Transport Current Bytes For Receive I/O

The number of bytes that are to be read by the transport receive I/O operations that are currently running. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is bytes.

Service Broker Transport Current Bytes For Send I/O

The number of buffer bytes that are to be read by the transport send I/O operations that are currently running. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is bytes.

Service Broker Transport Current Message Fragments For Send I/O

The number of message fragments that are to be read by the transport send I/O operations that are currently running. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messages.

Service Broker Transport Message Fragment Received Per Sec

The number of message fragments that are currently received per second in the transport receive I/O operations. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messageFragments/second.

Service Broker Transport Message Fragments Sent Per Sec

The number of message fragments that are currently sent per second in the transport send I/O operations. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is messageFragments/second.

Service Broker Transport Pending Bytes For Receive I/O

The number of bytes that are currently present in the completed transport receive I/O operations whose message fragments are not yet sent to the queue, or are not yet discarded. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is bytes.

Service Broker Transport Pending Bytes For Send I/O

The current number of buffer bytes of the message fragments that are being sent to the queue, and that are ready to be sent by the transport send I/O operations. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is bytes.

Service Broker Transport Pending Message Fragments For Receive I/O

The current number of message fragments that are received by transport receive I/O operations, and that are not yet sent to the queue or are not yet discarded. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messageFragments.

Service Broker Transport Pending Message Fragments For Send I/O

The current number of message fragments that are being sent to the queue, and that are ready to be sent through the transport layer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is messageFragments.

Service Broker Transport Receive I/Os Per Sec

The current number of transport receive I/O operations per second. A transport receive I/O might contain more than one message fragment. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is receives/second.

Service Broker Transport Send I/Os Per Sec

The current number of transport send I/O operations per second. A transport send I/O operation might contain more than one message fragment. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is operations/second.

Service Broker Transport Total Open Connection Count

The total number of transport connections that are currently open. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is connections.

Dimensions

The following dimensions are available for the component.

Service Broker Transport Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Service Broker Transport Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Service Broker Transport Row Number

The row number in sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Service Broker Transport Server Name

The name of the SQL Server. The value is an alphanumeric string with a maximum of 30 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: msSqlServicesDetail

The MS SQL Services Detail data set provides details about the services that make up the SQL Server. The following section lists the dimensions of Component msSqlServicesDetail.

Dimensions

The following dimensions are available for the component.

Services Detail Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is available for thresholds, but not in the UI.
The type is string.

Services Detail Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Services Detail Name

The service name for the SQL Server.
The type is string.

Services Detail Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Services Detail Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is available for thresholds, but not in the UI.
The type is timestamp.

Services Detail Server Name

The name of the SQL Server. This is available for thresholds, but not in the UI.
The type is string.

Services Detail Start Mode

Defined start mode for the service.
The type is int.

Services Detail State

Current service state.
The type is int.

Services Detail Status

Current service status.
The type is int.

Services Detail Type

The service type for this service to the Microsoft SQL Server.
The type is int.

Component: msSqlStatisticsDetail

Information about SQL server statistics. The following section lists the metrics and dimensions of Component msSqlStatisticsDetail.

Metrics

The following metrics are available for the component.

Statistics Detail Average Value (per Sec.)

The average value per second for the statistic since the SQL server was started. The value format is a decimal with two decimal places allowed; for example, 5.00. This value indicates the norm for the statistic during the current interval.
The type is double.
The unit is value/second.

Statistics Detail Current Value

The value for the statistic during the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is value.

Statistics Detail Maximum Seen

The greatest value per second for the statistic since the SQL server was started. The value format is an integer; for example, 2000. This is a benchmark value. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is value/second.

Statistics Detail Minimum Seen

The smallest value per second for the statistic since the SQL server was stated. The value format is an integer; for example, 10. This is a benchmark value. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minumum/second.

Statistics Detail Total Since Startup

The total of all the values for the statistic since the SQL server was started. The value format is an integer; for example, 9000. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is total.

Dimensions

The following dimensions are available for the component.

Statistics Detail Host Name

The name of the computer on which the SQL Server is running. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Statistics Detail Hub Timestamp

The time when this data was inserted at the hub.. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Statistics Detail Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Statistics Detail Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Statistics Detail Sample Timestamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where, MM indicates month, DD indicates day, YY indicates year, HH indicates hour, mm indicates minute, and ss indicates second. For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Statistics Detail Server Name

The name of the SQL server. The value format is an alphanumeric string with a maximum of 30 characters; for example, CFS_SVR5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Statistics Detail Statistic Name

The name of the statistic. The value format is an alphanumeric string with a maximum of 32 characters; for example, cpu_busy.
The type is string.

Component: msSqlStatisticsSummary

Information about SQL server statistics. The following section lists the metrics and dimensions of Component msSqlStatisticsSummary.

Metrics

The following metrics are available for the component.

Statistics Client Count

The number of client workstations currently connected to the database server. Use this attribute as an alert when you are running out of client connections, which can result in server access problems. This attribute is also useful for tracking client access patterns. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is workstations.

Statistics Client Count Pct Used

The number of client workstations currently connected to the database server and returns the ratio percentage of the number of possible connections.
The type is double.
The unit is workstations.

Statistics Current Interval (Sec.)

The number of seconds that have elapsed between the previous sample and the current sample. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is seconds.

Statistics Current Logons

The number of active connections (logons). This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is connections.

Statistics Disk IO Current Interval

The number of times the SQL server accessed hard disk during the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is accesses.

Statistics IO Errors Current Interval

The number of I/O errors that occurred when the SQL server accessed hard disk during the current interval. The value format is an integer; for example, 5. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is errors.

Statistics IO Errors Since Startup

The number of I/O errors that have occurred when the SQL server accessed hard disk since startup. The value format is an integer; for example, 2. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is errors.

Statistics Network Read Rate (per Sec.)

The rate at which tabular data stream (TDS) packets are read from the network, in packets per second. This statistic is an indicator of network throughput. When this statistic is high, it indicates heavy network traffic. The value format is an integer.
The type is int.
The unit is reads/second.

Statistics Network Write Rate (per Sec.)

The rate at which tabular data stream (TDS) packets are written to the network, in packets per second. This statistic is an indicator of network throughput. When this statistic is high, it indicates heavy network traffic. The value format is an integer.
The type is int.
The unit is writes/second.

Statistics Pct IO Errors Cur Intvl

The percentage of the accesses to hard disk that had errors occur during the current interval. The value format is a percentage with two decimal places allowed; for example, 1. 00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Statistics Pct Max Logons Active

The percentage of active connections (logons) of the maximum number of active connections allowed for the SQL server. The value format is a percentage with two decimal places allowed; for example, 50.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Statistics Pct User Connections Remaining

The current number of remaining user connections as a percentage of the maximum number of available user connections for the database server. Use this attribute to gain an overview of high and low access periods and to warn you of impending availability problems. The value format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Statistics Physical Reads (per Sec.)

The average number of physical reads per second during the current interval.
The type is double.
The unit is reads/second.

Statistics Physical Writes (per Sec.)

The average number of physical writes per second during the current interval. The value format is a decimal with two decimal places allowed; for example, 5.00.
The type is double.
The unit is writes/second.

Statistics Total Logins (Per Sec.)

The number of login operations that started per second in the current interval. The value format is a decimal with two decimal places allowed; for example, 15.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is logins/second.

Statistics Total Logons (per Sec.)

The average number of active connections (logons) per second during the current interval. The value format is a decimal with two decimal places allowed; for example, 15.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is connections/second.

Statistics Total Logouts (per Sec.)

Total number of logout operations started per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is logouts/second.

Statistics Total OS CPU Pct Busy

The percentage of CPU seconds the SQL server has used during the current interval of all the CPU seconds used since the SQL server was started. The value format is a percentage with two decimal places allowed; for example, 20.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Statistics Total OS IO Pct Busy

The percentage of I/O the SQL server used during the current interval of all the I/O used since the SQL server was started. The value format is a percentage with two decimal places allowed; for example, 25.00. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Dimensions

The following dimensions are available for the component.

Statistics Description

The attribute name. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Statistics Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Statistics Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. This is available for thresholds, but not in the UI.
The type is timestamp.

Statistics Max User Connections Allowed

The maximum number of active connections (logons) allowed for the SQL server. The value format is an integer in the range 5 through 2147483647; for example, 100. This is a configuration value for the SQL server. To determine the number of connections that can be configured for the SQL server, use the select @@max_connections command.
The type is int.

Statistics Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds.
The type is string.

Statistics Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Statistics Server Name

The name of the SQL server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Statistics Value

The attribute value. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Time Stamp

The timestamp that indicates the date and time the product collected the sample for the SQL server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Component: msSqlTableSummary

The MS SQL Table Summary data set provides the summary of all the tables that are present in an SQL Server instance. Note that empty tables are not monitored. If the table detail collection settings are configured for the SQL Server agent, the attributes in this data set display the last collected value of data. The following section lists the metrics and dimensions of Component msSqlTableSummary.

Metrics

The following metrics are available for the component.

Table Summary Last Collection Duration (Min.)

The time (in minutes) that is required to collect data of the MS SQL Table Detail data set. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is minutes.

Table Summary Maximum Fragmentation Percent

The highest fragmentation value (in a percent) among all the tables in the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Table Summary Maximum Fragmentation Percent Since Startup

The highest value of fragmentation (in a percent) among all tables since the agent was started. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Table Summary Maximum Optimizer Statistics Age (Min.)

The maximum age of the optimizer statistics in minutes among all the tables in the current instance of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minutes.

Table Summary Maximum Table Size (MB)

The maximum space in MB that is used among all the tables in the current instance of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Table Summary Minimum Fragmentation Percent

The lowest value of fragmentation (in a percent) among all the tables in the current interval. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Table Summary Minimum Optimizer Statistics Age (Min.)

The minimum age of the optimizer statistic in minutes among all the tables in the current instance of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is minutes.

Table Summary Minimum Table Size (MB)

The minimum space in MB that is used among all the tables of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Dimensions

The following dimensions are available for the component.

Table Summary Last Collection Start Time

The date and time when data collection of the MS SQL Table Detail data set last started. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Table Summary Table Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, it is available for reports and queries. This is available for thresholds, but not in the UI.
The type is timestamp.

Table Summary Table Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Table Summary Table Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Table Summary Table Server Name

The name of the SQL Server. The value format is an alphanumeric string with a maximum of 32 characters. This is available for thresholds, but not in the UI.
The type is string.

Table Summary Total FileTables

The total number of FileTables that are present in the current instance of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Table Summary Total Tables

The total number of tables that are present in the current instance of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.

Component: msSqlWorkloadGroupStats

The MS SQL Workload Group Stats data set provides statistics associated with workload groups. This data set is not supported on the SQL Server 2005 and 2008 Express Edition. The following section lists the metrics and dimensions of Component msSqlWorkloadGroupStats.

Metrics

The following metrics are available for the component.

Workload Group Active Parallel Threads

The number of threads used by parallel queries in the workload group. Serial queries and the main thread of parallel queries are not included in this number. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is threads.

Workload Group Active Requests

The number of requests currently running in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is requests.

Workload Group Blocked Tasks

The number of blocked tasks in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is tasks.

Workload Group CPU Usage Pct

The system CPU usage by all requests in the specified instance of the performance object. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is percent.

Workload Group Max Requests Cpu Time(ms)

The maximum requests for CPU time in milliseconds. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is milliseconds.

Workload Group Max Requests Memory Grant(MB)

The maximum value of memory grant in megabytes used by a query in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is megabytes.

Workload Group Query Optimization Per Sec

The number of query optimizations per second occurring in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Workload Group Queued Requests

The number of requests waiting in the queue due to resource governor limits in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is requests.

Workload Group Reduced Memory Grants Per Sec

The number of queries reduced per second from the memory in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Workload Group Requests Completed Per Sec

The number of completed requests per second in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is requests/second.

Workload Group Suboptimal Plans Per Sec

The number of suboptimal query plans generated per second in the workload group. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is plans/second.

Dimensions

The following dimensions are available for the component.

Workload Group Host Name

The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in eventing thresholds or for historical data collection. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Workload Group Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Workload Group Name (Unicode)

The name of the workload group. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Workload Group Node

The key to this table of the format serverid:hostname:MSS. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Workload Group Sample Timestamp

The time when data is collected. The format is an integer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Workload Group Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Component: serverAnalysis

Information about the SQL Server Analysis Services. The following section lists the metrics and dimensions of Component serverAnalysis.

Metrics

The following metrics are available for the component.

Server Analysis Aggregate Cache (KB)

The amount of memory that is currently allocated to the file cache. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Aggregation Hits Per Sec

The rate of aggregation hits. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is hits/second.

Server Analysis Aggregation Lookups Per Sec

The rate of aggregation lookups. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is lookups/second.

Server Analysis Aggregation Map Files

The current number of aggregation map files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Average Time Per Query

The average time in milliseconds that is taken to respond to each query that was answered since the last counter measurement. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is milliseconds.

Server Analysis Bytes Sent Per Sec

The number of bytes that are currently sent by the server to the clients per second in response to queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Server Analysis Calculation Cache Hits Per Sec

The number of calculation hits per second. The calculation cache includes global, session, and query scope calculation caches. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is hits/second.

Server Analysis Calculation Cache Lookups Per Sec

The number of calculation cache lookups per second. The calculation cache includes global, session, and query scope calculation caches. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is lookups/second.

Server Analysis Cases Per sec

The rate at which cases are currently processed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is cases/second.

Server Analysis Cleaner Balance Per Sec

The rate at which balance and shrink operations are performed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is balances/sec.

Server Analysis Cleaner Current Price

The current price of memory in dollars per byte and per unit of time. This price is normalized to 1000. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is dollars/byte.

Server Analysis Cleaner Memory (KB)

The sum of shrinkable memory and the amount of non-shrinkable memory that is currently known to the background cleaner. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Cleaner Memory nonshrinkable (KB)

The amount of memory that cannot be purged by the background cleaner. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Cleaner Memory shrinkable (KB)

The amount of memory that can be purged by the background cleaner. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Cleaner Memory Shrunk KB Per Sec

The rate at which the cleaner memory is shrunk. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis Concurrent Data Mining Queries

The number of data mining queries that are currently being processed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Current Cached Evaluation Nodes

The approximate number of cached evaluation nodes that are currently built by the MDX execution plans. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Current Dimension Queries

The number of dimension queries that are currently being processed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Current Evaluation Nodes

The approximate number of evaluation nodes that are currently built by the MDX execution plans. This number includes active evaluation nodes and cached evaluation nodes. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Current Measure Group Queries

The number of measure group queries that are currently being worked on. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Current Models Processing

The number of SQL Server Analysis Services Data Mining models that are currently being processed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is models.

Server Analysis Current Pyramid Operations

The number of pyramid operations that are currently in progress. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is operations.

Server Analysis Data Bytes Per Sec

The number of bytes that are currently read per second from the data file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Server Analysis Data Reads Per Sec

The number of logical read operations that are currently using the data file per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is reads/second.

Server Analysis Dimension Cache Hits Per Sec

The number of dimension cache hits per second. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is hits/second.

Server Analysis Dimension Cache Lookups Per Sec

The rate of dimension cache lookups. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is lookups/second.

Server Analysis Dimension Index(hash) Files

The current number of dimension index (hash) files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is indices.

Server Analysis Dimension Property Files

The current number of dimension property files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Dimension Queries Per Sec

The rate at which dimension queries are processed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Server Analysis Dimension String Files

The current number of dimension string files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Fact Aggregation Files

The current number of fact aggregation files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Fact Data Files

The current number of fact data files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Fact String Files

The current number of fact string files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Filestore (KB)

The amount of memory that is currently allocated to the filestore. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Filestore Clock Pages Examined Per Sec

The rate at which the background cleaner examines the filestore clock pages and considers the pages for eviction. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is pages/second.

Server Analysis Filestore Clock Pages HaveRef Per Sec

The rate at which the background cleaner examines the filestore clock pages that have a reference number because they are currently used. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is pages/second.

Server Analysis Filestore Clock Pages Valid Per Sec

The rate at which the background cleaner examines the filestore clock pages that are valid for eviction. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is pages/second.

Server Analysis Filestore KB Reads Per Sec

The rate at which filestore operations are read. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis Filestore KB Writes Per Sec

The rate at which filestore operations are written. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis Filestore Memory Pinned (KB)

The amount of filestore memory that is currently pinned. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes.

Server Analysis Filestore Page Faults Per Sec

The rate at which filestore page faults are generated. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is faults/second.

Server Analysis Filestore Reads Per Sec

The rate at which filestore pages are read. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is reads/second.

Server Analysis Filestore Writes Per Sec

The rate at which filestore pages are written. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is writes/second.

Server Analysis Filter Rows Excluded Per Sec

The number of rows that are excluded per second in the last query that was processed. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Filter Rows Included Per Sec

The number of rows that are included per second in the last query that was processed. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Filtered Rows Per Sec

The rate at which rows are currently filtered. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Flat Cache Hits Per Sec

The rate of flat cache hits. The flat cache includes global, session, and query scope flat caches. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is hits/second.

Server Analysis Flat Cache Lookups Per Sec

The rate of flat cache lookups. The flat cache includes global, session, and query scope flat caches. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is lookups/second.

Server Analysis In Memory Aggregation Map File (KB)

The current size of the in-memory aggregation map file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Aggregation Map File KB Per Sec

The rate at which write operations occur in the in-memory aggregation map file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory Dimension Index(hash) File (KB)

The current size of the in-memory dimension index (hash) file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Dimension Index(hash) File KB Per Sec

The rate at which write operations occur in the in-memory dimension index (hash) file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory Fact Aggregation File (KB)

The current size of the in-memory fact aggregation file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Fact Aggregation File KB Per Sec

The rate at which write operations occur in the in-memory fact aggregation file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory Fact Data File (KB)

The current size of the in-memory fact data file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Fact Data File KB Per Sec

The rate at which write operations occur in the in-memory fact data file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory Fact String File (KB)

The current size of the in-memory fact string file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Fact String File (KB) Per Sec

The rate at which write operations occur in the in-memory fact string file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory Map File (KB)

The current size of the in-memory map file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Map File (KB) Per Sec

The rate at which write operations occur in the in-memory map file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory Other File (KB)

The current size of the in-memory other file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Other File (KB) Per Sec

The rate at which write operations occur in the in-memory other file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory Property File (KB)

The current size of the in-memory property file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory Property File KB Per Sec

The rate at which write operations occur in the in-memory property file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis In Memory String File (KB)

The current size of the in-memory string file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis In Memory String File KB Per Sec

The rate at which write operations occur in the in-memory string file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is kilobytes/second.

Server Analysis Index Bytes Per Sec

The number of bytes that are currently read from the index files per second. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Server Analysis Index Reads Per Sec

The number of logical read operations that are currently using the index files per second. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is reads/second.

Server Analysis Map Bytes Per Sec

The number of bytes that are currently read from the map file per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is bytes/second.

Server Analysis Map Files

The current number of map files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Map Reads Per Sec

The number of logical read operations that are currently using the map file per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is reads/second.

Server Analysis Measure Group Cache Hits Per Sec

The rate of group cache hits. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is hits/second.

Server Analysis Measure Group Lookups Per Sec

The rate of measure group cache lookups. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is lookups/second.

Server Analysis Measure Group Queries Per Sec

The rate of measure group queries that are sent to the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Server Analysis Memory Limit High (KB)

The highest memory limit that is specified in the configuration file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Memory Limit Low (KB)

The lowest memory limit that is specified in the configuration file. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Memory Usage (KB)

The amount of memory that is used by the server to calculate the cleaner memory price. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Network Round Trips Per Sec

The rate of network round trips. The network round trips include all communication between the client and the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is trips/second.

Server Analysis Other Files

The current number of other files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is files.

Server Analysis Page Pool 1 Alloc (KB)

The amount of memory that is borrowed from the 64 KB page pool. This memory is distributed to other parts of the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Page Pool 1 Lookaside (KB)

The amount of memory that is currently available in the 1 KB lookaside list. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Page Pool 64 Alloc (KB)

The amount of memory that is borrowed from the system. This memory is distributed to other parts of the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Page Pool 64 Lookaside (KB)

The amount of memory that is currently available in the 64 KB lookaside list. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Page Pool 8 Alloc (KB)

The amount of memory that is currently borrowed from the 64 KB page pool. The memory is distributed to other parts of the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Page Pool 8 Lookaside (KB)

The amount of memory that is currently available in the 8 KB lookaside list. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Persisted Cache Hits Per Sec

The rate of persisted cache hits. Persisted caches are created by the MDX script cache statement. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is hits/second.

Server Analysis Persisted Cache Lookups Per Sec

The rate of persisted cache lookups. Persisted caches are created by the MDX script cache statement. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is lookups/second.

Server Analysis Potential In-memory Aggregation Map File (KB)

The potential size of the in-memory aggregation map files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Dimension Index (Hash) File (KB)

The potential size of the in-memory dimension index (hash) files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Dimension Property File (KB)

The potential size of the in-memory dimension property files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Dimension String File (KB)

The potential size of the in-memory dimension string files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Fact Aggregation File (KB)

The potential size of the in-memory fact aggregation files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Fact Data File (KB)

The potential size of the in-memory fact data files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Fact String File (KB)

The potential size of the in-memory fact string files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Map File (KB)

The potential size of the in-memory map files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Potential In-memory Other File (KB)

The potential size of the in-memory other files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Predictions Per Sec

The rate at which predictions that are generated in data mining queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is predictions.

Server Analysis Pyramid Operations Per Sec

The rate at which pyramid operations are currently started. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is operations/second.

Server Analysis Queries Answered Per Sec

The rate at which queries are currently answered. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Server Analysis Queries From Cache Direct Per Sec

The rate at which queries are answered directly from the cache. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Server Analysis Queries From Cache Filtered Per Sec

The rate at which queries are answered by filtering the existing cache entry. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Server Analysis Queries From Files Per Sec

The rate at which queries are answered from files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Server Analysis Queries Per Sec

The rate at which data mining queries are generated. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is queries/second.

Server Analysis Quota (KB)

The current amount of memory quota. A memory quota is also referred to as a memory grant or memory reservation. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is kilobytes.

Server Analysis Quota Blocked

The number of requests for memory quota that are currently blocked until some memory quotas are freed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is requests.

Server Analysis Row Processing Rows Read Per Sec

The rate at which rows are read from all the relational databases per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is databases/second.

Server Analysis Rows Converted Per Sec

The rate at which rows are converted during processing per second. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Rows Per Sec

The number of rows that are currently processed per second for a data mining prediction query. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Rows Read Per Sec

The number of rows that are currently read by the server per second. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Rows Sent Per Sec

The rate at which rows are sent by the server to the clients. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Rows Written Per Sec

The rate at which rows are written to the database during processing. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is rows/second.

Server Analysis Total Autoexist

The number of times that the Autoexist operation is currently performed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is operations.

Server Analysis Total Bulk Mode Evaluation Nodes

The number of bulk-mode evaluation nodes that are currently built by the MDX execution plans. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Bytes Sent

The number of bytes that are currently sent by the server to the clients in response to queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is bytes.

Server Analysis Total Cached Bulk Mode Evaluation Nodes

The number of cached bulk-mode evaluation nodes that are currently built by the MDX execution plans. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Cached Other Evaluation Nodes

The number of cached evaluation nodes that are currently built by the MDX execution plans, and that are not storage engine evaluation plans or bulk-mode evaluation plans. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Cached Storage Engine Evaluation Nodes

The number of cached storage engine evaluation nodes that are currently built by the execution plans. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Calculation Cache Registered

Total number of calculation cache registered. This attribute is supported only in SQL server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is operations.

Server Analysis Total Calculations Covered

The number of evaluation nodes that are currently built by the MDX execution plans. This number includes active evaluation nodes and cached evaluation nodes. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Cell By Cell Evaluation nodes

The number of cell-by-cell evaluation nodes that are currently built by the MDX execution plans. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Cell By Cell Hits In Cache of Evaluation nodes

The number of cell-by-cell hits that currently occurred in the evaluation nodes cache. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is hits.

Server Analysis Total Cell By Cell Misses In Cache of Evaluation nodes

The number of cell-by-cell misses that currently occurred in the evaluation nodes cache. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is misses.

Server Analysis Total Cells Calculated

The number of cell properties that are currently calculated. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is properties.

Server Analysis Total Dimension Queries

The current number of dimension queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Total Evaluation Nodes Calculations at Same Granularity

The number of evaluation nodes with calculations that have identical granularity level as that of the evaluation nodes. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Evaluation Nodes Covered Single Cell

The number of evaluation nodes that are currently built by the MDX execution plans, and that covered only one cell. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Evictions Of Evaluation Nodes

The number of evaluation nodes that are currently evicted because of collisions. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total EXISTING Operators

Total number of times EXISTING set operator performed. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is operations.

Server Analysis Total Filestore IO Errors

The current number of filestore I/O errors. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is errors.

Server Analysis Total Filestore IO Errors Per Sec

The rate at which filestore I/O errors occur. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is double.
The unit is errors/second.

Server Analysis Total Flat Cache Inserts

The number of cell values that are currently inserted into the flat calculation cache. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is inserts.

Server Analysis Total Hash Index Hits In Cache Of Evaluation Nodes

The number of hits in the evaluation nodes cache that are currently satisfied by the hash index. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is hits.

Server Analysis Total Measure Group Queries

The current number of measure group queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Total Network Round Trips

The current number of network round trips. The network round trips include all communication between the client and the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is trips.

Server Analysis Total Nonempty Algorithms

The number of times a NonEmpty algorithm is currently used. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is algorithms.

Server Analysis Total Nonempty Algorithms For Calculated Members

The number of times that the NonEmpty algorithm currently looped through the calculated members. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is members.

Server Analysis Total Nonempty Unoptimized Algorithms

The number of times that a NonEmpty algorithm that is not optimized is currently used. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is algorithms.

Server Analysis Total Predictions

The number of data mining prediction queries that are currently received by the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is predictions.

Server Analysis Total Pyramid Operations

The current number of pyramid operations. This attribute is supported only on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is operations.

Server Analysis Total Queries

The number of data mining queries that are currently received by the server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Total Queries Answered

The current number of queries that are answered. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Total Queries From Cache Direct

The number of queries that are currently derived from the cache for every partition. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Total Queries From Cache Filtered

The number of queries that are currently answered by filtering the existing cache entries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Total Queries From File

The number of queries that are currently answered from files. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is queries.

Server Analysis Total Recomputes

The number of cells that are currently computed again because of an error. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is cells.

Server Analysis Total Rows

The number of rows that are currently returned by data mining queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Server Analysis Total Rows Converted

The number of rows that are currently converted during processing. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Server Analysis Total Rows Read

The number of rows that are currently read from all the relational databases. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Server Analysis Total Rows Sent

The number of rows that are currently sent by the server to the clients. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Server Analysis Total Rows Written

The number of rows that are currently written to the database during processing. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is rows.

Server Analysis Total Sonar Subcubes

The number of subcubes that are currently generated by the query optimizer. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is subcubes.

Server Analysis Total Storage Engine Evaluation Nodes

Total number of Storage Engine evaluation nodes built by MDX execution plans. This attribute is not supported in SQL server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is nodes.

Server Analysis Total Subcube Hits In Cache Of Evaluation Nodes

The number of subcube hits that are currently present in the evaluation nodes cache. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is hits.

Server Analysis Total Subcube Misses In Cache Of Evaluation Nodes

The number of subcube misses that are currently present in the evaluation nodes cache. This attribute is not supported on SQL Server 2005. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is int.
The unit is misses.

Dimensions

The following dimensions are available for the component.

Server Analysis Data Mining Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Server Analysis Data Mining Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis Data Mining Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Server Analysis Data Mining Server Name

The name of the SQL Server. The value format is an alphanumeric string with a maximum of 30 characters. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis MDX Processing Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Server Analysis MDX Processing Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis MDX Processing Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Server Analysis MDX Processing Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis Memory Statistics Hub Timestamp

The time when this data was inserted at the hub. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, it is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Server Analysis Memory Statistics Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis Memory Statistics Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Server Analysis Memory Statistics Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis Row Processing Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Server Analysis Row Processing Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis Rows Processing Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Server Analysis Rows Processing Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis Storage Engine Query Hub Timestamp

The time when data is inserted at the hub. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is timestamp.

Server Analysis Storage Engine Query Node

The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in eventing thresholds. Otherwise, this attribute is available to use like any other attribute. For example, this attribute is available for reports and queries. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.

Server Analysis Storage Engine Query Row Number

The row number in sample. This is available for thresholds, but not in the UI.
The type is int.

Server Analysis Storage Engine Query Server Name

The name of the SQL Server. This is not available in the UI by default. It can be made available through dynamic configuration.
The type is string.