• kesavan.rv (10/26/2016)


    Hi Friends,

    All off sudden in my PROD SQL server memory was reduced to zero(As the minimum memory was set to 0).

    Is there any way to find which one caused the SQL server to release the memory?

    This is a VM ware OS windows server 2012R2 and dedicated only for SQL server 2014 SP1.

    Got the error in the error log msg -> “A significant part of SQL server process memory has been paged out. This may result in a performance degradation. Duration: 328 seconds. Working set (KB): 2024356, committed (KB): 45044452, memory utilization: 4%.”

    Thanks,

    Kesavan

    Surely it is the Maximum memory, not the Minimum, which is the important setting here?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.