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


Thanks,
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)
  • 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: How do I migrate data on drives that are cluster resouces
    ... As Tim said we have grown LUNs on the SAN side and then just extended the LUN ... extend the LUN on the Windows side. ... drives or grow the virtual disks. ...
    (microsoft.public.windows.server.clustering)