余罪第一季全集,神雕侠女古天乐版,funiea
select type,--clerk的类型 sum(virtual_memory_reserved_kb)as vm_reserved_kb,--保留的内存 sum(virtual_memory_committed_kb)as vm_committed_kb,--提交的内存 sum(awe_allocated_kb)as awe_allocated_kb,--开启awe后使用的内存 sum(shared_memory_reserved_kb)as sm_reserved_kb,--共享的保留内存 sum(shared_memory_committed_kb)as sm_committed_kb,--共享的提交内存 sum(single_pages_kb)as sinlgepage_kb,-- buffer pool中的stolen的内存 sum(multi_pages_kb)as multipage_kb-- memtoleave的内存 from sys.dm_os_memory_clerks group by type order bytype --查询buffer pool/memory to leave select sum(virtual_memory_reserved_kb)as [reserved], sum(virtual_memory_committed_kb)as [commit], sum(virtual_memory_reserved_kb)/sum(virtual_memory_committed_kb) as[reserved/commit], sum(single_pages_kb)+sum(multi_pages_kb) as [stolen], sum(virtual_memory_committed_kb)+sum(single_pages_kb)as [buffer pool], sum(multi_pages_kb) as[memtoleave], sum(awe_allocated_kb)as [aweallocated] from sys.dm_os_memory_clerks --查询sqlserver内存使用 select * from sys.dm_os_process_memory
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论