Re: San Performace with SQl Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Windows format.

>From the command line

format <drive> /A:64K

Regards
--------------------------------
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:E1EE3130-876C-4BB7-8642-BB4E949361D2@xxxxxxxxxxxxxxxx
>i am not aware how to do it,can u provide me any link on it pls
>
> Thanks&regards
> Saradhi
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>
>> 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

  • Re: Writing custom odbc driver.
    ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ... >>> I am trying to write a custom odbc driver for one of my application. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Image save into folder
    ... Mike Epprecht, Microsoft SQL Server MVP ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2005 - beta period expired??
    ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.setup)
  • Re: index
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ... MVP Program: http://www.microsoft.com/mvp ... Blog: http://www.msmvps.com/epprecht/ ...
    (microsoft.public.sqlserver.tools)
  • Re: Error while taking the backup
    ... Mike Epprecht, Microsoft SQL Server MVP ... MVP Program: http://www.microsoft.com/mvp ... Blog: http://www.msmvps.com/epprecht/ ... > Windows - Delayed Write Failed ...
    (microsoft.public.sqlserver.clients)