Post reply

SQL Server Page Size

  • September 17, 2008 at 2:40 am

    #190849

    Hi Guys and Gals

    We are experimenting in upgrading our Sybase version from 8 to 10.

    Playing with Sybase Central on unloading and reloading databases.

    With this we found that we could decrease and increase the page size from the current 4K which our Sybase servers operate.

    There where choices for 2, 4, 8, 16 and 32k page files.

    I was just wondering if there was a way in SQL to de/increase the page size from 8k.

    As SQL and Sybase are both competitors and the newer versions of Sybase are ever becoming more like SQL we are wondering if the tools are there in SQL.

    Thanks

    Ant

  • September 17, 2008 at 3:53 am

    #872895

    anthony.green (9/17/2008)

    Hi Guys and Gals

    We are experimenting in upgrading our Sybase version from 8 to 10.

    Playing with Sybase Central on unloading and reloading databases.

    With this we found that we could decrease and increase the page size from the current 4K which our Sybase servers operate.

    There where choices for 2, 4, 8, 16 and 32k page files.

    I was just wondering if there was a way in SQL to de/increase the page size from 8k.

    As SQL and Sybase are both competitors and the newer versions of Sybase are ever becoming more like SQL we are wondering if the tools are there in SQL.

    Thanks

    Ant

    Competitors? Did you know SQL Server 4.2 was actually Sybase?... the actual source code?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • September 17, 2008 at 3:57 am

    #872898

    Yes I was aware that MS purchased 4.2 off Sybase and rebranded as SQL

  • September 17, 2008 at 4:20 am

    #872906

    Anthony,

    I've just noticed this topic and it might be helpfull to you;

    http://qa.sqlservercentral.com/articles/Development/2862/

    BTW the page-sizes are adjustable ONLY by installing SQL server.

    Once you installed SQL server it's permananent.

    Regards,

    GKramer

    The Netherlands

Viewing 4 posts - 1 through 3 (of 3 total)

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