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 Database using SAN Expand / Collapse
Author
Message
Posted Thursday, December 26, 2013 8:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 20, 2014 7:39 PM
Points: 3, Visits: 16
Do i need to Add the SYSTEM Databases the .mdf of ( Master, msdb, temp etc) to the Storage? please help me thank you masters
Post #1526072
Posted Friday, December 27, 2013 7:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:16 AM
Points: 1,270, Visits: 2,784
Not sure exactly what you are asking. Are you moving data from internal drives to a SAN? Is the server clustered or a standalone install? What version of SQL Server?


Post #1526137
Posted Sunday, December 29, 2013 1:40 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,304, Visits: 13,601
niver (12/26/2013)
Do i need to Add the SYSTEM Databases the .mdf of ( Master, msdb, temp etc) to the Storage? please help me thank you masters

You can move all paths to the SAN storage if you wish, just ensure you update any path dependencies within sql srever.
For example log path locations for sql agent jobs, etc and the full text default location


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1526366
Posted Thursday, January 2, 2014 5:25 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:34 PM
Points: 15,661, Visits: 28,051
If you want the redundant storage that a SAN gives you, yes. If you want faster performance for the system databases, you might consider local storage. Everything is a tradeoff.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1527050
Posted Thursday, January 2, 2014 5:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,304, Visits: 13,601
Grant Fritchey (1/2/2014)
If you want faster performance for the system databases, you might consider local storage.

Unless its an FCI then you are required to use shared storage not local


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1527058
Posted Thursday, January 2, 2014 5:53 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:34 PM
Points: 15,661, Visits: 28,051
Perry Whittle (1/2/2014)
Grant Fritchey (1/2/2014)
If you want faster performance for the system databases, you might consider local storage.

Unless its an FCI then you are required to use shared storage not local


100% true. But, you probably wouldn't be asking about where to put storage if you had no choice in the matter.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1527066
Posted Thursday, January 2, 2014 7:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,304, Visits: 13,601
Grant Fritchey (1/2/2014)
100% true. But, you probably wouldn't be asking about where to put storage if you had no choice in the matter.

Sure, about the only time is when migrating data between LUNs


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1527100
Posted Thursday, January 2, 2014 11:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 20, 2014 7:39 PM
Points: 3, Visits: 16
yes it is a FC connection, but what im looking for is an implementation that all the sysdatabases and production databases is located to the SAN and what is the advantages and disadvages thank you very much
Post #1527356
Posted Friday, January 3, 2014 12:14 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:31 PM
Points: 466, Visits: 1,914
I store them on local drives and make sure they are backed up each night. Keeping them on a local drive, other than the OS drive is still better.

Thanks
chandan
Post #1527360
Posted Friday, January 3, 2014 1:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,304, Visits: 13,601
niver (1/2/2014)
yes it is a FC connection, but what im looking for is an implementation that all the sysdatabases and production databases is located to the SAN and what is the advantages and disadvages thank you very much

Its perfectly viable to use consolidated\shared storage, certainly makes storage management easier.
Having the system databases on local disk means that if you lose the San sql will likely stay online but then what good is this if you have lost all user dbs?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1527372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse