Thursday, February 18, 2010


X64-bit processors use the stack size 2 MB per stack and the Lock pages in memory option is available to reduce paging of buffer pool memory as per KB918483.

X32-bit processors use the stack size 0.5 MB per stack

select *
from sys.dm_os_sys_info

SELECT cpu_count AS [Logical CPUs]
,cpu_count / hyperthread_ratio AS [Physical CPUs]
,physical_memory_in_bytes / 1048576 AS 'mem_MB'
,virtual_memory_in_bytes / 1048576 AS 'virtual_mem_MB'
FROM sys.dm_os_sys_info

No comments:

Post a Comment