troubleshooting Question

Sharepoint 2016 - all-in-one-server vs. two servers

Avatar of McKnife
McKnifeFlag for Germany asked on
Microsoft SharePointMicrosoft SQL Server
23 Comments2 Solutions319 ViewsLast Modified:
Hi experts.

We are testing sharepoint 2016. For the test, we installed sharepoint together with SQL on a single machine and it works very well.
In a training seminar, Microsoft-certified specialists had set up a test lab environment with two servers, one sharepoint, the other SQL - in between: Gigabit ethernet.
If I compare the performance while using sharepoint on the test lab to our "all-in-one" installation, the 2-server-setup felt sluggish as hell, really. The hardware however was comparable to our hardware.

Questions:
1 is the performance  expected to be better when using sql and sharepoint on the same machine? (I guess it depends on what you do with it)
2 if we chose to use an all-in-one machine, could we decide to change that setup someday and switch to a 2-server-setup without starting from scratch?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 23 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 23 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros