SQL server virtual memory usage and performance

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 3:42 UTC
Read the original article Hit count: 424

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 exceeds the amount of physical memory available. Currently, physical memory is 10GB (10238k bytes) whereas the virtual memory returns significantly more - 8388607k 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

Related posts about sql

Related posts about Performance