Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

San & Sql Server Expand / Collapse
Author
Message
Posted Monday, September 16, 2013 8:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:01 AM
Points: 36, Visits: 118
Hi,
I understand it's best practice to seperate log, data and temp files over seperate drives, however is this still being done for people running on SAN's?

When doing a new SQL install, I asked for additional drives, It was mentioned to me that this is not done when storage is on a SAN because there are no dedicated spindles for the drive. All spindles are shared among the SAN.

Everything I read about discusses this practice as important as well as selecting the right RAID type for the files... Is this also something that is also no longer done?

I would really appreciate any thoughts, advice or past experience regarding this.
Thank you,
Kjy
Post #1495351
Posted Tuesday, September 17, 2013 3:10 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:20 PM
Points: 112, Visits: 802

When doing a new SQL install, I asked for additional drives, It was mentioned to me that this is not done when storage is on a SAN because there are no dedicated spindles for the drive. All spindles are shared among the SAN.


If you're running IBM XIV that is a correct statement. Although this is just my experience EMC and HDS are not like that, spindles are shared to be more cost effective. If that's the case the best option would be work with SAN admins to find you the "Quietest" spindles to share your drives with maybe?


--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1495409
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse