Since a few weeks, our SQL server (2005 64 bits Standard Edition running on Windows 2003 DataCenter) has some issues performance wise. A few times a weeks the dataserver become very slow even unresponsive. I found in the event log the following entry:
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 14419 seconds. Working set (KB): 47888, committed (KB): 161528, memory utilization: 29%%.
Since we are using the standard edition, we can’t use the Lock pages in memory user right. I have no idea what to do next. Can someone has a good workaround?