The Size of the Data Pages in SQL Server

  • free_mascot

    One Orange Chip

    Points: 27168

    Comments posted to this topic are about the item The Size of the Data Pages in SQL Server

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Nice and easy question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • Neil Burton

    SSC-Insane

    Points: 22079

    It was so easy it took at least 20 minutes research to make sure there wasn't a catch. I must have checked half the documentation and writing about page sizes to find a 'but in this case...'.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    β€”Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • pmadhavapeddi22

    SSCertifiable

    Points: 5306

    Though, the answer is NO , still wanted to make sure that there no catch or new enhancement in sql server 2014 πŸ™‚

  • twin.devil

    SSC-Insane

    Points: 22208

    Good Knowledge base question. Thanks for sharing

  • Hany Helmy

    SSChampion

    Points: 13436

    twin.devil (7/17/2014)


    Good Knowledge base question. Thanks for sharing

    Absoulately agree here 😎

  • domenico.delbrocco

    Mr or Mrs. 500

    Points: 587

    a basic concept but it worth to be remembered

    Thanks

  • Ed Wagner

    SSC Guru

    Points: 286969

  • SQLRNNR

    SSC Guru

    Points: 281243

    domenico.delbrocco (7/17/2014)


    a basic concept but it worth to be remembered

    Thanks

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you for the post, very interesting one.

    I had an idea on 8k size but never had an idea that there will-be/can-be a change option or can be changed and was wondering if it really can?... I had my doubts and I went with NO.... well; πŸ™‚

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • William Clardy

    SSChasing Mays

    Points: 626

    Stewart "Arturius" Campbell (7/17/2014)


    Nice, straightforward one, thanks.

    I have worked with numerous different RDBM's, and the page size is fixed in all of them.

    Which in my mind begs the question of "Why?"

    To cite another T-SQL RDBMS, Sybase's Advanced SQL Anywhere allows you to select the page size at database-creation time , with page size options up to 32KB. Obviously, bigger pages can have a significant impact on the I/O overhead, and Sybase's making it an option independent of the CPU type would seem to put the lie to claims of the restriction being necessary for "backward compatibility" with unnamed CPUs.

  • Revenant

    SSC-Forever

    Points: 42467

    Supereasy! Thanks!

  • free_mascot

    One Orange Chip

    Points: 27168

    Thank you and appreciate all your time and interest in writing comments.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • paul.knibbs

    SSCoach

    Points: 15270

    william-700725 (7/17/2014)Sybase's making it an option independent of the CPU type would seem to put the lie to claims of the restriction being necessary for "backward compatibility" with unnamed CPUs.

    Yeah, that CPU page size explanation makes no sense whatsoever, especially since the x86 CPU line (which is obviously SQL Server's primary home) doesn't use 8Kb pages! They used to be 4Kb in the 386 and 486, then they added an option for 4Mb pages in the Pentium, and I think x86-64 CPUs add a 1Gb page option as well.

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply