views:

151

answers:

1

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 
+2  A: 

Are you having general problems on this box or problems with a specific query? In most cases, query optimization is best asked here, but everything else about general SQL Server performance profiles belongs on serverfault.com, especially OS/Server/hardware configuration.

Cade Roux
Yes, I meant MB. There isn't a specific query to optimize, the discrepency between physical and virtual seems way out of wack. More of a generic question. I suppose this question is better asked at serverfault.com