• Dear Ramesh,

    Did you looked into task manager that what service is taking more memory.

    As per screen shot attached you have set max memory 25GB for sql server, please look into that taslmanager that sql server service is using its 25 GB or not. If it is not using its 25Gb then look at what other system services are using a lot of memory.

    Run the following query to see does there any memory pressure at sql level.

    SELECT total_physical_memory_kb / 1024 AS total_physical_memory_mb , available_physical_memory_kb / 1024 AS available_physical_memory_mb , total_page_file_kb / 1024 AS total_page_file_mb , available_page_file_kb / 1024 AS available_page_file_mb , system_memory_state_desc FROM sys.dm_os_sys_memory

    if system_memory_state_deesc has "Available physical memory is low" is an indicator of external memory pressure, since it means that the OS has little available memory and so may require SQL Server to reduce its memory usage.

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.