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: 269

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

Related posts about sql

Related posts about Performance