Downgrading backup log buffers from 1024K to 64K

Question

Downgrading backup log buffers from 1024K to 64K

Krasavita

SSC-Insane

Points: 23138
More actions
April 5, 2011 at 2:13 pm

#237945

Hi everybody,
My server goes down 2- 3 weeks and I can't figure out what is causing it. I found this in error
Downgrading backup log buffers from 1024K to 64K. What does it mean?
I have:
OS NameMicrosoft(R) Windows(R) Server 2003, Enterprise Edition
Version5.2.3790 Service Pack 2 Build 3790
System ModelPowerEdge 2850
System TypeX86-based PC
Processorx86 Family 15 Model 4 Stepping 3 GenuineIntel ~2992 Mhz
Processorx86 Family 15 Model 4 Stepping 3 GenuineIntel ~2992 Mhz
Processorx86 Family 15 Model 4 Stepping 3 GenuineIntel ~2992 Mhz
Processorx86 Family 15 Model 4 Stepping 3 GenuineIntel ~2992 Mhz
BIOS Version/DateDell Computer Corporation A05, 1/9/2006
SMBIOS Version2.3
Windows DirectoryC:\WINDOWS
System DirectoryC:\WINDOWS\system32
Boot Device\Device\HarddiskVolume2
LocaleUnited States
Hardware Abstraction LayerVersion = "5.2.3790.3959 (srv03_sp2_rtm.070216-1710)"
Total Physical Memory12,287.06 MB
Available Physical Memory6.06 GB
Total Virtual Memory23.78 GB
Available Virtual Memory17.73 GB
Page File Space12.00 GB
Page FileC:\pagefile.sys

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Google terms: Virtual memory fragmentation. MemToLeave

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krasavita SSC-Insane Points: 23138 More actions · Answer 2

Krasavita

SSC-Insane

Points: 23138

April 5, 2011 at 3:54 pm

#1307751

Do I need to re start all my exchange servers

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

What does Exchange have to do with anything?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krasavita SSC-Insane Points: 23138 More actions · Answer 4

I was reading wrong article

The best solution get upgrade it to 64

But what else can be done?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Find out what's using MemToLeave, increase the size of that reserved mem (and reduce the buffer pool by a like amount), restart SQL regularly. Not much really.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krasavita SSC-Insane Points: 23138 More actions · Answer 6

Find out what's using MemToLeave

How can I do that?

reduce the buffer pool by a like amount ? What anount?

restart SQL regularly

How often?

Thank you for your help

wc31754 SSC Rookie Points: 31 More actions · Answer 7

Is there a solution to this?

I am also seeing the same issue whenever my log backup runs. It hasn't brought down SQL for me yet. And this all started when I started to do log shipping.

I found an article that suggest setting the maxtransfersize could resolve this but how do I do that with log shipping?

Any feedbacks would be greatly appreciated.

Thanks.

himanshu827 21014 SSC Journeyman Points: 96 More actions · Answer 8

Hi

We love the way you reply for all issues , but can you give little bit more details , I show you all posts , all are shorts and sweet , can you given some additional information , because guys who all

are asking this question are not MVPs .

Thanks

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 9

Did you try searching for the terms Gail gave you? The first hit on Google is an article that explains the issue and offers some troubleshooting advice.