Physical Database Architecture
-
Comments posted to this topic are about the item Physical Database Architecture
-
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
-
I agree with Christian Buettner
-
well...that decieved me too 🙁
-
:unsure:
"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?
-
Yogeesha (5/28/2008)
:unsure:"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, suus solum profundum variat
-
Tricky question, but a fair one. I almost got suckered into the 8KB calculation...
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
-
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:
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
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 -
If a page is meaningless for a log file, the answer should be NULL instead of 0 - only joking
-
mosaic (8/6/2008)
If a page is meaningless for a log file, the answer should be NULL instead of 0 - only jokingLa, la, la, I can't hear you... :Whistling:
😛
Semper in excretia, suus solum profundum variat
-
So we have another example of BoL contradicting itself: one page describes the size of log files in terms of 8kkb pages, the limit on logfile sizes as a number of 8k pages, the control of fixed increment growth of logfiles in units of 8k pages (rounded to a multiple of 64k) and another one states clearly that log files don't contain pages.
The question and chosen answer choose one of those pages as delivering the correct answer; how is that choice made? Is there any documentation from MS that resolves the contradiction? Has MS even noticed that its documentation contradicts itself on this topic? Would they care if they had noticed?
Tom
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply