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

MULTI-Instance SQL 2008 R2 Cluster (same LUN can be shared between different Instance?) Expand / Collapse
Author
Message
Posted Tuesday, January 28, 2014 5:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:02 AM
Points: 17, Visits: 109
SQL Server 2008 R2 Ent (On Windows 2008 R2 Ent)

Hi guys,

I am new in clustering.

I would like to create a 2 Node Cluster with 2 instances (1 instances that holds 3 production databases (DB1, DB2 & DB3) and the second instance holds 1 datawarehouse (DW1) and the SSRS 2008 reporting dataabse).

What I am asking is about the External Storage Disk Configuration.
For what I have understood:
LUN 1: Quorum (for Cluster)
LUN 2: DTS


ATTENTION:
The below questions are not to be internded as for performance reasons BUT for technical reason.


1) In a Multi-Instance Cluster:What About for the SQL Instances Installations? (locally? On external Storage? On external Storage on same LUN)
2) In a Multi-Instance Cluster: Can the same LUN hold database disk files belonging to different Instances? (e.g.: LUN3 holds: DB1_mdf/ldf files and DW1_mdf/Ldf Files)
3) In a Multi-Instance Cluster: Is it possible to locate all the System Database files on the same LUN?


Definetely:
Each Instnace needs own disks or the same disk may be shared between several Instances ?

Many thanks
Post #1535397
Posted Tuesday, January 28, 2014 6:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
fasttrack2 (1/28/2014)
1) In a Multi-Instance Cluster:What About for the SQL Instances Installations? (locally? On external Storage? On external Storage on same LUN)

The binaries will be installed locally as will shared components, the system databases and user databases will reside on shared storage


fasttrack2 (1/28/2014)
2) In a Multi-Instance Cluster: Can the same LUN hold database disk files belonging to different Instances? (e.g.: LUN3 holds: DB1_mdf/ldf files and DW1_mdf/Ldf Files)

No, all LUNs\disks assigned to 1 instance cannot be shared by another instance.



fasttrack2 (1/28/2014)
3) In a Multi-Instance Cluster: Is it possible to locate all the System Database files on the same LUN?

I assume you mean all system databases for multiple instances?
If so, then no separate shared storage is required


fasttrack2 (1/28/2014)
Definetely:
Each Instnace needs own disks or the same disk may be shared between several Instances ?

This is the same question as you asked above.
No, all instances must use separate shared storage


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1535419
Posted Tuesday, January 28, 2014 8:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:02 AM
Points: 17, Visits: 109
Hello and many thanks

Definetely my doubts are mitigated.


I still have some doubts about SSRS 2008 R2 and SSIS 2008 R2 on a MULTI-Instance as described above.
I know that either SSRS and SSIS are not clustered aware.

But How to install SSRS and SSIS ? e.g.: SSRS mu be installed on both nodes on the same instance or different instances (same applied to SSIS)?

Many thanks for your help
Post #1535470
Posted Tuesday, January 28, 2014 4:30 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
SSRS can make use of load balanced urls to service an instance on each cluster node. You need to create scaled out deployments of SSRS but its possible.

Personally i prefer a dedicated SSRS server and SSIS server (if you do intend to store, manage and run a large amount of packages).


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1535658
Posted Sunday, February 02, 2014 10:20 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:25 AM
Points: 35,959, Visits: 30,253
Perry Whittle (1/28/2014)
Personally i prefer a dedicated SSRS server and SSIS server (if you do intend to store, manage and run a large amount of packages).


Me too! That way, I can just turn them off and call it a day.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1537198
Posted Monday, February 03, 2014 7:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
Jeff Moden (2/2/2014)
Me too! That way, I can just turn them off and call it a day.

Whatever floats your boat


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

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

Add to briefcase

Permissions Expand / Collapse