MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SharePoint in a common SQL Cluster?

  Asked By: Alisha    Date: Mar 07    Category: MOSS    Views: 1094

Currently our SharePoint farm uses a 2 server SQL Cluster
(Active/Passive). We are looking at the idea of having a large SQL
Cluster that will house all our other DBs that are used for other apps.
It was brought up as to the feasibility of rolling the SharePoint
cluster into that same environment.

My first thought was that I would rather keep it separate, though I have
no data that says it wont work.

I am wondering if anyone else has tried to do this, and if so what the
results were?



2 Answers Found

Answer #1    Answered By: Brinda Bca     Answered On: Mar 07

It depends. There's no reason why SharePoint cannot "share" a SQL Cluster. If
you're going to do that, here are some things I'd suggest:

- Separate disks/shelves/volumes (if you're using a SAN) for the
SharePoint db's (basically - don't use one disk (as presented in the os) to
store all of the databases).

- Consider using a separate instance of SQL. This will give you a
better administrative boundary.

- Consider capacity planning. Don't put all of your heavily used
databases on a SQL Cluster without making sure you have the appropriate hardware
to back it up.

Answer #2    Answered By: Ruchir Satam     Answered On: Mar 07

We are doing the reverse. I have had a single cluster for 3 years now and we
are removing the SharePoint dbs and building a new cluster exclusively for

Our reasons are that the dbs are getting large (500GB) and going to a new
cluster will allow us to use SQL 2008 with Snap technology on our NetApp to
improve backup times. The amount of memory allocated for the sharepoint
instance is too low. I believe it is only 12 GB and MS suggests starting around
24GB. The new cluster will have 48GB. SharePoint is a chatty application and we
feel it it taking away performance from other applications on the cluster. We
did a series of performance tests and found that SharePoint could be optimized
better if it had it's own cluster.

Didn't find what you were looking for? Find more on SharePoint in a common SQL Cluster? Or get search suggestion and latest updates.