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