sys.dm_os_sys_info [英] sys.dm_os_sys_info

问题描述

大家好

我从dm_os_sys_info获得了上述信息。

commited_kb是为sqlservr.exe进程分配的当前物理内存？或者包括sql server缓冲池内存？

提交目标是指target_server_memory值？

解决方案

来自官方文档

https://docs.microsoft。 com / en-us / sql / relational-databases / system-dynamic-management-views / sys-dm-os-sys-info-transact-sql？view = sql-server-2017

committed_kb

                 

适用于：  ; SQL Server 2012（11.x）到SQL Server 2017. 表示内存管理器中以KB为单位的已提交内存。 内存管理中不包含保留内存 r。不可空。

committed_target_kb

     

适用于：  SQL Server 2012（11。 x）通过SQL Server 2017. 表示SQL Server内存管理器可以使用的内存量，以KB为单位（KB） 。目标金额使用各种输入计算，例如： - 系统的当前状态，包括其负载 - 当前流程要求的内存 - 内存量安装在电脑上 - 配置参数 如果 committed_target_kb  大于  committed_kb ，内存管理器将尝试获得额外的记忆。如果  committed_target_kb  是 小于  committed_kb ，则内存管理器将尝试缩减提交的内存量。   committed_target_kb  始终包含被盗和保留的内存。不是 可以为空。

Hi All

I have the above info from dm_os_sys_info.

commited_kb is the current physical memory allocate for the sqlservr.exe process ?? Or including sql server buffer pool memory ?

commited target means the target_server_memory value?

解决方案

From official documentation

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-sys-info-transact-sql?view=sql-server-2017

committed_kb

Applies to: SQL Server 2012 (11.x) through SQL Server 2017. Represents the committed memory in kilobytes (KB) in the memory manager. Does not include reserved memory in the memory manager. Not nullable.

committed_target_kb

Applies to: SQL Server 2012 (11.x) through SQL Server 2017. Represents the amount of memory, in kilobytes (KB), that can be consumed by SQL Server memory manager. The target amount is calculated using a variety of inputs like: - the current state of the system including its load - the memory requested by current processes - the amount of memory installed on the computer - configuration parameters If committed_target_kb is larger than committed_kb, the memory manager will try to obtain additional memory. If committed_target_kb is smaller than committed_kb, the memory manager will try to shrink the amount of memory committed. The committed_target_kb always includes stolen and reserved memory. Not nullable.

这篇关于sys.dm_os_sys_info的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！