Log File Page Size

Question

Post reply

Log File Page Size

Muhammad Tariq

Ten Centuries

Points: 1020
More actions
September 16, 2008 at 11:24 pm

#212700

Comments posted to this topic are about the item Log File Page Size
Tariq
master your setup, master yourself.
http://mssqlsolutions.blogspot.com

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

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

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 1

The format of log records and pages is not constrained to follow the format of data pages.

http://msdn.microsoft.com/en-us/library/ms190925(SQL.90).aspx

One of the system pages stored in both the primary data file and the first log file is a database boot page that contains information about the attributes of the database.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/39e00ebe-c9b7-4d53-90bd-15de2015fd34.htm

Best Regards,

Chris Büttner

SqlOnMyMind SSCertifiable Points: 5062 More actions · Answer 2

Note:
Log files do not contain pages; they contain a series of log records.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ddc311fe-f3cc-4e99-b86b-43ce822ceda3.htm

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 3

Hi Carla,

Thanks for sharing this, but this information was already quoted by the author of the QOTD.

(Your link is just the BOL version instead of the MSDN version I assume).

Best Regards,

Chris Büttner

SqlOnMyMind SSCertifiable Points: 5062 More actions · Answer 4

Oh, yeah, you're right. I forgot that the answer had the MSDN reference link.

StarNamer SSCrazy Eights Points: 8746 More actions · Answer 5

Wasn't there a similar QOD a few weeks ago and the discussion came down the fact that this is basically a trick question relying on the multiple meanings the word 'page'?

A page may either be a physical unit of data transfer or a 'data page' which is structured in some way.

As far as I am aware, SQLserver uses the same 'physical' page size for all files (including log files), hence will read the log file in 8K chunks. However, the internal structure of a log file does not follow the same page structure as database files.

I hate 'trick' questions that just depend on having noticed some random note in the manuals...

Derek

Steve Jones - SSC Editor SSC Guru Points: 736291 More actions · Answer 6

Derek,

That's part of the idea of the QOD. It's not designed so that you get everything right and prove you're the SQL Server god. We get some questions in there that are trivia type questions. It's a chance for you to learn something, and hopefully something that might help you at some point down the road. Maybe you'll recall it at some point.

We do make mistakes, so we like to see discussion here to help correct things.

The log page thing is interesting. Logs have records, but I don't think it's documented well what a page is or isn't in the log. Perhaps everyone should send some feedback from BOL and ask for this to be updated.

Anipaul SSC-Insane Points: 24681 More actions · Answer 7

Nice links provided in the discussion. Thanks giys...

Noffer Ten Centuries Points: 1090 More actions · Answer 8

8k = buffer...

http://msdn.microsoft.com/en-us/library/aa337525(SQL.90).aspx

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Found this one very interesting. My initial understanding was that of logs having 8k pages. However - I think it comes down to as Steve said - trivia questions to help us learn something.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events