Post reply

Can someone confirm this

  • December 3, 2003 at 9:29 am

    #66169

    I read the word (below) from today's topic, when I check out system administrator, he reponse me back you see from web site not mean correct?

    try to put the DATA and the LOG file of SQL Database on a partition that is Formatted with 32 K or 64 K Cluster Size (not the defalut = 4 K)

    because the default Page size in SQL in memory is 8K ,

    And If u use the defulat Cluster Size while formating partioin, then to get 1 page (8K), you need 2 hits for the HardDisk (4 K each)

    But If u use 32 K Cluster Size while formatiing partioin, then on 1 hit for the HardDisk (32 K each) , you get 4 pages into Memory (more faster ... because the slowest thing that slow the whole system is to read/write from Hard Disk)

    I use 32 K not 64 K.. because with 64 K you may have a lot of empty pages in memory ( lost in memeory and your DB may be graw more)

    And our system using default which is 4K should suggest them to 32K?

    Thanks!!

    feifei liu


    Rachel

  • December 4, 2003 at 11:16 am

    #484675

    FeiFei -

    We use 64k cluster size here when formatting the partitions. With 4k you can end up with very fragmented drives in no time due to a page in SQL being 8k but the cluster being only 4k.

    I don't have any experience with trying 32k versus 64k.

    Michelle



    Michelle

Viewing 2 posts - 1 through 1 (of 1 total)

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