• Hi sql lover,

    I'm doing a similar exercise with a clients SAN here in NZ.

    Before I even did SQLIO, I actually spent a few 30 minute sessions with our SAN tech (and VMWare tech) going over both configurations to confirm what is setup and how. You need to have some basic understanding of SANs before doing this.

    So go hit up BrentOzar.com and check out his amazing blog entries covering SAN performance:

    http://www.brentozar.com/archive/2011/09/automated-tiered-storage-for-databases/

    http://sqlserverpedia.com/blog/sql-server-performance-tuning/sqlio-tutorial/

    The other thing to bear-in-mind is if your servers are virtualized as the multipathing configuration will affect performance (in my case VMWare multipathing was set up incorrectly for the SAN here.....):

    http://www.brentozar.com/archive/2009/05/san-multipathing-part-2-what-multipathing-does/

    Good luck!

    Cheers

    Michael