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

SQL Server on SAN Expand / Collapse
Author
Message
Posted Monday, January 19, 2004 5:53 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 19, 2012 5:20 PM
Points: 376, Visits: 69

I have to deploy a database onto our customer's SAN.  The customer is having the SAN configured before I get a look at it.  My question is, What should I be asking before deploying the database?  Anyone with info on SQL Server deployment on SAN's would be most helpful as I haven't done this before and I'm not entirely sure how SAN's function in terms of where I should be placing db files (does it really matter or does the SAN take care of it?).  Are there issues with running SQL Server on a SAN?

Thanks,

Angela




Post #96127
Posted Monday, January 19, 2004 10:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 19, 2004 10:18 PM
Points: 1, Visits: 1

A SAN is a High Availability storage solution which links physical drives on a storage device to the local machine by either Direct attached HBAs (host bus adapters) or through a Fabric connection via a Fibre Channel switch to the SAN Storage device. You can store you database files on the san with either one or two storage groups for redundency. Typically you should have seperate drives or partitions for your logs=Raid 1, database files=Raid 5, and your quorum drive= Raid 1 (Basic only not dynamic) to store the cluster configurations. Once you setup your SAN Agents on the specific SQL servers then whatever storage group that you have assigned the hosts, then they will be presented with a local physical drive that you can split up. SQL databases run the best when stored on a SAN because of the increased I/O Performance gain over storing on local Server physical drives. If you need anymore help then just send me an email john.deavers@deaversnet.com

 

Thanks,

John Deavers

DEAVERSNET Technologies

MCSA,MCSE, MCDBA, CCNA,CCNP,CCIE

Post #96140
Posted Wednesday, February 03, 2010 6:50 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 1:29 PM
Points: 92, Visits: 209
Sorry if I am late with this but Brent Ozar has very good description of what to do if you nave ability and time for that: http://www.brentozar.com/archive/2009/05/san-multipathing-part-1-what-are-paths/

Alex Prusakov
Post #858605
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse