SELECT object_name as 对象名称, cntr_value*0.1*10/1024/1024 as 应用值_M,cntr_value as 应用值,cntr_type as 应用类型,t.counter_name as 计数器名称,t.instance_name as 实例名称 FROM sys.dm_os_performance_counters t WHERE counter_name = 'Total Server Memory (KB)'

SQL执行历史记录：

SELECT object_name as 对象名称, cntr_value*0.1*10/1024/1024 as 应用值_M,cntr_value as 应用值,cntr_type as 应用类型,t.counter_name as 计数器名称,t.instance_name as 实例名称 FROM sys.dm_os_performance_counters t WHERE counter_name = 'Total Server Memory (KB)'

SQL操作返回历史记录：

2023-02-26 20:59:03:089 输入：SELECT object_name as 对象名称, cntr_value*0.1*10/1024/1024 as 应用值_M,cntr_value as 应用值,cntr_type as 应用类型,t.counter_name as 计数器名称,t.instance_name as 实例名称 FROM sys.dm_os_performance_counters t WHERE counter_name = 'Total Server Memory (KB)'

2023-02-26 20:59:03:089 输出：查询sql server内存整体使用情况 ： SQLServer:Memory Manager

下载地址：

https://pan.baidu.com/s/1RzJq5rKEJWq5xGUIo7jYjw?pwd=8888