DaveWentzel.com            All Things Data

Virtual Copy SAN Snapshots

 

allows multiple sql instances to read data from a single data folder on a SAN that is presented to each instance as a separate LUN managed by the SAN volume management software. 
 
Each LUN must be read/write since the db may need to write temporary data. 
 
benefits:
--no redundant data housed on the SAN
--r/w activity will not impact query activity...no blocking
--each reporting instance can have a snapshot from a different point in time (one for hourly needs, one for daily needs)
 
If you have more than one query instance a network load balancer (like an F5) can be used to distribute the workload using IP affinity.  This won't work for short lived HTTP connections...but other solutions can be implemented then. 
 

Add new comment