Saturday, February 25, 2012

SAN and faster IO

Are there ways to tweak a SAN for faster IO. For some reasons our SAN is not
giving us a great IO throughput compared to the servers that have a Direct
Attached Storage. Similar configuration as far as RAID and drive letters are
concerened and also layout of the databases. Doing some comparisons relates
to disk bottlenecks.. Has anyone tweaked any HBA or any setting that we
might see some better performance or still better if there are any SAN
related publicly accessed articles .Using SQL 2000Have you talked to the SAN vendors? Typically they configure it for optimum
throughput depending on the type of usage you expect...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uFUheIvAEHA.1796@.TK2MSFTNGP12.phx.gbl...
> Are there ways to tweak a SAN for faster IO. For some reasons our SAN is
not
> giving us a great IO throughput compared to the servers that have a Direct
> Attached Storage. Similar configuration as far as RAID and drive letters
are
> concerened and also layout of the databases. Doing some comparisons
relates
> to disk bottlenecks.. Has anyone tweaked any HBA or any setting that we
> might see some better performance or still better if there are any SAN
> related publicly accessed articles .Using SQL 2000
>|||Thought you might be interested in this
http://support.microsoft.com/default.aspx?scid=kb;en-us;810885, just some
issues I have encountered working with SANS.
Cheers
--
Olu Adedeji
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:uunW5dvAEHA.688@.tk2msftngp13.phx.gbl...
> Have you talked to the SAN vendors? Typically they configure it for
optimum
> throughput depending on the type of usage you expect...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uFUheIvAEHA.1796@.TK2MSFTNGP12.phx.gbl...
> > Are there ways to tweak a SAN for faster IO. For some reasons our SAN is
> not
> > giving us a great IO throughput compared to the servers that have a
Direct
> > Attached Storage. Similar configuration as far as RAID and drive letters
> are
> > concerened and also layout of the databases. Doing some comparisons
> relates
> > to disk bottlenecks.. Has anyone tweaked any HBA or any setting that we
> > might see some better performance or still better if there are any SAN
> > related publicly accessed articles .Using SQL 2000
> >
> >
>

No comments:

Post a Comment