Log Chains

Question

Log Chains

Viewing 4 posts - 16 through 18 (of 18 total)

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

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

The first couple of rows of LogInfo is kinda useless when the problem is at the end of the file...

Could be that the VLF sizes are such that it can't shrink to 500 exactly, but to a size above it or a size below it. But can't tell anything for sure without seeing the log info.

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

Mike Scalise SSCrazy Eights Points: 8145 More actions · Answer 2

Ok how about this?

RecoveryUnitIdFileIdFileSizeStartOffsetFSeqNoStatusParityCreateLSN

0265470464819252142640

02654704646547865651980640

02131645441309491205199064845000006321600279

02144179201441136645200064845000007963800218

02158597121585315845201064845000009766200313

02174325761743912965202064845000011737000392

02192020481918238725203064846000001152400196

02211025922110259205204064847000000976800007

02232652802321285125205064848000000807500257

02255590402553937925206064849000000596200261

02281149442809528325207064850000000404900243

02309329923090677765208064851000000163200013

02340131843400007685209064851000004058400230

02374210563740139525210064852000004186000190

02411566084114350085211064853000004339600100

02452853764525916165212064854000004466800297

02498073604978769925213064857000006689200249

Mike Scalise, PMP
https://www.michaelscalise.com

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

Can't see the size of the VLFs there, but looks like the last one starts just before 500MB and ends, I would guess, at the 534 the log shrunk to. VLFs can't be resized, so you shrink to the end VLF that straddles the size you requested.

In short, it's not surprising for a log file to shrink to similar to what you asked for, but not exact, because of the VLFs.

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

Mike Scalise SSCrazy Eights Points: 8145 More actions · Answer 4

Ok as long as it makes some sense that it's close but not exact.

Again and again, thanks for your clear explanations.

Mike

Mike Scalise, PMP
https://www.michaelscalise.com