RE: Off-Topic - SQLServer2k Qs - FS Block Size & Stripe Width

Hi

By "64K block size" Did you mean File system (FS) Block-size Or Stripe Width (RAID 0)?

Qs On Windows is there a Concept of File system (FS) Block Size Like Unix O.S.? Qs What would be the Stripe Width (RAID 0) Advisable for OLTP/Hybrid Application?

NOTE - FS Block Size Differs from Stripe Width (RAID 0)

Forgive the ignorance

Thanks

Vivek

-----Original Message-----
Sent: Monday, September 02, 2002 4:12 PM To: VIVEK_SHARMA

Hi Vivek,

I don't work with MS SQL but from what I have seen on ms forums people prefer 64K block size for the data files and 8K for the log. I believe that 64K is related with i/o in terms of "pages" inside MS SQL

HTH,
Ed

> -----Original Message-----
> From: VIVEK_SHARMA [mailto:VIVEK_SHARMA_at_infosys.com]
> Sent: Monday, September 02, 2002 2:12 PM
> To: LazyDBA.com Discussion
> Subject: Off-Topic - SQLServer2k Qs - FS Block Size & Stripe Width
>
>
>
> For a NEW SQLServer2k Database Setup what are the Current
> Best-practices for :-
>
> Qs What should be the Filesystem Block-size ?
> Qs What should be the Stripe Width for an OLTP/Hybrid Nature
> of Application ?
>
> Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).