mssql sqlserver 查看sql数据引擎占用内存情况查看


摘要:
下文讲述使用sysperfinfo系统表获取sql引擎占用的内存情况分析,如下所示:

   ---方法1:
   select *,CAST(cntr_value/1024.0 as decimal(18,2))  as  [内存占用(M)]
    from master.sys.sysperfinfo  
    where counter_name='Total Server Memory (KB)'
    ----------------------------------------
   ---方法2:
   SELECT physical_memory_in_use_kb/1024   as  [内存占用(M)] ,* 
   FROM sys.dm_os_process_memory
mssql_sqlserver_内存占用情况查看

mssql_sqlserver_内存占用情况查看