SQL Server 2005 and 2008 Problem On 64-bit Architecture
Posted by Mike Brunt at 11:49 AM DataBase
We have a client that experienced a severe slow-down then complete lock-up of SQL Server 2008 Enterprise on Windows 2008 Enterprise server both being 64-bit. Luckily we had configured mirroring at the SQL server level so they were back up and running fairly quickly. After performing some forensics on the ailing server we discovered several messages, like the one shown below, in the Windows Application Event Log...
"A SIGNIFICANT PART OF SQL SERVER PROCESS MEMORY HAS BEEN PAGED OUT. THIS MAY RESULT IN A PERFORMANCE DEGRADATION. DURATION: 0 SECONDS. WORKING SET (KB): 3031064, COMMITTED (KB): 5972336, MEMORY UTILIZATION:
Doing a little more digging, we found this is an apparently known issue on Windows 64-bit architecture. This problem occurs because the Windows operating system pages out the working set of the SQL Server process. If you are running SQL Server 2005 or 2008 on 64-bit Windows it is important that you check the Windows Application Event Log to make sure you are not seeing a message like the one above.