Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning "A significant part of sql server process memory has been paged out. This may result in a performance degradation" RE: "A significant part of sql server process memory has been paged out. This may result in a performance degradation"

  • I suspect you are using some process which is using nay extended procedures or clr ones causing memory leak

    or

    Have a external backup utility like veritas or litespeed purging memory

    or

    in any case set the max and min memory (remember both) to same value so that trimming is restricted completely for windows, and also enable lock pages in memory option in case its not already done

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA