Jun 16 2009

SQL Server 2005 and 2008 Problem On 64-bit Architecture

Posted by Mike Brunt at 11:49 AM
14 comments - Categories: 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:

50%%."

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.

Here is the Microsoft KB detailing this issue and resolution.

Comments

Mike Brunt wrote on 06/26/09 11:55 AM

I am sorry to hear that and you are not alone, there are many who either do not have back-ups at all or even worse, have back-ups that do not function as needed when they are needed.

JadaT wrote on 03/09/10 1:20 PM

It seems that there are still a lot more benefits with staying on the 32-bit architecture. Programs seem to run faster and there are less issues.

Amro wrote on 03/18/10 6:08 AM

I've experienced a problem like you , I really hate working with SQL and database as I don't understand anything about them at all .

best dvd to ipod wrote on 03/24/10 9:43 AM

SQL is type of complex, not very easy to used. Nice article. Keep up the good work.

Derek Cullen wrote on 03/27/10 10:10 PM

Indeed many do not have a proper back-up and when in need the very purpose of the back-up is of no use at all.

This shows how back-ups are important in preventing such issues.

http://www.bloggymedia.com/

anuity wrote on 04/06/10 11:15 PM

i think there always a solution for that. thanks for posting.

Articles Guide wrote on 05/26/10 10:09 PM

I am using SQL Server 2008 on 64-bit Windows But I didn't get any message of this kind.

giochi gratis flash online wrote on 06/20/10 3:17 PM

very nice post innovative thank you

devidvilla001 wrote on 07/10/10 5:35 AM

I'm very interested in your article, and I suggest you to browse some online stores to find something different.

<a href="http://www.zahrolizwan.my-worldhomebiz.com/">kerja part time</a>