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"

  • It is looking like memory page out. Have you changed sql server service account recently? and not changed the same for "Lock pages in memory"? Have a look at it.

    If the resource utilization for the node is high and it can not even recieve the heart beat, there are chances for a failover.

    Regards

    Mahesh