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
下载地址: