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

Question

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

fasttrack2

Mr or Mrs. 500

Points: 537
More actions
January 28, 2014 at 5:58 am

#285048

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

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 Mr or Mrs. 500 Points: 537 More actions · Answer 2

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 SSC Guru Points: 234013 More actions · Answer 3

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 SSC Guru Points: 1004307 More actions · Answer 4

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.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

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" 😉