MSSQL
Introduction
MSSQL O11ySource is a comprehensive solution designed to provide visibility, analysis, and actionable insights into the performance, behavior, and health of your MSSQL server infrastructure. It encompasses a systematic approach to gather, monitor, and interpret metrics, logs, and key indicators from MSSQL servers, enabling deep visibility into server operations
Getting Started
Compatibility
This MSSQL O11ySource is compatible with MSSQL Version 2012 and above.
Data Collection Method
MSSQL Performance metrics are collected using an internal data collector. It uses a JDBC connection to fetch all the required metrics periodically.
Prerequisites
Dependent Configuration
To configure this O11ySource, create a 'credential' of type 'user' under the 'Definition' tab.
Inputs for Configuring Data Source
- Instance Name: Please enter the name of the MSSQL instance. This should be a unique identifier for the specific MSSQL deployment you want to monitor.
- DB Details: Please provide the details of DB
- IP Address: IP address needs to be a valid IP Address.
- Port: Enter a valid port
- Credential: This field is required
- Metrics Collection Queries: These queries are utilized for MSSQL server's metrics.
- Query: Choose the Queries
- Polling Interval [seconds]: How frequently data is gathered. interval should be between 180 -.86400 seconds
Firewall Requirement
To collect data from this O11ySource, ensure the following ports are opened:
| Source IP | Destination IP | Destination Port | Protocol | Direction |
|---|---|---|---|---|
| vuSmartMaps IP | IP address of the MSSQL server | 1433* | TCP | Inbound |
*Before providing the firewall requirements, please update the port based on the customer environment.
Configuring the Target
- Create a login on every SQL Server instance you want to monitor and create a read-only
vunetuser with proper access to your MSSQL server. - Start MSSQL, login to MSSQL database and run:
USE master;
GO
CREATE LOGIN vunet WITH PASSWORD = '[password]';
GO
CREATE USER vunet FOR LOGIN vunet;
GO
GRANT SELECT on sys.master_files to vunet;
GO
GRANT SELECT on sys.dm_os_performance_counters to vunet;
GO
GRANT VIEW SERVER STATE to vunet;
GO
GRANT VIEW ANY DEFINITION to vunet;
GO
GRANT CONNECT ANY DATABASE to vunet;
GO
USE msdb;
GO
CREATE USER vunet FOR LOGIN vunet;
GO
GRANT SELECT on msdb.dbo.sysjobhistory to vunet;
GO
GRANT SELECT on msdb.dbo.sysjobschedules to vunet;
GO
GRANT SELECT on msdb.dbo.sysjobs to vunet;
GO
Configuration Steps
Enablethe MSSQL O11ySource.- Select the Sources tab and press the
+button to add MSSQL instance that has to be monitored. - Set up metrics collection configurations. The O11ySource already provides predefined metric collection queries. Users have the flexibility to adjust query intervals, modify existing queries, and introduce new queries as needed.
- Once all the required details are filled, click on
Save and Continue
Metrics Collected
| Name | Description | Data Type |
|---|---|---|
| member_name | The name of the member in the cluster or system. | String |
| member_type_desc | A description of the type of the member, such as primary or secondary. | String |
| member_state_desc | The state of the member in a low cardinality string for efficiency. | LowCardinality(String) |
| number_of_quorum_votes | The number of votes this member has in the quorum. | UInt64 |
| query_type | The type of query being executed. | String |
| cluster_name | The name of the cluster to which the member belongs. | String |
| quorum_type_desc | A description of the quorum type, such as majority or node quorum. | String |
| quorum_state_desc | The state of the quorum, such as online or offline. | String |
| nodename | The name of the node in the system or cluster. | String |
| nodestatus | The status of the node, such as running or stopped, in low cardinality format. | LowCardinality(String) |
| currentlyactivenode | The identifier or count indicating the active node in the system. | UInt64 |
| timestamp | The exact time when the data point was collected. | Datetime64 |
| @timestamp | A string representation of the timestamp, often used for logging. | String |
| source_id | The unique identifier for the source of the data. | String |
| target | The target server or service for the data or query. | String |
| src_host | The source host of the query or data, stored as a low-cardinality string. | LowCardinality(String) |
| src_instance | The source instance of the query or data in low cardinality format. | LowCardinality(String) |
| tenant_id | The identifier of the tenant or organization. | UInt8 |
| bu_id | The business unit identifier. | UInt8 |
| name | The name associated with the metric or entity in low cardinality format. | LowCardinality(String) |
| sql_instance | The name of the SQL instance associated with the data. | String |
| measurement | The type of measurement being recorded (e.g., CPU, memory). | LowCardinality(String) |
| server_name | The server name where the SQL instance is running. | String |
| metrics_group | The grouping of related metrics, stored efficiently in low cardinality format. | LowCardinality(String) |
| group_name | The name of the group to which the entity or data belongs. | String |
| primary_instance | The name of the primary instance in the failover cluster. | String |
| primary_instance_health | The health status of the primary instance. | String |
| secondary_instance_health | The health status of the secondary instance. | String |
| availability_group_state | The state of the availability group (e.g., healthy, disconnected). | String |
| cluster_type_desc | A description of the cluster type (e.g., failover, load balancing). | String |
| sql_version | The version of SQL Server running on the instance. | String |
| instance_type | The type of instance (e.g., standalone, clustered). | String |
| is_hadr_enabled | Indicates whether high availability and disaster recovery (HADR) is enabled. | String |
| sqlserver_start_time | The timestamp when the SQL Server instance was started. | String |
| uptime_sec | The total uptime in seconds for the SQL Server instance. | String |
| host | The host name of the server where the SQL instance or data is located. | String |
| other_process_cpu | CPU utilization percentage by other processes on the system. | UInt16 |
| sqlserver_process_cpu | CPU utilization percentage by the SQL Server process. | UInt16 |
| system_idle_cpu | CPU idle percentage, indicating how much of the system's CPU is free. | UInt16 |
| host | Name or identifier of the host machine. | LowCardinality(String) |
| measurement | Metric category or type of measurement. | LowCardinality(String) |
| tenant_id | Identifier for the tenant, useful for multi-tenant systems. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or process being measured. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance. | LowCardinality(String) |
| src_host | Source host name or IP address from where the data is coming. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp. | String |
| source_id | Unique identifier of the source system or process. | String |
| target | Target system or entity to which the data or request is directed. | String |
| server_name | Server Name of the host | String |
| available_space_bytes | Available space in bytes on the disk or volume. | UInt64 |
| server_name | Name of the server hosting the SQL instance or application. | LowCardinality(String) |
| total_space_bytes | Total disk or volume space in bytes. | UInt64 |
| used_space_bytes | Used space in bytes on the disk or volume. | UInt64 |
| host | Name or identifier of the host machine. | LowCardinality(String) |
| measurement | Category or type of metric measurement. | LowCardinality(String) |
| tenant_id | Identifier for the tenant in multi-tenant systems. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or system being measured. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance. | LowCardinality(String) |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp. | String |
| source_id | Unique identifier of the source system or process. | String |
| target | Target system or entity for the data or action. | String |
| volume_mount_point | Mount point of the volume where the database or data resides. | String |
| database_name | Name of the database being monitored. | String |
| sql_instance | Name of the SQL Server instance. | String |
| database_id | Unique identifier for the database. | UInt8 |
| database_name | Name of the database. | String |
| replica_id | Unique identifier for the replica in a high availability setup. | String |
| replica_server_name | Name of the server hosting the replica database. | String |
| group_database_id | Identifier for the group that the database belongs to. | String |
| synchronization_state | Current state of synchronization (e.g., synchronized, not synchronized). | UInt8 |
| synchronization_state_desc | Description of the synchronization state. | String |
| is_commit_participant | Indicator if the database is a participant in the commit process. | UInt8 |
| synchronization_health | Health status of the synchronization process. | UInt8 |
| synchronization_health_desc | Description of the synchronization health status. | String |
| database_state | Current state of the database (e.g., online, offline). | UInt8 |
| database_state_desc | Description of the database state. | String |
| is_suspended | Indicator if the database is suspended (1 = suspended, 0 = active). | UInt8 |
| suspend_reason | Reason for the suspension of the database. | String |
| suspend_reason_desc | Description of the suspension reason. | String |
| last_sent_time | Timestamp of the last log send time. | String |
| last_received_time | Timestamp of the last log received time. | String |
| last_hardened_time | Timestamp when the log was last hardened. | String |
| last_redone_time | Timestamp of the last redo operation. | String |
| log_send_queue_size | Size of the log send queue in bytes. | UInt64 |
| log_send_rate | Rate of log sending (bytes per second). | Float64 |
| redo_queue_size | Size of the redo queue in bytes. | UInt64 |
| redo_rate | Rate of redo operations (bytes per second). | Float64 |
| filestream_send_rate | Rate of filestream data being sent. | Float64 |
| last_commit_time | Timestamp of the last commit operation. | String |
| is_primary_replica | Indicator if the replica is the primary (1 = primary, 0 = secondary). | UInt8 |
| secondary_lag_seconds | Lag time in seconds of the secondary replica compared to the primary. | UInt32 |
| source_id | Unique identifier for the source system or process. | String |
| target | Target system or entity for the data or action. | String |
| tenant_id | Identifier for the tenant in multi-tenant systems. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or system being measured. | LowCardinality(String) |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp. | String |
| measurement | Category or type of metric measurement. | String |
| server_name | Name of the server hosting the database. | String |
| group_name | Name of the group that the database is part of. | String |
| host | Name or identifier of the host machine. | String |
| counter | Name of the performance counter being measured. | LowCardinality(String) |
| counter_type | Type of the performance counter (e.g., gauge, rate). | LowCardinality(String) |
| instance | Instance of the performance counter (e.g., specific database or server instance). | LowCardinality(String) |
| object | Object to which the performance counter belongs (e.g., SQL Server, application). | LowCardinality(String) |
| value | Value of the performance counter at the recorded timestamp. | Float64 |
| host | Name or identifier of the host machine where the data was collected. | LowCardinality(String) |
| measurement | Category or type of metric measurement. | LowCardinality(String) |
| tenant_id | Identifier for the tenant in multi-tenant systems. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or system being measured. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance. | LowCardinality(String) |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp. | String |
| source_id | Unique identifier for the source system or process. | String |
| target | Target system or entity for the data or action. | String |
| server_name | Name of the server hosting the performance counter. | String |
| max_wait_time_ms | Maximum wait time in milliseconds for a specific resource. | UInt32 |
| resource_wait_ms | Total time in milliseconds that the resource has been waiting. | UInt32 |
| signal_wait_time_ms | Time in milliseconds spent waiting for a signal to proceed. | UInt32 |
| wait_category | Category of the wait event (e.g., I/O waits, lock waits). | LowCardinality(String) |
| wait_time_ms | Total wait time in milliseconds for a specific event. | UInt32 |
| wait_type | Type of wait event (e.g., latch, lock, IO, etc.). | LowCardinality(String) |
| waiting_tasks_count | Number of tasks currently waiting for the resource. | UInt32 |
| host | Name or identifier of the host machine where the SQL instance is running. | LowCardinality(String) |
| measurement | Category or type of metric measurement being recorded. | LowCardinality(String) |
| tenant_id | Identifier for the tenant in multi-tenant systems. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or system being measured. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance. | LowCardinality(String) |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp for easier parsing and handling. | String |
| source_id | Unique identifier for the source system or process. | String |
| target | Target system or entity for the data or action. | String |
| server_name | Name of the server for reference in monitoring or reporting. | String |
| sql_instance | Name of the SQL Server instance. | String |
| replica_id | Unique identifier for the replica in a high availability setup. | String |
| replica_server_name | Name of the server hosting the replica database. | String |
| group_id | Unique identifier for the availability group. | String |
| group_name | Name of the availability group. | String |
| ag_synchronization_health_desc | Description of the availability group's synchronization health. | String |
| replica_metadata_id | Unique identifier for the replica metadata. | UInt32 |
| availability_mode | Mode of availability (e.g., synchronous, asynchronous). | UInt8 |
| availability_mode_desc | Description of the availability mode. | String |
| failover_mode | Mode of failover (e.g., automatic, manual). | UInt8 |
| failover_mode_desc | Description of the failover mode. | String |
| session_timeout | Timeout duration for a session in milliseconds. | UInt64 |
| primary_role_allow_connections | Indicates if connections are allowed in the primary role. | UInt64 |
| primary_role_allow_connections_desc | Description of the primary role connection allowance. | String |
| secondary_role_allow_connections | Indicates if connections are allowed in the secondary role. | UInt64 |
| secondary_role_allow_connections_desc | Description of the secondary role connection allowance. | String |
| is_local | Indicator if the replica is local (1 = local, 0 = remote). | UInt8 |
| role | Role of the replica (e.g., primary, secondary). | UInt16 |
| role_desc | Description of the replica's role. | String |
| operational_state | Current operational state of the replica. | UInt16 |
| operational_state_desc | Description of the operational state. | String |
| connected_state | Current connected state of the replica. | UInt16 |
| connected_state_desc | Description of the connected state. | String |
| recovery_health | Health status of the recovery process. | UInt16 |
| recovery_health_desc | Description of the recovery health status. | String |
| replica_synchronization_health | Health status of the replica's synchronization process. | UInt16 |
| replica_synchronization_health_desc | Description of the replica synchronization health status. | String |
| last_connect_error_number | Error number of the last connection failure. | UInt64 |
| last_connect_error_description | Description of the last connection error. | String |
| last_connect_error_timestamp | Timestamp of the last connection error. | UInt64 |
| basic_features | Basic feature set available for the replica. | UInt16 |
| is_distributed | Indicator if the replica is part of a distributed availability group (1 = yes, 0 = no). | UInt8 |
| seeding_mode | Mode used for data seeding to the replica. | UInt16 |
| seeding_mode_desc | Description of the seeding mode. | String |
| source_id | Unique identifier for the source system or process. | String |
| target | Target system or entity for the data or action. | String |
| tenant_id | Identifier for the tenant in multi-tenant systems. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or system being measured. | LowCardinality(String) |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp. | String |
| measurement | Category or type of metric measurement. | String |
| server_name | Name of the server hosting the replica. | String |
| host | Name or identifier of the host machine. | String |
| ForceEncryption | Indicates whether SSL encryption is enforced for connections (1 = Yes, 0 = No). | UInt8 |
| PortType | Type of port used for SQL Server (e.g., default, named). | LowCardinality(String) |
| available_server_memory | Amount of memory available to the SQL Server instance, measured in bytes. | UInt32 |
| cpu_count | Number of CPUs available to the SQL Server instance. | UInt16 |
| db_offline | Count of databases that are currently offline. | UInt16 |
| db_online | Count of databases that are currently online. | UInt16 |
| db_recovering | Count of databases that are in the recovering state. | UInt16 |
| db_recoveryPending | Count of databases that are in a recovery pending state. | UInt16 |
| db_restoring | Count of databases that are currently restoring. | UInt16 |
| db_suspect | Count of databases that are in a suspect state. | UInt16 |
| engine_edition | Edition of the SQL Server engine (e.g., Standard, Enterprise). | UInt16 |
| hardware_type | Type of hardware on which the SQL Server is running (e.g., Virtual, Physical). | String |
| instance_type | Type of SQL Server instance (e.g., standalone, cluster). | UInt16 |
| server_memory | Total memory allocated to the SQL Server instance, measured in bytes. | UInt32 |
| service_name | Name of the SQL Server service. | LowCardinality(String) |
| sku | Stock Keeping Unit (SKU) for the SQL Server license. | LowCardinality(String) |
| sql_version | Version of the SQL Server instance (e.g., 2017, 2019). | LowCardinality(String) |
| sql_version_desc | Description of the SQL Server version. | LowCardinality(String) |
| Port | Port number on which the SQL Server instance listens for connections. | LowCardinality(String) |
| uptime | Time in seconds that the SQL Server instance has been running since the last restart. | UInt32 |
| host | Name or identifier of the host machine where the SQL Server instance is running. | LowCardinality(String) |
| measurement_db_type | Type of database measurement being recorded (e.g., transactional, analytical). | LowCardinality(String) |
| tenant_id | Identifier for the tenant in multi-tenant systems. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or system being measured. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance. | LowCardinality(String) |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp for easier parsing and handling. | String |
| source_id | Unique identifier for the source system or process. | String |
| target | Target system or entity for the data or action. | String |
| server_name | Name of the server for reference in monitoring or reporting. | String |
| connection_start_time | The start time of the database connection in milliseconds since the epoch. | UInt64 |
| cpu_time_ms | Total CPU time used by the query, measured in milliseconds. | UInt32 |
| cpu_time | Total CPU time utilized during the execution of the statement, measured in milliseconds. | UInt32 |
| exectime | Total execution time of the query in milliseconds. | UInt64 |
| executing_batch | The batch of commands currently being executed. | String |
| executing_statement | The SQL statement currently being executed. | String |
| last_request_end_time | The end time of the last request processed, in milliseconds since the epoch. | Int64 |
| last_request_start_time | The start time of the last request processed, in milliseconds since the epoch. | Int64 |
| login_name | The name of the user who logged into the database. | String |
| login_time | The time the user logged in, in milliseconds since the epoch. | Int64 |
| memory_usage_kb | Amount of memory used by the query, measured in kilobytes. | UInt32 |
| program_name | Name of the application that initiated the connection to the SQL Server. | LowCardinality(String) |
| databasename | Name of the database in which the query is executed. | LowCardinality(String) |
| query_type | Type of the query being executed (e.g., SELECT, INSERT). | LowCardinality(String) |
| last_wait_type | Type of the last wait the session experienced. | LowCardinality(String) |
| lock_timeout | Timeout period for acquiring a lock, in milliseconds. | Int16 |
| start_time | The time when the query execution started, in milliseconds since the epoch. | UInt64 |
| session_status | Status of the session (e.g., active, sleeping). | LowCardinality(String) |
| task_state | Current state of the task associated with the session. | LowCardinality(String) |
| blocking_session_id | ID of the session that is blocking the current session. | UInt16 |
| total_elapsed_time_ms | Total elapsed time for the session in milliseconds. | UInt32 |
| total_elapsed_time | Total elapsed time for the session in seconds. | UInt16 |
| wait_time | Total wait time experienced by the session, in seconds. | UInt16 |
| user_id | ID of the user executing the query. | UInt32 |
| host_name | Name of the host from which the connection originated. | LowCardinality(String) |
| host | The host name or identifier for the server. | LowCardinality(String) |
| tenant_id | Identifier for the tenant in a multi-tenant system. | UInt8 |
| bu_id | Business unit identifier. | UInt8 |
| name | Name of the metric or system being measured. | LowCardinality(String) |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | Source instance name or identifier. | LowCardinality(String) |
| timestamp | Precise timestamp when the metric was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp for easier parsing and handling. | String |
| status | Status of the session or connection. | LowCardinality(String) |
| source_id | Unique identifier for the source system or process. | String |
| target | Target system or entity for the data or action. | String |
| cpu_time_pct | Percentage of CPU time used by the query relative to total available CPU time. | Float32 |
| database_name | Name of the database being queried. | String |
| last_execution_time | Time of the last execution of the query, in milliseconds since the epoch. | UInt64 |
| statement_text | The text of the SQL statement executed. | String |
| total_worker_time_msec | Total time spent by workers executing the query, in milliseconds. | UInt64 |
| last_worker_time_msec | Time spent by the last worker executing the query, in milliseconds. | UInt64 |
| db_buffer_percent | Percentage of database buffer used. | Float32 |
| last_elapsed_time_msec | Elapsed time of the last execution, in milliseconds. | UInt64 |
| counter_name | Name of the performance counter being measured. | String |
| value | The value of the performance counter. | Float64 |
| sql_instance | Name of the SQL Server instance. | LowCardinality(String) |
| cntr_type | Type of the counter being measured. | UInt64 |
| total_cost | Total cost of executing the query, measured in some cost units (e.g., CPU cycles). | Float64 |
| equality_columns | Columns used for equality predicates in the query. | String |
| table_name | Name of the table being queried. | String |
| included_columns | Columns included in the query that are not part of the primary key. | String |
| inequality_columns | Columns used for inequality predicates in the query. | String |
| last_data_timestamp | Timestamp of the last data modification or access, in string format. | String |
| command | Command or operation being executed. | String |
| session_id | Unique identifier for the session. | UInt16 |
| logical_reads | Number of logical reads performed by the query. | UInt16 |
| reads | Total number of reads performed by the query. | UInt16 |
| transaction_isolation_level | Level of transaction isolation used by the query (e.g., Read Uncommitted, Serializable). | UInt16 |
| wait_resource | Resource on which the session is currently waiting. | String |
| writes | Total number of writes performed by the query. | UInt16 |
| db_buffer_MB | Amount of memory allocated to the database buffer, measured in megabytes. | String |
| db_buffer_bytes | Amount of memory allocated to the database buffer, measured in bytes. | String |
| db_buffer_pages | Number of pages in the database buffer. | UInt16 |
| total_buffer | Total buffer size available to the SQL Server instance. | UInt16 |
| avg_elapsed_time_usec | Average elapsed time per query execution, measured in microseconds. | UInt32 |
| creation_time | Time when the query or object was created, in milliseconds since the epoch. | UInt64 |
| execution_count | Total number of times the query has been executed. | UInt32 |
| last_elapsed_time | Elapsed time of the last execution, in milliseconds. | UInt32 |
| last_elapsed_time_sec | Last elapsed time of execution in seconds. | UInt16 |
| last_logical_reads | Number of logical reads performed in the last execution. | UInt16 |
| last_logical_writes | Number of logical writes performed in the last execution. | UInt16 |
| last_physical_reads | Number of physical reads performed in the last execution. | UInt16 |
| last_worker_time | Time spent by the last worker in milliseconds. | UInt16 |
| last_worker_time_sec | Last worker time in seconds. | UInt16 |
| max_physical_reads | Maximum number of physical reads during execution. | UInt16 |
| max_worker_time_msec | Maximum worker time during execution, measured in milliseconds. | UInt16 |
| min_physical_reads | Minimum number of physical reads during the query execution. | UInt16 |
| min_worker_time_msec | Minimum worker time spent during execution, measured in milliseconds. | UInt16 |
| sql_handle | Unique identifier for the SQL query execution context. | String |
| total_elapsed_time_msec | Total elapsed time for the query execution, measured in milliseconds. | UInt64 |
| total_elapsed_time_sec | Total elapsed time for the query execution, measured in seconds. | UInt32 |
| total_elapsed_time_usec | Total elapsed time for the query execution, measured in microseconds. | UInt64 |
| total_logical_reads | Total number of logical reads performed by the query execution. | UInt16 |
| total_logical_writes | Total number of logical writes performed by the query execution. | UInt16 |
| total_physical_reads | Total number of physical reads performed by the query execution. | UInt16 |
| total_worker_time_sec | Total time spent by workers executing the query, measured in seconds. | UInt16 |
| total_worker_time_usec | Total time spent by workers executing the query, measured in microseconds. | UInt64 |
| avg_cpu_time_msec | Average CPU time used by the query execution, measured in milliseconds. | UInt64 |
| avg_elapsed_time_msec | Average elapsed time for the query execution, measured in milliseconds. | UInt64 |
| NextRunDateTime | Timestamp for the next scheduled execution of a job, in milliseconds since the epoch. | UInt64 |
| LastRunStatusMessage | Status message from the last execution of a job. | String |
| LastRunDuration | Duration of the last job execution, in milliseconds. | UInt64 |
| LastRunStatus | Status of the last job execution (e.g., Success, Failed). | String |
| LastRunDateTime | Timestamp of the last job execution, in milliseconds since the epoch. | UInt64 |
| JobName | Name of the SQL Server job associated with the metrics. | String |
| JobID | Unique identifier for the SQL Server job. | String |
| metrics_group | Grouping or categorization for the metrics collected. | String |
| server_name | Name of the server hosting the SQL instance. | String |
| measurement | The type or category of the measurement being recorded. | String |
| database_name | Name of the database associated with the measurements. | LowCardinality(String) |
| file_type | Type of file (e.g., data file, log file) related to the database. | LowCardinality(String) |
| logical_filename | Logical name of the database file as defined in SQL Server. | LowCardinality(String) |
| physical_filename | Physical file name on the disk where the database file is stored. | LowCardinality(String) |
| read_bytes | Total number of bytes read from the database file. | UInt64 |
| read_latency_ms | Average latency for read operations, measured in milliseconds. | UInt32 |
| reads | Total number of read operations performed on the database file. | UInt64 |
| rg_read_stall_ms | Total time in milliseconds that read operations were stalled. | UInt32 |
| rg_write_stall_ms | Total time in milliseconds that write operations were stalled. | UInt32 |
| write_bytes | Total number of bytes written to the database file. | UInt64 |
| write_latency_ms | Average latency for write operations, measured in milliseconds. | UInt32 |
| writes | Total number of write operations performed on the database file. | UInt64 |
| host | Hostname of the server where the SQL instance is running. | LowCardinality(String) |
| measurement | Type or category of the measurement being recorded. | LowCardinality(String) |
| tenant_id | Identifier for the tenant in a multi-tenant environment. | UInt8 |
| bu_id | Identifier for the business unit associated with the measurement. | UInt8 |
| name | Name of the metric or measurement. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance. | LowCardinality(String) |
| src_host | Source hostname from which the measurement was collected. | LowCardinality(String) |
| src_instance | Source instance from which the measurement was collected. | LowCardinality(String) |
| timestamp | Timestamp when the measurement was recorded. | Datetime64 |
| @timestamp | Timestamp in a string format for the measurement record. | String |
| source_id | Identifier for the source of the measurement. | String |
| target | Target entity associated with the measurement. | String |
| server_name | Alternate name for the server hosting the SQL instance. | String |
| volume_mount_point | Mount point for the volume where the database files are stored. | String |
| database_name | Name of the database. | LowCardinality(String) |
| recovery_model | Recovery model of the database (e.g., Full, Simple, Bulk-logged). | LowCardinality(String) |
| state | Current state of the database (e.g., Online, Offline, Restoring). | LowCardinality(String) |
| host | Host name or IP address of the server where the database resides. | String |
| measurement | The type or category of the measurement being recorded. | LowCardinality(String) |
| tenant_id | Identifier for the tenant associated with the database. | UInt8 |
| bu_id | Identifier for the business unit associated with the database. | UInt8 |
| name | Name of the entity or metric associated with the database. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance hosting the database. | LowCardinality(String) |
| src_host | Source host from where the data is collected. | LowCardinality(String) |
| src_instance | Source instance from where the data is collected. | LowCardinality(String) |
| timestamp | Timestamp of when the data was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp for easier handling in certain applications. | String |
| source_id | Identifier for the data source. | String |
| target | Target system or service associated with the measurement. | String |
| database_id | Unique identifier for the database. | UInt64 |
| full_backup_size_bytes | Size of the last full backup of the database in bytes. | Float64 |
| last_full_backup_time | Timestamp of the last full backup, in milliseconds since the epoch. | UInt64 |
| last_transaction_log_backup_time | Timestamp of the last transaction log backup, in milliseconds since the epoch. | UInt64 |
| DeviceType | Type of device used for backups (e.g., Disk, Tape). | String |
| DeviceName | Name of the device used for backups. | String |
| transaction_log_backup_size_bytes | Size of the last transaction log backup in bytes. | UInt64 |
| differential_backup_size_bytes | Size of the last differential backup in bytes. | UInt64 |
| last_differential_backup_time | Timestamp of the last differential backup, in milliseconds since the epoch. | UInt64 |
| server_name | Name of the server where the database resides. | String |
| attempted_queries | The total number of queries attempted against the database. | UInt8 |
| database_name | Name of the database where the queries are executed. | LowCardinality(String) |
| database_type | Type of the database (e.g., SQL, NoSQL). | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance hosting the database. | LowCardinality(String) |
| successful_queries | The total number of queries that were successfully executed. | UInt8 |
| host | Host name or IP address of the server where the database resides. | LowCardinality(String) |
| tenant_id | Identifier for the tenant associated with the database. | UInt8 |
| bu_id | Identifier for the business unit associated with the database. | UInt8 |
| name | Name of the entity or metric associated with the queries. | LowCardinality(String) |
| src_host | Source host from where the data is collected. | LowCardinality(String) |
| src_instance | Source instance from where the data is collected. | LowCardinality(String) |
| timestamp | Timestamp of when the data was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp for easier handling in certain applications. | String |
| source_id | Identifier for the data source. | String |
| target | Target system or service associated with the measurement. | String |
| server_name | Name of the server where the database resides. | String |
| clerk_type | Type of clerk or database user performing the actions. | String |
| size_kb | Size of the object in kilobytes. | UInt64 |
| sql_instance | Name of the SQL Server instance hosting the database. | LowCardinality(String) |
| src_host | Source host from where the data is collected. | LowCardinality(String) |
| src_instance | Source instance from where the data is collected. | LowCardinality(String) |
| bu_id | Identifier for the business unit associated with the database. | UInt8 |
| tenant_id | Identifier for the tenant associated with the database. | UInt8 |
| host | Host name or IP address of the server where the database resides. | LowCardinality(String) |
| measurement | Name of the measurement being taken. | LowCardinality(String) |
| name | Name of the entity or metric associated with the clerk type. | LowCardinality(String) |
| timestamp | Timestamp of when the data was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp for easier handling in certain applications. | String |
| source_id | Identifier for the data source. | String |
| target | Target system or service associated with the measurement. | String |
| server_name | Name of the server where the database resides. | String |
| command | Command being executed (e.g., SELECT, INSERT, UPDATE). | LowCardinality(String) |
| cpu_time_ms | CPU time consumed by the query in milliseconds. | UInt32 |
| granted_query_memory_pages | Number of memory pages granted for the query execution. | UInt16 |
| logical_reads | Number of logical reads performed during query execution. | UInt16 |
| login_name | Name of the user who logged into the database. | LowCardinality(String) |
| open_transaction | Indicator of whether there are open transactions (1 for true, 0 for false). | UInt8 |
| percent_complete | Percentage of the query execution completed. | UInt8 |
| program_name | Name of the application program executing the query. | LowCardinality(String) |
| query_hash | Hash value representing the query for optimization purposes. | LowCardinality(String) |
| query_plan_hash | Hash value representing the execution plan of the query. | LowCardinality(String) |
| request_id | Unique identifier for the request within the SQL Server instance. | UInt16 |
| session_db_name | Name of the database associated with the session. | LowCardinality(String) |
| session_id | Unique identifier for the session executing the query. | UInt16 |
| blocking_session_id | ID of the session that is blocking this session. | UInt16 |
| statement_text | Text of the SQL statement being executed. | String |
| status | Current status of the session (e.g., running, waiting). | LowCardinality(String) |
| total_elapsed_time_ms | Total elapsed time for the query execution in milliseconds. | UInt32 |
| transaction_isolation_level | Isolation level of the transaction (e.g., READ COMMITTED, SERIALIZABLE). | LowCardinality(String) |
| wait_resource | Resource on which the session is waiting (if applicable). | LowCardinality(String) |
| wait_time_ms | Time the session has been waiting in milliseconds. | UInt32 |
| host_name | Name of the host from which the session is connected. | LowCardinality(String) |
| wait_type | Type of wait that the session is experiencing. | LowCardinality(String) |
| writes | Number of write operations performed by the query. | UInt64 |
| objectid | Unique identifier of the object (table, view, etc.) being accessed by the query. | Int64 |
| host | Host name or IP address of the server where the database resides. | LowCardinality(String) |
| measurement | Name of the measurement being taken. | LowCardinality(String) |
| tenant_id | Identifier for the tenant associated with the database. | UInt8 |
| bu_id | Identifier for the business unit associated with the database. | UInt8 |
| name | Name of the entity or metric associated with the session. | LowCardinality(String) |
| sql_instance | Name of the SQL Server instance hosting the database. | LowCardinality(String) |
| src_host | Source host from where the data is collected. | LowCardinality(String) |
| src_instance | Source instance from where the data is collected. | LowCardinality(String) |
| timestamp | Timestamp of when the data was recorded. | Datetime64 |
| @timestamp | String representation of the timestamp for easier handling in certain applications. | String |
| source_id | Identifier for the data source. | String |
| target | Target system or service associated with the measurement. | String |
| server_name | Name of the server where the database resides. | String |
| database_name | Name of the database associated with the session. | String |
| client_host_name | Name of the client host from which the query was executed. | String |
| nt_user_name | Windows user name of the user executing the query. | String |
| stmt_object_name | Name of the object (table, view, etc.) being accessed in the statement. | String |
| is_user_process | Indicates if the session is a user process or a system process. | String |
| blocking_or_blocked | Indicates whether the session is blocking other sessions or is being blocked. | String |
| bs_statement_text | contains a brief or truncated version of the SQL statement being executed. | String |
| port | The port number on which the service is listening for connections. | LowCardinality(String) |
| protocol | The communication protocol used, such as TCP or UDP. | LowCardinality(String) |
| response_time | The time taken to respond to a request, measured in seconds (or milliseconds), indicating service performance. | Float32 |
| result | The overall outcome of the operation (e.g., success, failure). | LowCardinality(String) |
| result_code | A code representing the result of the operation, which may indicate success, error types, or other statuses. | UInt16 |
| result_type | A description of the type of result returned (e.g., error, warning, informational). | LowCardinality(String) |
| server | The name or identifier of the server processing the request. | LowCardinality(String) |
| host | The host machine or environment where the server is located. | LowCardinality(String) |
| tenant_id | An identifier for the tenant in a multi-tenant environment, allowing segregation of data and metrics by tenant. | UInt8 |
| bu_id | An identifier for the business unit associated with the data, used for categorization or reporting. | UInt8 |
| name | A descriptive name for the measurement or event being recorded. | LowCardinality(String) |
| src_host | The hostname or IP address of the source from where the request originated. | LowCardinality(String) |
| src_instance | The specific instance from which the request is made, often useful for identifying which part of the application or service is generating traffic. | LowCardinality(String) |
| timestamp | The date and time when the record was created, typically in UTC format, providing context for when the data was collected. | Datetime64 |
| @timestamp | A string representation of the timestamp, often used for logging or integration with other systems that require a standard time format. | String |
| source_id | A unique identifier for the source of the data or event, which may correspond to a specific application or service. | String |
| target | The intended target of the operation, which could be a resource, service, or database being accessed or modified. | String |
| server_name | A repeat of ServerName, potentially allowing for different naming conventions or clarifying its usage in a specific context. | String |
| active_workers_count | Number of active workers currently executing tasks. | UInt16 |
| context_switches_count | Number of context switches that have occurred, useful for tracking CPU load and task switching. | UInt16 |
| cpu_id | The identifier of the CPU core currently in use. | LowCardinality(String) |
| current_tasks_count | The number of tasks currently being handled by the scheduler. | UInt16 |
| current_workers_count | Number of workers currently available and executing on the system. | UInt16 |
| is_idle | Indicates whether the CPU is idle (True for idle, False for active). | Bool |
| is_online | Indicates whether the CPU core or system is online and operational. | Bool |
| load_factor | A measure of the workload on the scheduler or CPU, used to determine the system's efficiency. | UInt16 |
| pending_disk_io_count | Number of pending disk input/output operations waiting to be processed. | UInt16 |
| preemptive_switches_count | Number of preemptive task switches where tasks are forcibly switched due to scheduling. | UInt16 |
| runnable_tasks_count | Number of tasks in the runnable queue waiting for CPU execution. | UInt16 |
| scheduler_id | Identifier for the scheduler managing CPU resources and tasks. | LowCardinality(String) |
| total_cpu_usage_ms | Total CPU usage time in milliseconds. | UInt32 |
| total_scheduler_delay_ms | Total delay time in the scheduler, measuring how long tasks are delayed before being processed. | UInt32 |
| work_queue_count | The number of work items waiting in the queue for execution. | UInt16 |
| yield_count | Number of times tasks have yielded or been voluntarily suspended. | UInt16 |
| host | The hostname or machine where this data is being recorded. | LowCardinality(String) |
| measurement_db_type | Type of the database or measurement category this data belongs to. | LowCardinality(String) |
| tenant_id | Identifier for the tenant in a multi-tenant environment. | UInt8 |
| bu_id | Business unit identifier for organizational tracking. | UInt8 |
| name | Descriptive name of the measurement or resource being monitored. | LowCardinality(String) |
| sql_instance | SQL Server instance that is being monitored for performance or activity. | LowCardinality(String) |
| src_host | Source host where the data is originating from. | LowCardinality(String) |
| src_instance | Source instance of the SQL Server or service generating the data. | LowCardinality(String) |
| timestamp | Timestamp of when the measurement was taken, with high precision. | Datetime64 |
| @timestamp | String representation of the timestamp, often in UTC format. | String |
| source_id | Unique identifier for the source generating this data or log. | String |
| target | Target of the data or resource being measured, could refer to a service or system component. | String |
| server_name | Another representation or naming convention for the server's name, possibly used for tracking multiple instances or roles. | String |
| measurement | The type or name of the measurement captured. | String |
| server_name | The name of the server where the data is collected. | String |
| sql_instance | The instance of the SQL server being monitored. | String |
| database_name | The name of the database where the metrics are recorded. | String |
| LogSizeMB | The total size of the transaction log in megabytes (MB). | Float64 |
| UsedLogSpaceMB | The amount of log space currently in use in megabytes (MB). | Float64 |
| UsedLogSpacePercent | The percentage of the transaction log space that is currently in use. | Float32 |
| file_name | The name of the file being monitored (e.g., log or data file). | String |
| file_type | The type of file (e.g., log file, data file, etc.). | String |
| AvgReadStallMS | The average read stall time in milliseconds (MS). | Float32 |
| AvgWriteStallMS | The average write stall time in milliseconds (MS). | Float32 |
| logdate | The date of the log entry in string format. | String |
| processinfo | Information about the process related to the log entry (e.g., process ID). | String |
| message | The actual message or log text. | String |
| @timestamp | A timestamp string for when the data was captured. | String |
| timestamp | A more precise timestamp (in milliseconds) for when the data was captured. | DateTime64 |
| target | The target or object of the measurement (e.g., table, database). | String |
| src_host | Source host name or IP address from which data originates. | LowCardinality(String) |
| src_instance | The source instance of the query or data in low cardinality format. | LowCardinality(String) |
