sys.dm_os_linux_cpu_stats (Transact-SQL)

Applies to: SQL Server 2025 (17.x) on Linux

Returns a table with detailed Linux CPU statistics, offering system-level insights beyond SQL Server, in SQL Server 2025 (17.x) Cumulative Update (CU) 1 and later versions.

Permissions

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

Remarks

This DMV provides cumulative statistics since the system started.

Values aren't limited to SQL Server activity. They reflect the entire Linux host.

For more information on interpreting Linux CPU statistics, see the proc_stat(5) manual page for your distribution.

Use this DMV with other Linux-specific DMVs for holistic monitoring:

• sys.dm_os_linux_disk_stats
• sys.dm_os_linux_net_stats
• sys.dm_os_linux_vm_stats

Usage scenarios

• Diagnose CPU saturation: Use loadavg_1min, proc_runable_cnt, and user_time_cs to identify if the system is under heavy CPU load.

• Investigate I/O waits: High iowait_time_cs or proc_ioblocked_cnt values could indicate storage bottlenecks.

• Analyze system responsiveness: Frequent context switches (csw_cnt) or interrupts (interrupt_cnt) can signal problems with system scheduling or hardware.

• Correlate SQL Server performance with system activity: Since these metrics are system-wide, they help you distinguish between SQL Server-specific and broader OS-level problems.

Examples

A. Current CPU statistics for the system

Use sys.dm_os_linux_cpu_stats to get the current CPU statistics for the system. This example is a one-time snapshot that shows common signals that operations teams frequently monitor.

SELECT GETDATE() AS sample_time,
       uptime_secs,
       loadavg_1min,
       proc_runable_cnt,
       proc_ioblocked_cnt,
       interrupt_cnt,
       csw_cnt,
       user_time_cs,
       system_time_cs,
       idle_time_cs,
       iowait_time_cs
FROM sys.dm_os_linux_cpu_stats;

B. Correlate host pressure with SQL schedulers

Run the following example query to get a host snapshot.

SELECT loadavg_1min,
       proc_runable_cnt,
       proc_ioblocked_cnt,
       interrupt_cnt,
       csw_cnt
FROM sys.dm_os_linux_cpu_stats;

The following query returns information about SQL scheduler pressure, excluding DAC and hidden schedulers.

If schedulers show high runnable_tasks_count and host loadavg_1min is more than the CPU count with elevated proc_runable_cnt, the system is likely CPU-bound. If SQL runnable is low but the host proc_ioblocked_cnt and I/O wait rates are high, storage is your suspect.

SELECT scheduler_id,
       runnable_tasks_count,
       current_tasks_count,
       work_queue_count,
       is_online,
       is_scheduler_online,
       load_factor
FROM sys.dm_os_schedulers
WHERE scheduler_id < 255;

Related content

• sys.dm_os_linux_disk_stats (Transact-SQL)
• sys.dm_os_linux_net_stats (Transact-SQL)
• sys.dm_os_linux_vm_stats (Transact-SQL)
• Performance best practices and configuration guidelines for SQL Server on Linux