microsoft.public.sqlserver.server - optimum allocation unit size ?

Home > Archive > microsoft.public.sqlserver.server > November 2002 > optimum allocation unit size ?

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

optimum allocation unit size ?

Kevin Kuzdas

2002-11-11, 2:23 pm

I need to format the Win 2000 server drive that will hold
our application databases, and would like to use the
optimum allocation unit size for SQL Server performance.
My choices are 512, 1024, 2048, 4096, or "system default".

What is the best choice?

Sponsored Links

Free Braindumps | MCSE braindumps software forum