[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


SharePoint - should I make it a seperate instance on an existing SQL Server?

Posted on 2015-01-19
Medium Priority
Last Modified: 2015-01-20
We will deploy the latest SharePoint Foundation (60+ users) but we do not know if we should make a separate instance for SharePoint on our existing SQL Server 2008 R2 to save SQL licensing or buy a new SQL Server dedicated to SharePoint which can cost quite much.
At this moment, our existing SQL Server 2008 R2 is only used for our business critical ERP software (20+ users). The ERP databases have confidential financial data. If we make a separate instance for SharePoint, we are concerned that the SharePoint admin/programmer will get into them, as he would like to have local admin privilege to the server running SQL Server 2008 R2.
Also, we are concerned that his work (development, testing, administration) on SharePoint may affect our ERP software which is very critical for the business.

I am wondering if anyone has experienced the same dilemma as us? Or maybe we should simply spend some money to get a new dedicated SQL Server for SharePoint?
Any thoughts?

Question by:techcity
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 44

Accepted Solution

Rainer Jeschor earned 2000 total points
ID: 40558661
if your ERP system / SQL server is mission critical AND you have concerns in regards to confidentiality, then there is no other way than running the SQL server for SharePoint on a dedicated system.
The admin of SharePoint has to have local admin rights and if your SQL server for your ERP is configured to have local admins as sysadmin members, then the SharePoint admin will get access to the server.
It depends a lot what you want to do with your SharePoint installation. You might want to use the SQL Express edition (free) if you can live with the limitations it has (1 CPU, 10GB database size, harder scale out afterwards). Please do not run a standalone installation but a server farm installation where you install all on the same box (if you want to save Windows Server licenses).
The biggest issue I see is that you speak of one SharePoint installation, but you will have to have at least two of them. One for dev, testing, patch testing, ... and one for production.
Just my 2ct

Author Comment

ID: 40558701
Thanks Rainer for the prompt comments!
And I have two questions about your comments if you do not mind
1. The major function for our SharePoint is workflows, we have over 30 of them. If we do server farm installation (all on the same box), how much will this compromise the performance considering we have 60+ users?
2. Per your suggestion,  we should do 2 installations, one for dev/testing/patch, and one for production. but this will double the licensing on SQL and Windows server. Do you have any ideas how we can save some on this?
LVL 44

Assisted Solution

by:Rainer Jeschor
Rainer Jeschor earned 2000 total points
ID: 40558775
That depends on what the workflows are doing/executing and what resources your box has. Are you running SharePoint designer workflows or coded ones (new workflow engine)?
A four core with 32GB RAM should normally do the trick in your case, but SharePoint is a little beast in regards to resources.
Free bonus:
Please have an eye on the SQL server installation, as normally this one is run as ootb - and this can cost a lot of performance (separating tempdb, data files, log files ...).
Imho you might be able to run your test/dev installation on SQL Express which adds just a Windows Server license to your bill. Can you afford an interuption of your workflows for a couple of days? Can you afford a workflow running amok due to a patch? If yes, you might be OK with one system - but I would never ever in my life recommend such a setup or as a consultant run a project without written statement from the customer that he really understand and accept the huge risks.
Free bonus:
SharePoint is a real platform. It offers a great toolset, but as with all tools - you have to know exactly when to use what tool in which way (e.g. you can use a screwdriver to drive in a nail - but a hammer might have been the better tool :-))


Author Closing Comment

ID: 40560891
Great information, you are a real expert!
Thanks again!!

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question