sys.dm_os_sys_info (Transact-SQL)

Returns a miscellaneous set of useful information about the computer, and about the resources available to and consumed by SQL Server.

Column name

Data type

Description

cpu_ticks

bigint

Current CPU tick count. CPU ticks are obtained from the processor's RDTSC counter. It is a monotonically increasing number.

ms_ticks

bigint

Number of milliseconds since the computer was started.

cpu_count

int

Number of logical CPUs on the system.

hyperthread_ratio

int

Ratio of the number of logical or physical cores that are exposed by one physical processor package.

physical_memory_in_bytes

bigint

Amount of physical memory available.

virtual_memory_in_bytes

bigint

Amount of virtual memory available to the process in user mode. This can be used to determine whether SQL Server was started by using a 3-GB switch.

bpool_committed

int

Number of 8-KB buffers in the buffer pool. This amount represents committed physical memory in the buffer pool. Does not include reserved memory in the buffer pool.

bpool_commit_target

int

Number of 8-KB buffers needed by the buffer pool. The target amount is calculated using a variety of inputs such as the current state of the system, including its load, the memory requested by current processes, the amount of memory installed on the computer, and configuration parameters. If the bpool_commit_target is larger than the bpool_committed value, the buffer pool will try to obtain additional memory. If the bpool_commit_target is smaller than the bpool_committed value, the buffer pool will shrink.

bpool_visible

int

Number of 8-KB buffers in the buffer pool that are directly accessible in the process virtual address space. When not using the Address Windowing Extensions (AWE), when the buffer pool has obtained its memory target (bpool_committed = bpool_commit_target), the value of bpool_visible equals the value of bpool_committed.

When using AWE on a 32-bit version of SQL Server, bpool_visible represents the size of the AWE mapping window used to access physical memory allocated by the buffer pool. The size of this mapping window is bound by the process address space and, therefore, the visible amount will be smaller than the committed amount, and can be further reduced by internal components consuming memory for purposes other than database pages. If the value of bpool_visible is too low, you might receive out of memory errors.

stack_size_in_bytes

int

Size of the call stack for each thread created by SQL Server.

os_quantum

bigint

Quantum for a non-preemptive task, measured in milliseconds. Quantum (in seconds) = os_quantum / CPU clock speed.

os_error_mode

int

Error mode for the SQL Server process.

os_priority_class

int

Priority class for the SQL Server process.

max_workers_count

int

Maximum number of workers that can be created.

scheduler_count

int

Number of user schedulers configured in the SQL Server process.

scheduler_total_count

int

Total number of schedulers in SQL Server.

deadlock_monitor_serial_number

int

ID of the current deadlock monitor sequence.

sqlserver_start_time_ms_ticks

bigint

ms_tick number when SQL Server last started. Compare to the current ms_ticks column.

sqlserver_start_time

datetime

Date and time SQL Server last started.

Permissions

Requires VIEW SERVER STATE permission on the server.