San Performace with SQl Server

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 ...
    (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: 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 ... > turn off the read cache or should i recomend to rebuild the san design ...
    (microsoft.public.sqlserver.clustering)
  • Re: I/O performance for dummys
    ... just to be sure that the SAN was delivering reasonable I/O ... It's using the software iSCSI initiator. ... that by connecting a server to our SAN we can supply a certain amount ...
    (comp.unix.solaris)
  • Re: [00/17] Large Blocksize Support V3
    ... allocations, and then creating all this complexity around that is not a ... Now why are high end hardware manufacturers building crippled ... For I/O we have the BIO which can point to multiple pages just fine. ... the page cache from the BIO and from the BIO to the page cache. ...
    (Linux-Kernel)