sys-dm-linux-proc-all-stat-transact-sql.md

title	sys.dm_linux_proc_all_stat (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	02/10/2017
ms.prod	sql-vnext
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
f1_keywords	sys.dm_linux_proc_all_stat sys.dm_linux_proc_all_stat_TSQL dm_linux_proc_all_stat dm_linux_proc_all_stat_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_linux_proc_all_stat dynamic management view
ms.assetid	4be46547-bd51-4f4c-bc40-21632a64357a
caps.latest.revision	15
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.dm_linux_proc_all_stat (Transact-SQL)

[!INCLUDEtsql-appliesto-ssLinx-xxxx-xxxx-xxx]

This DMV is based off of the linux /proc/[pid]/stat file for every process in /proc/. It provides information about the processes running on your system. There will be one row for every process visible under the /proc/ directory.

Column name	Data type	Description
pid	bigint	The Process ID.
comm	nvarchar(256)	The filename of the executable, in parentheses. This is visible whether or not the executable is swapped out.
state	nvarchar(256)	One of the following characters, indicating the process state: R - Running, S - Sleeping in an interruptible wait, D - Waiting in uninterruptible disk sleep, Z - Zombie, T - Stopped (on a signal) or (before Linux 2.6.33) trace stopped, t - Tracing stop (Linux 2.6.33 onward) W - Paging (only before Linux 2.6.0), X - Dead (from Linux 2.6.0 onward), x - Dead (Linux 2.6.33 to 3.13 only), K - Wakekill (Linux 2.6.33 to 3.13 only), W - Waking (Linux 2.6.33 to 3.13 only), P - Parked (Linux 3.9 to 3.13 only).
ppid	bigint	The PID of the parent of this process.
pgrp	bigint	The process group ID of the process.
session	bigint	The session ID of the process.
tty_nr	bigint	The controlling terminal of the process. (The minor device number is contained in the combination of bits 31 to 20 and 7 to 0; the major device number is in bits 15 to 8.)
tpgid	bigint	The ID of the foreground process group of the controlling terminal of the process.
flags	bigint	The kernel flags word of the process. For bit meanings, see the PF_* defines in the Linux kernel source file include/linux/sched.h. Details depend on the kernel version.
minflt	bigint	The number of minor faults the process has made which have not required loading a memory page from disk.
cminflt	bigint	The number of minor faults that the process's waited-for children have made.
majflt	bigint	The number of major faults the process has made which have required loading a memory page from disk.
cmajflt	bigint	The number of major faults that the process's waited-for children have made.
utime	bigint	Amount of time that this process has been scheduled in user mode, measured in clock ticks (divide by sysconf(_SC_CLK_TCK)). This includes guest time, guest_time (time spent running a virtual CPU, see below), so that applications that are not aware of the guest time field do not lose that time from their calculations.
stime	bigint	Amount of time that this process has been scheduled in kernel mode, measured in clock ticks (divide by sysconf(_SC_CLK_TCK)).
cutime	bigint	Amount of time that this process's waited-for children have been scheduled in user mode, measured in clock ticks (divide by sysconf(_SC_CLK_TCK)). (See also times(2).) This includes guest time, cguest_time (time spent running a virtual CPU, see below).
cstime	bigint	Amount of time that this process's waited-for children have been scheduled in kernel mode, measured in clock ticks (divide by sysconf(_SC_CLK_TCK)).
priority	bigint	(Explanation for Linux 2.6) For processes running a real-time scheduling policy, this is the negated scheduling priority, minus one; that is, a number in the range −2 to −100, corresponding to real-time priorities 1 to 99. For processes running under a non-real-time scheduling policy, this is the raw nice value as represented in the kernel. The kernel stores nice values as numbers in the range 0 (high) to 39 (low), corresponding to the user-visible nice range of −20 to 19. Before Linux 2.6, this was a scaled value based on the scheduler weighting given to this process.
nice	bigint	The nice value, a value in the range 19 (low priority) to −20 (high priority).
num_threads	bigint	Number of threads in this process (since Linux 2.6). Before kernel 2.6, this field was hard coded to 0 as a placeholder for an earlier removed field.
itrealvalue	bigint	The time in jiffies before the next SIGALRM is sent to the process due to an interval timer. Since kernel 2.6.17, this field is no longer maintained, and is hard coded as 0.
starttime	bigint	The time the process started after system boot. In kernels before Linux 2.6, this value was expressed in jiffies. Since Linux 2.6, the value is expressed in clock ticks (divide by sysconf(_SC_CLK_TCK)).
vsize	bigint	Virtual memory size in bytes.
rss	bigint	Resident Set Size: number of pages the process has in real memory. This is just the pages which count toward text, data, or stack space. This does not include pages which have not been demand-loaded in, or which are swapped out.
rsslim	decimal	Current soft limit in bytes on the rss of the process; see the description of RLIMIT_RSS in getrlimit(2).
startcode	bigint	The address above which program text can run.
endcode	bigint	The address below which program text can run.
startstack	bigint	The address of the start (i.e., bottom) of the stack.
kstkesp	bigint	The current value of ESP (stack pointer), as found in the kernel stack page for the process.
kstkeip	bigint	The current EIP (instruction pointer).
signal	bigint	The bitmap of pending signals, displayed as a decimal number. Obsolete, because it does not provide information on real-time signals; use /proc/[pid]/status instead.
blocked	bigint	The bitmap of blocked signals, displayed as a decimal number. Obsolete, because it does not provide information on real-time signals; use /proc/[pid]/status instead.
sigignore	bigint	The bitmap of ignored signals, displayed as a decimal number. Obsolete, because it does not provide information on real-time signals; use /proc/[pid]/status instead.
sigcatch	bigint	The bitmap of caught signals, displayed as a decimal number. Obsolete, because it does not provide information on real-time signals; use /proc/[pid]/status instead.
wchan	bigint	This is the "channel" in which the process is waiting. It is the address of a location in the kernel where the process is sleeping. The corresponding symbolic name can be found in /proc/[pid]/wchan.
nswap	bigint	Number of pages swapped (not maintained).
cnswap	bigint	Cumulative nswap for child processes (not maintained).
exit_signal	bigint	Signal to be sent to parent when we die.
processor	bigint	CPU number last executed on.
rt_priority	bigint	Real-time scheduling priority, a number in the range 1 to 99 for processes scheduled under a real-time policy, or 0, for non-real-time processes.
policy	bigint	Scheduling policy. Decode using the SCHED_* constants in linux/sched.h.
delaycct_blkio_ticks	bigint	Aggregated block I/O delays, measured in clock ticks (centiseconds).
guest_time	bigint	Guest time of the process (time spent running a virtual CPU for a guest operating system), measured in clock ticks (divide by sysconf(_SC_CLK_TCK)).
cguest_time	bigint	Guest time of the process's children, measured in clock ticks (divide by sysconf(_SC_CLK_TCK)).
start_data	bigint	Address above which program initialized and uninitialized (BSS) data are placed.
end_data	bigint	Address below which program initialized and uninitialized (BSS) data are placed.
start_brk	bigint	Address above which program heap can be expanded with brk(2).
arg_start	bigint	Address above which program command-line arguments (argv) are placed.
arg_end	bigint	Address below program command-line arguments (argv) are placed.
env_start	bigint	Address above which program environment is placed.
env_end	bigint	Address below which program environment is placed.
exit_code	bigint	The thread's exit status in the form reported by waitpid(2).

Remarks

Returns an empty row set when called on a Windows computer.

Permissions

Requires VIEW SERVER STATE permission.

Note

sys.dm_linux_proc_all_stat only returns results when the sqlservr process is running as root.

Examples

The following queries identify processes using large amounts of system resources.

Memory usage: The following query returns all processes using over 10MB of memory.

SELECT * FROM sys.dm_linux_proc_all_stat 
WHERE vsize > 10000000 ORDER BY vsize DESC;

Thread count:

SELECT * FROM sys.dm_linux_proc_all_stat 
ORDER BY num_threads DESC;

Calls to disk:

SELECT * FROM sys.dm_linux_proc_all_stat 
ORDER BY majflt DESC;

Other useful columns to order by, include minflt, utime, and stime.

See Also

Linux Process Dynamic Management Views (Transact-SQL)