Re: OS block size

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 28 Mar 2001 12:50:37 GMT
Message-ID: <3ac1dcb0.10984699@news-server>

On Wed, 28 Mar 2001 00:06:32 GMT, "Dave Haas" <davidh_at_--nospam--hotmail.com> wrote:

>
>I disagree. Using 16k blocks in an OLTP environment on an NT system would
>quite probably introduce contention issues.
>

I still think the best way to find the ideal block size for NT is to run one of those nifty utils that measure memory transfer speed, pick a size that is fast and near one of the 512 multiples and go with it. I did this in my NT box and 4K turned out to have both the best memory transfer speed and the best overall database performance.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Mar 28 2001 - 06:50:37 CST