November 5, 2004 at 3:53 am
I have read somewhere that by trying 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) , instead of the default Page size in SQL in memory is 8K , an example of using 32 K Cluster Size while formating partioin, then on 1 hit for the HardDisk (32 K each) , you get 4 pages into Memory (faster ... because the slowest thing that slow the whole system is to read/write from Hard Disk)
Has anyone tried this before and could possible show me how I could put the DATA and LOG file on such partition please?
Thanks to all
Reg: Herb
November 5, 2004 at 7:40 am
Host: Patrick (Microsoft)
Q: What method do you recommend for determining the optimal block size for both the log and data files?
A: Block size = NTFS cluster size? Depends somewhat on the hardware, but a good setting for log is 4K, data is a multiple of 8K - 64K is a nice number
From http://www.microsoft.com/technet/community/chats/trans/sql/sql0326.mspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply