?
Solved

Sharepoint setup question

Posted on 2014-11-21
3
Medium Priority
?
178 Views
Last Modified: 2014-11-24
I have a VM, 2012 R2 with sharepoint 2013 on it.  I did a single server install where SP and SQL are on the same server. The VM has tons of resources!

It's slow!

I was told that sharepoint and SWL on the same box is bad and that my speed issue is related to the single server install.

I'm looking for thoughts on that.  Can I do a single server install for production or should I split them up?

What's a best practice for a production Sharepoint server?

Thanks

Cliff
0
Comment
Question by:crp0499
[X]
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
3 Comments
 
LVL 7

Accepted Solution

by:
Ray earned 2000 total points
ID: 40458297
It's all depends on many factors (number of users, number of SP sites etc).  We have clients started with a single box and add more servers to the farm or move to a standalone SQL box at a later time when needed.  

With SQL and SP on the same box, make sure you limit the max memory on the SQL server.  As far as CPU, check the resource monitor and added more as needed.   With 10 users and 10 sites; 16 CPU and 32GB RAM seems to be a good start.

Here're some guideline and best practices for virtualizing and managing SharePoint 2013
http://download.microsoft.com/download/0/0/1/001ADCCC-A45B-47E3-8DA4-ED51E3208021/Best_Practices_for_Virtualizing_and_Managing_SharePoint_2013.pdf
0
 

Author Comment

by:crp0499
ID: 40458395
We have one VM, 4 CPUs and 16 gigs RAM on fast storage.  We will support one site and 20 users.  Very small implementation.

BUT, the site is slow and sluggish.  I was told it was because the SP and SQL were on the same box.

From what you are telling me, it seems fine for our use.
0
 
LVL 7

Expert Comment

by:Ray
ID: 40458478
Both SP and SQL are resource demanding applications.  If you have Web App enabled (Allow user to edit Word/Excel via browser), you will need more resources.  You should increase the CPU to 16 and RAM to 32 GB; monitor the server performance and adjust accordingly.

Remember to limit the MAX RAM for SQL and setup SQL tuning (Index/Stats update). For SP Search/Crawler, schedule the full crawl after hours and incremental every few hours (depends on your requirement).  Only turn on the required SP services and farm features.

In a ideal world, running it on a web farm and SQL cluster will provide  high availability and scalability.   With the scalability of the SP farm, it will be possible when needed.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

765 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