Thursday, March 22, 2012

Default Allocation Size

In setting up the Data directory for SQL 2000 Im at at the
format partition. The default partition size is
recommended for general use but it says it depends on the
size of the disk.
We are connected to a SAN that is set to 64k stripe set.
Do we need to also set the format of the partition to the
same 64k or will default take care of that (my thinking).
Rob Thiebeau64k is good... you will be fine.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob Thiebeau" <anonymous@.discussions.microsoft.com> wrote in message
news:0afa01c3db7b$3bbf50c0$a501280a@.phx.gbl...
> In setting up the Data directory for SQL 2000 Im at at the
> format partition. The default partition size is
> recommended for general use but it says it depends on the
> size of the disk.
> We are connected to a SAN that is set to 64k stripe set.
> Do we need to also set the format of the partition to the
> same 64k or will default take care of that (my thinking).
> Rob Thiebeausql

No comments:

Post a Comment