Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


MULTI-Instance SQL 2008 R2 Cluster (same LUN can be shared between different Instance?)


MULTI-Instance SQL 2008 R2 Cluster (same LUN can be shared between different Instance?)

Author
Message
fasttrack2
fasttrack2
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 179
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
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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" ;-)
fasttrack2
fasttrack2
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 179
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
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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" ;-)
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45147 Visits: 39923
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. :-D

--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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
Jeff Moden (2/2/2014)
Me too! That way, I can just turn them off and call it a day. :-D

Whatever floats your boat :-D

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search