SQL Server Performance

SQL Server and SAN

Discussion in 'Performance Tuning for Hardware Configurations' started by danielreber, Apr 11, 2005.

  1. danielreber New Member

    We have a client that is having intermittent performance issues. The data files are located on a SAN but the SAN is also being used by an imaging system. What needs to be done to make sure that there are no performance hits from the imaging system? Can the disks on the SAN be segregated in a way that will alleviate any I/O degradation?

    Thanks for any input, I am not very familiar on how to set up SANs.

    Daniel Reber
    Datamasters, Inc
  2. joechang New Member

    the physical disks must be dedicated to the database.
    The typical SAN configuration has phyical disks formed into RAID Groups, each RAID Group is then carved into LUNs allocated to applications as necessary,

    for a performance critical database, it is essential that the RAID Group is allocated to a single LUN dedicated to the database.
    of course, separate RAID Groups for data, log and possibly tempdb.

    if the Imaging system makes heavy use of disks, the database should be moved to a separate SAN if it is very important
  3. danielreber New Member

    Thanks for you insight.

    Daniel Reber
    Datamasters, Inc
  4. dineshasanka Moderator

    This a good article which may solve your question
    http://www.sql-server-performance.com/ew_san.asp

    quote:Originally posted by danielreber

    We have a client that is having intermittent performance issues. The data files are located on a SAN but the SAN is also being used by an imaging system. What needs to be done to make sure that there are no performance hits from the imaging system? Can the disks on the SAN be segregated in a way that will alleviate any I/O degradation?

    Thanks for any input, I am not very familiar on how to set up SANs.

    Daniel Reber
    Datamasters, Inc
  5. derrickleggett New Member

    You might want to look at a couple things on the SAN.

    1. Follow Joe's solution with dedicated disk. That's critical on a high IO database environment, regardless of what some of the "SAN Experts" tell you.

    2. You might want to consider having only the production database environment with one of the storage processors as the primary processor. The idea is usually to load balance between the processors evenly; however, it's something to consider. Have you looked at the overall performance of the SAN? What are your disk queue lengths when this happens?

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.

Share This Page