• Can you please provide the version, edition and bitness of your OS and SQL Server instance?

    And the results of these queries:

    -- memory overview

    SELECT CAST(physical_memory_in_bytes / (1024.0 * 1024.0 * 1024.0) AS DECIMAL(20, 2)) AS PhysicalMemoryGB,

    CAST(virtual_memory_in_bytes / (1024.0 * 1024 * 1024) AS DECIMAL(20, 2)) AS VasGB,

    CAST((bpool_committed * 8) / (1024.0 * 1024.0) AS DECIMAL(20, 2)) AS BufferPoolCommittedMemoryGB,

    CAST((bpool_commit_target * 8) / (1024.0 * 1024.0) AS DECIMAL(20, 2)) AS BufferPoolTargetMemoryGB,

    (

    SELECT CAST(CAST(value_in_use AS INT) / 1024.0 AS DECIMAL(20, 2))

    FROM sys.configurations

    WHERE name = 'min server memory (MB)'

    ) AS MinServerMemoryGB,

    (

    SELECT CAST(CAST(value_in_use AS INT) / 1024.0 AS DECIMAL(20, 2))

    FROM sys.configurations

    WHERE name = 'max server memory (MB)'

    ) AS MaxServerMemoryGB,

    (

    SELECT value_in_use

    FROM sys.configurations

    WHERE name = 'awe enabled'

    ) AS IsAweEnabled

    FROM sys.dm_os_sys_info;

    -- cpu overview

    SELECT osi.cpu_count AS LogicalCpuCount,

    osi.hyperthread_ratio AS HyperthreadCoreRatio,

    osi.cpu_count / osi.hyperthread_ratio AS PhysicalCpuCount,

    (

    SELECT COUNT(*)

    FROM sys.dm_os_schedulers

    WHERE scheduler_id < osi.cpu_count

    AND is_online = 1

    ) AS LogicalCpuOnline

    FROM sys.dm_os_sys_info osi;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato