Log File Page Size

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tariq » Log File Page Size

Log File Page Size

Rate Topic

Display Mode

Topic Options

Author

Message

Muhammad Tariq

Posted Tuesday, September 16, 2008 11:24 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 5:32 AM
Points: 138, Visits: 234

Comments posted to this topic are about the item Log File Page Size

Tariq
master your setup, master yourself.
http://mssqlsolutions.blogspot.com

Post #570743

Christian Buettner-167247

Posted Wednesday, September 17, 2008 1:35 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:36 AM
Points: 2,547, Visits: 3,648

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

Post #570788

Carla Wilson-484785

Posted Wednesday, September 17, 2008 7:38 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,360, Visits: 1,749

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

Post #570996

Christian Buettner-167247

Posted Wednesday, September 17, 2008 7:53 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:36 AM
Points: 2,547, Visits: 3,648

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

Post #571011

Carla Wilson-484785

Posted Wednesday, September 17, 2008 8:04 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,360, Visits: 1,749

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

Post #571023

Derek Dongray

Posted Wednesday, September 17, 2008 8:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342, Visits: 1,946

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

Post #571033

Steve Jones - SSC Editor

Posted Wednesday, September 17, 2008 9:27 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:39 AM
Points: 31,529, Visits: 13,866

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #571101

Anipaul

Posted Sunday, September 21, 2008 1:41 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,816, Visits: 1,343

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

Post #573105

Noffer

Posted Thursday, September 25, 2008 1:55 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 06, 2011 8:53 AM
Points: 292, Visits: 118

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

Post #576384

SQLRNNR

Posted Friday, July 10, 2009 12:10 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858, Visits: 12,443

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #751311

« Prev Topic | Next Topic »

Permissions