Physical Database Architecture

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 Todd Engen » Physical Database Architecture

12 posts, Page 1 of 2

1 2 »»

Physical Database Architecture

Rate Topic

Display Mode

Topic Options

Author

Message

Todd Engen

Posted Tuesday, May 27, 2008 9:12 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 14, 2013 11:26 AM
Points: 1,073, Visits: 6,324

Comments posted to this topic are about the item Physical Database Architecture

Post #507386

Christian Buettner-167247

Posted Wednesday, May 28, 2008 12:53 AM

SSCrazy

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

Hm, tricky question.
It was not clear to me whether the author meant "pages" as units of 8kb or actual "data pages".

Interestingly enough, MS is returning the size of the Log file in units of "pages" in the sys.database_files catalog view.
http://msdn.microsoft.com/en-us/library/ms174397.aspx

Best Regards,
Chris Büttner

Post #507454

Ignacio A. Salom Rangel

Posted Wednesday, May 28, 2008 1:20 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 5:05 PM
Points: 3,051, Visits: 1,364

I agree with Christian Buettner

My blog

Post #507465

rajankjohn

Posted Wednesday, May 28, 2008 1:37 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, February 15, 2013 2:53 PM
Points: 1,199, Visits: 568

well...that decieved me too Sad

Post #507467

Yogeesh

Posted Wednesday, May 28, 2008 1:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 06, 2012 10:56 PM
Points: 180, Visits: 359

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

now what is this 'series of log records'? are they not saved in any files/pages?

Post #507473

majorbloodnock

Posted Wednesday, May 28, 2008 2:44 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 10:52 AM
Points: 1,043, Visits: 2,945

Yogeesha (5/28/2008)

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

now what is this 'series of log records'? are they not saved in any files/pages?

No. The disc has a number of blocks that, combined, contain the log file. The log file contains log records. The disc also has a whole load more blocks that, combined, contain the data file, and that data file contains its data stored in SQL Server-allocated logical chunks called pages.

A log file doesn't contain pages any more than a text file does. Of course, if that text file or log file is opened up into memory, a number of memory pages will be allocated to hold the data that makes up the file. However, even then, it's the OS pages that hold the file, not the other way round.

Semper in excretia, sumus solum profundum variat

Post #507488

Timothy Ford-473880

Posted Wednesday, May 28, 2008 6:56 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 9:07 AM
Points: 1,004, Visits: 424

Tricky question, but a fair one. I almost got suckered into the 8KB calculation...

- Tim Ford, SQL Server MVP
http://www.sqlcruise.com
http://www.thesqlagentman.com
http://www.linkedin.com/in/timothyford

Post #507634

webrunner

Posted Wednesday, May 28, 2008 7:39 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 2:08 PM
Points: 2,121, Visits: 2,226

Timothy Ford (5/28/2008)

Tricky question, but a fair one. I almost got suckered into the 8KB calculation...

Yes, tricky. I was in fact suckered into the 8 KB calculation. Hehe

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Post #507671

Dcarlson

Posted Monday, June 02, 2008 9:30 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 17, 2012 10:17 AM
Points: 310, Visits: 242

Kinda seems like a Microsoft test question.

----------------------------------------------------------------------------
"No question is so difficult to answer as that to which the answer is obvious." - George Bernard Shaw

Post #509969

mosaic-263591

Posted Wednesday, August 06, 2008 10:19 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:37 AM
Points: 419, Visits: 556

If a page is meaningless for a log file, the answer should be NULL instead of 0 - only joking

Post #547699

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions