Jun 16 2009

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: 

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

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

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

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

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

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

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

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

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

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

very nice post innovative thank you
devidvilla001

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>
HTC mobile prices

HTC mobile prices wrote on 07/31/10 6:19 AM

This is a part of life. But be careful to take all the backups of your important documents. Its a safe journey.
seoreseller.com

seoreseller.com wrote on 08/16/10 12:51 PM

I didnt faced any problem yet. anyway, trying to be proactive is the best way i think.
Marketing West Midlands

Marketing West Midlands wrote on 08/22/10 11:19 AM

Very interesting article, I am looking forward for next one.
trgre

trgre wrote on 08/23/10 11:29 AM

very nice post and very informative,thank you Mike!
directory2009

directory2009 wrote on 08/23/10 11:31 AM

Thank you Mike for your info,really nice and helpfull!
car prices in India

car prices in India wrote on 09/13/10 2:58 AM

Good informative post. I like it a lot. Good man.
Ios On Android Phone

Ios On Android Phone wrote on 01/18/12 9:08 PM

I really hate working with SQL and database as I don't understand anything about them at all .
isabel marant sneakers

isabel marant sneakers wrote on 10/21/13 8:10 AM

Thank you expressing the knowledge there would turn out to be quite a few concerns from group.
f50 chaussure de foot

f50 chaussure de foot wrote on 10/28/13 5:27 AM

great blog,thanks for your revealing so competent write-up.
sparxxrx

sparxxrx wrote on 10/16/14 8:59 AM

You will find your boners increasing in size and strength, and there will inarguably be no complaints about your sexual performance after taking this supplement.
http://www.legumesetcompagnie.fr

http://www.legumesetcompagnie.fr wrote on 11/05/14 7:46 PM

There are 10 major phases to this when applied to existing applications and this post is the first of 10 successive ones which I genuinely hope will be of help to the community that has been good enough to provide with a good living.
clothing manufacturer

clothing manufacturer wrote on 07/04/15 4:21 AM

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.
シャネル激安

シャネル激安 wrote on 12/02/15 10:43 PM

シャネルの財布、腕時計、靴、眼鏡、ピアス、バッグかばんが使うの皮質が材料を作るのため、
そのため液体を採用してそれに対して拭くことができます。しかし、
説明したのが必要だのは、使う液体の別に普通でない水、
シャネル激安http://www.cctoh.com/
シャネルバッグ
シャネル財布
シャネル腕時計
シャネル靴
シャネル眼鏡
シャネルピアス
シャネルバッグ新作
シャネル専門のお手入の液体で、かばんの上の現れるあかに対してとても強い的確さがあって。
シャネルバッグ新作 本入手困難ラムスキンセカンドバッグ8016ゴールド金具
200-125 vce

200-125 vce wrote on 07/25/16 4:19 AM

Great insight of this topic! The article is magnificent and unique, writing style quite innovative.
recycledpetssocal.org

recycledpetssocal.org wrote on 11/05/16 2:28 AM

Animal medical practitioner costs for your pet can easily encounter plenty of cash, especially during an unexpected emergency. When you’ve received a family pet, you will surely need to take care from your finances that may incur coming from treatment.
Moonis Elahi

Moonis Elahi wrote on 11/17/16 1:51 AM

The poor will soon die out of Punjab due to uncontrolled inflation. Every shop has its own rates and it is the race to become the most wealthy by being the most corrupt. When Moonis Elahi was in government, prices were controlled throughout the province but today every shop keeper has his own rates.