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,
SaradhiI will be beneficial if you spread the Data, T-Log and TempDB files
across mutilpe LUN's as opposed ot a single alrge LUN and additionally
invest in a 2nd HBA so you have multiple channels to the SAN.
If your environment is Read-intensive then logic would dictate biasing
the cache towards Read operations as opposed to Write, you might be
better making small adjustments and re-testing until yo ustrike a happy
medium.
ALI|||It will be beneficial if you spread the Data, T-Log and TempDB files
across multiple LUN's as opposed to a single large LUN and additionally
invest in a 2nd HBA so you have multiple channels to the SAN.
If you have tools to identify hot spindles then so much the better as
you can then try distributing the high-usage elements.
If your environment is Read-intensive then logic would dictate biasing
the cache towards Read operations as opposed to Write, you might be
better making small adjustments and re-testing until you strike a happy
medium.
ALI|||u had any performance increase by increasing the Read cache,Any Reads
Done will be checked In the sql Buffer cache else will go for a disk
read and ihave set the max server Memory to 12 gb out of 16, Does Read
cache in the
helps us in improving the Read I/o operations as i have read in some of
the postings in here not to go for Read cache but to turn off the read
cache and read ahead and use all for write cache ,As u suggesst should
i check the Io By
increasing the Read cache and check the stats
Thanks&Regards
saradhi
No comments:
Post a Comment