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 12»»

Physical Database Architecture Expand / Collapse
Author
Message
Posted Tuesday, May 27, 2008 9:12 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
Comments posted to this topic are about the item Physical Database Architecture
Post #507386
Posted Wednesday, May 28, 2008 12:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:47 AM
Points: 2,840, Visits: 3,872
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
Posted Wednesday, May 28, 2008 1:20 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 14, 2014 8:21 AM
Points: 3,084, Visits: 1,433
I agree with Christian Buettner




My blog
Post #507465
Posted Wednesday, May 28, 2008 1:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 10:36 AM
Points: 1,199, Visits: 574
well...that decieved me too
Post #507467
Posted Wednesday, May 28, 2008 1:47 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, February 6, 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
Posted Wednesday, May 28, 2008 2:44 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 8:53 AM
Points: 1,049, Visits: 3,003
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
Posted Wednesday, May 28, 2008 6:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 11, 2014 10:59 AM
Points: 1,020, Visits: 442
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
Posted Wednesday, May 28, 2008 7:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 2,351, Visits: 2,700
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.


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"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
Posted Monday, June 2, 2008 9:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 4:46 PM
Points: 310, Visits: 244
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
Posted Wednesday, August 6, 2008 10:19 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 17, 2013 3:18 AM
Points: 419, Visits: 559
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 »

Add to briefcase 12»»

Permissions Expand / Collapse