|
Home > Archive > MS SQL Server > August 2005 > Microsoft Windows 2000 alocation unit
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Microsoft Windows 2000 alocation unit
|
|
| Oskar 2005-08-12, 11:23 am |
| Hi,
In <<SQL Server 2000 Operations Guide: Capacity and Storage Management>>
(http://www.microsoft.com/technet/pr...in/sqlops6.mspx)
in section <<Windows NT File System (NTFS) Allocation Unit>> I read the
following:
<<The best practice for SQL Server is to choose 64 KB, because this reduces
the likelihood of I/Os that span distinct NTFS allocations, which then might
result in split I/Os.>>
How many of you have chosen the 64K allocation unit size? Did you get any
noticeable performance gains? How much worse is the default 4KB size than
64KB, when the data disk is, say, RAID10 with 128KB stripe size?
--
Many thanks,
Oskar
| |
| Oskar 2005-08-12, 11:23 am |
| In addition to my previous post: does the bigger allocation unit size really
make sense for the disk, on which you place the tempdb database?
"Oskar" wrote:
> Hi,
> In <<SQL Server 2000 Operations Guide: Capacity and Storage Management>>
> (http://www.microsoft.com/technet/pr...in/sqlops6.mspx)
> in section <<Windows NT File System (NTFS) Allocation Unit>> I read the
> following:
>
> <<The best practice for SQL Server is to choose 64 KB, because this reduces
> the likelihood of I/Os that span distinct NTFS allocations, which then might
> result in split I/Os.>>
>
> How many of you have chosen the 64K allocation unit size? Did you get any
> noticeable performance gains? How much worse is the default 4KB size than
> 64KB, when the data disk is, say, RAID10 with 128KB stripe size?
>
> --
> Many thanks,
> Oskar
>
|
|
|
|
|