SQL server virtual memory usage and perofrmance
Posted
by user365035
on Stack Overflow
See other posts from Stack Overflow
or by user365035
Published on 2010-06-12T02:10:44Z
Indexed on
2010/06/12
2:23 UTC
Read the original article
Hit count: 271
Hello, I have a very large DB used mostly for analytics. The performance overall is very sluggish. I just noticed that when running the query below, the amount of virtual memory used greatly exceed the amount of physical memory available. Currently, phsycial memory is 10GB (10238 bytes) where as the virtual memory returns significantly more 8388607 bytes. That seems really wrong, but I'm at a bit of a loss on how to proceed.
USE [master]; GO select cpu_count , hyperthread_ratio , physical_memory_in_bytes / 1048576 as 'mem_MB' , virtual_memory_in_bytes / 1048576 as 'virtual_mem_MB' , max_workers_count , os_error_mode , os_priority_class from sys.dm_os_sys_info
© Stack Overflow or respective owner