Saturday, February 25, 2012

SAN question

Hi
are there any special considerations from the database point of view if one is working on a SAN. I wouldn't expect so but thought I'd ask as I'll be in this situation soon
TIA
FredOnce installed and configured SAN should be pretty much transparent to SQL.
Getting the optimum configuration (assignment of logical volumes to physical
devices; RAID levels; placement of data and log; etc) is the most important
consideration. Unfortunately there aren't many general rules for SANs
because every manufacturer's system is different. Talk to the vendor and
listen to their recommendations for running SQLServer on their hardware.
Then test out their suggestions.
--
David Portas
SQL Server MVP
--

No comments:

Post a Comment