Re: San Performace with SQl Server

Hi

Have you tried formatting the drives at OS level with cluster sizes of 64kb?

We found it made a big difference on IO performance.

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Saradhi" <Saradhi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC2A304B-BD87-4FB4-8B70-9A659753ABF9@xxxxxxxxxxxxxxxx
> hi everyone,
>
> Am presenlty Testing the I/o performance on the new CX-500 San From Emc
>
>
> And Hba From Emulex,The LUn Size is 1 TB and when doing the Testing
> with SQlIO Tool with a I/o block size-8 i get 39.3
> MB/sec for Random write requestes but when doing the same with Random
> Read
> requests i get 6.04 MB/sec as the output,the read/Write cache is
> enabled with read cache set to 288 and write to 1198,We have a
> sqlserver Oltp Enviroment with mostlty Read Intensive Operations , iam
> wonering how can i increase the Read i/o ,The Lun design looks bad we
> should have made smaller Luns and Shared the Data and Log Files among
> them ,will i get any performance if i set read cache to low value or
> turn off the read cache or should i recomend to rebuild the san design
> to smaller chunks , i am not so well versed in san
> design , what i want is best perfromance for my sql serverr IO ,Pls
> Suggest
>
> We Have Raid 10 On our San with 4D+4D Raid Group sets ,In this Situtation
> what is the best Setting For the Read Cache for our Hba Emulex(2GB)
>
>
> Thanks&Regards
> --
> Saradhi


.

Relevant Pages

  • San Performace with SQl Server
    ... Am presenlty Testing the I/o performance on the new CX-500 San From Emc ... And Hba From Emulex,The LUn Size is 1 TB and when doing the Testing ... requests i get 6.04 MB/sec as the output,the read/Write cache is ...
    (microsoft.public.sqlserver.clustering)
  • San Performace with SQl Server
    ... Am presenlty Testing the I/o performance on the new CX-500 San From Emc ... And Hba From Emulex,The LUn Size is 1 TB and when doing the Testing ... requests i get 6.04 MB/sec as the output,the read/Write cache is ...
    (comp.arch.storage)
  • San Performace with SQl Server
    ... Am presenlty Testing the I/o performance on the new CX-500 San From Emc ... And Hba From Emulex,The LUn Size is 1 TB and when doing the Testing ... requests i get 6.04 MB/sec as the output,the read/Write cache is ...
    (comp.arch.storage)
  • Re: Future memory modules
    ... >> seems to be poorly designed for an L3 memory. ... I was thinking that a larger burst length would allow the chip design ... >> Such a huge cache presents other problems, ... the tags would have to be ...
    (comp.arch)
  • Re: [PATCH/RFC] Simplified Readahead
    ... >>would like to offer up an alternative simplified design which will not ... and the readahead thrashing is in there. ... piece missing is double lookups on cache hits. ... >>Reducing the size of the ahead window doesn't help. ...
    (Linux-Kernel)