• hello,

    I think you need to check ,How much memory does server have? How did you config memory in sql?

    and due to issues with memory configuration. Two quick things to check:

    1. SQL Server 'max server memory' is set to an optimal value

    2. SQL Server service account has "Lock pages in Memory" rights

    Thanks&Regards

    DBA

    SQL server DBA