Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log File Page Size Expand / Collapse
Author
Message
Posted Tuesday, September 16, 2008 11:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 2:10 AM
Points: 138, Visits: 236
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
Posted Wednesday, September 17, 2008 1:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 2,826, Visits: 3,866
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
Posted Wednesday, September 17, 2008 7:38 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 1,553, Visits: 1,845

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
Posted Wednesday, September 17, 2008 7:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 2,826, Visits: 3,866
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
Posted Wednesday, September 17, 2008 8:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 1,553, Visits: 1,845
Oh, yeah, you're right. I forgot that the answer had the MSDN reference link.
Post #571023
Posted Wednesday, September 17, 2008 8:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 7:14 AM
Points: 1,344, Visits: 1,983
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
Posted Wednesday, September 17, 2008 9:27 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:39 AM
Points: 33,052, Visits: 15,163
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
Posted Sunday, September 21, 2008 1:41 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,300, Visits: 1,378
Nice links provided in the discussion. Thanks giys...


Post #573105
Posted Thursday, September 25, 2008 1:55 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 6, 2011 8:53 AM
Points: 292, Visits: 118
8k = buffer...
http://msdn.microsoft.com/en-us/library/aa337525(SQL.90).aspx
Post #576384
Posted Friday, July 10, 2009 12:10 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:33 AM
Points: 21,190, Visits: 14,881
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


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 »

Add to briefcase

Permissions Expand / Collapse