SQL Server Performance

Disk Layout and Performance Question

Discussion in 'SQL Server 2008 General DBA Questions' started by sql_jr, Sep 21, 2010.

  1. sql_jr New Member

    Have some questions as we figure out best practice disk layout of sql server on SAN
    1. Does SQL benefit from increased drive letters? The 3Par san is not like the traditional SAN setup. I/O is transparent to the user even if all the data is on 1 LUN or DISK. It does optimization on the sub disk level. But it looks like SQL is the bottleneck in how it uses the data files?
    2. How much room should be keep on these drives for maintenance tasks? What is the normal industry %? We can grow the LUN size anytime without any downtime. So the concept of pre-allocating space is not required on the 3Par SAN. But we do want to keep enough for maintenance tasks and regular growth.
    a. Indexing of the DB
    b. Archiving of DB
  2. ghemant Moderator

    Would you please elaborate and what you wants to achieve?
  3. sql_jr New Member

    I guess what we're looking for is 1) Best practice layout for data, log, tempdb on a SAN; and 2) What space is required % for indexes and backups.
    Any info or links would help. Thx
  4. ghemant Moderator

    I guess this document will help you a lot http://technet.microsoft.com/en-us/library/cc966534.aspx and http://technet.microsoft.com/en-us/library/ms190764(SQL.90).aspx
    For disk space about backup I would insist you to consult with your management on the backup retention period i.e. if your database is of 30GB and your retention period is 5 days make sure that you have 150+ GB space available.
  5. satya Moderator

Share This Page