San Performace with SQl Server
- From: "saradhi" <saradhiY@xxxxxxxxx>
- Date: 25 Aug 2005 01:54:49 -0700
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
.
- Prev by Date: Re: General musings and/or recommendations on number of global spares to keep?
- Next by Date: San Performace with SQl Server
- Previous by thread: General musings and/or recommendations on number of global spares to keep?
- Next by thread: San Performace with SQl Server
- Index(es):
Relevant Pages
|