Solved

Backend SQL server hardware requirement for Lync server databse for 3000 users. Including archiving monitoring databse as well.

Posted on 2016-09-01
9
50 Views
Last Modified: 2016-10-30
I need to get hardware recommendation for SQL server for Lync 2010 ent ed for 3000 users.

What would be the configuration for 3000 user
How much ram,CPU and hard disk i required for sql server to host Lync database.

Virtual as well as Physical recommendation

Any help would be highly appreciated.
0
Comment
Question by:07VASH
[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
  • 5
  • 3
9 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 41780623
According to Microsoft "The following table describes the recommended hardware for a Back End Server or other database servers, based on a 80,000 user pool with eight Front End Servers and one Back End Server with all databases required for your Lync Server deployment running on a single database server."


Hardware component Recommended

CPU
 One of the following:

•64-bit dual processor, quad-core, 2.0 GHz or higher
•64-bit 4-way processor, dual-core, 2.0 GHz or higher

Memory
 
32 GB recommended for Back End Server (with or without collocated Archiving and Monitoring databases), 16 GB recommended for Archiving and Monitoring database (not collocated with the Back End Server).
 

Disk
Local storage with at least 72 GB free disk space on a 10,000 RPM disk drive
 

Network
 
1 network adapter required (2 recommended), each 1 Gbps or higher
 
all from here: https://technet.microsoft.com/en-us/library/gg398835(v=ocs.14).aspx

Now..if you lok at 3000users VS. 80000 these requirements seem a bit to high but....considering you want specs for VM as well I believe the 32GB of RAM exceeds the 16GB RAM that VMware can properly handle so...

I would stick with (at least) 8CPU and 32GB RAM on physical for the SQL backend server and you can have the Archiving and Monitoring database on a VM with 8CPU and 16GB RAM.
0
 

Author Comment

by:07VASH
ID: 41780697
Hi,

Thanks for your response. the artical says it is for 80000 user . so can i have 4 cpu with 16 GB ram to have 3000 user or lesser hardware like 2 cpu and 8 Gb RAM to support 3000 user on backend sql.

if i go for virtual sql then it is good that i can have 4 cpu and 24 Gb ram to support 3000 user. Please guide me if i am guessing wrong here.
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 41781601
Honestly it is really really difficult to give the exact specific answer about MAX capacity you need however...I would never just use simple math division to cut the already minimum specs given by Microsoft right? What they offer at link above is purely minimum requirement to run the software and usualy when we dimension hardware for UI or backend database we don't just go with minimum.

On another side, let think that you set it up as VM for Back End Server and you set it with 8 CPU's and 16GB RAM which is kind of the MAX that VM can handle well so you get expected performance but....you find that you need more RAM then what you do? adding more to the VM(ware) will not help as beyond that value...is not working well so is up to you to document both options and make up your case for one or the other based on requirement.

Again, in my opinion a physical with (at least) 4*2 OR 2*4 = 8CPUs and MIN 32GB RAM it will be better to handle both Back End Server and collocated Archiving and Monitoring databases than 2VMs of 4CPU and 16GB RAM each.

Again, this is just from my experience that VM's don't handle well more than 16GB RAM for instance running Vcenter with ESX 5.5 we currently use on hosts with 64CPU + 320GB RAM each.


And BTW - I can say 1000000% that I would NEVER run a SQL Server (maybe dev/express edition on my laptop for some R&D work) on a " like 2 cpu and 8 Gb RAM on backend sql." in order to support 3000 users even though is just for Lync back-end.
0
Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

 

Author Comment

by:07VASH
ID: 41784364
Thanks for your response and suggestion. but if i want to design the Lync infra for 5000 user what is the best way to design with server and hardware.IF you have any guide or document or any link from where i can get help that would be very very helpful form me. For backed i will consider your suggestion 32 Gb RAM and 8 core CPU even if we have 3000 user.
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 41786326
I would set my Server Running Lync Server 2010 on a VM with specs below:
CPU:
64-bit dual processor, quad-core, 2.0 GHz or higher OR
64-bit 4-way processor, dual-core, 2.0 GHz or higher
(Intel Itanium processors are not supported for Lync Server 2010 server roles.)
Memory - 16 GB RAM
Disk - Local storage with at least 72 GB free disk space on a 10,000 RPM disk drive
Network - this is on the top of your OS install on C:\ that usually requires 70GB or so and please note this must be some fast 100GB LUN to avoid performance issues.
1 network adapter required (2 recommended), each 1 Gbps or higher. For Edge Servers, 2 network interfaces are required.

And as the server running the Director server role have lesser hardware requirements I would put it on a VM like below:
CPU
64-bit processor, quad-core, 2.0 GHz or higher OR
64-bit dual processor, dual-core, 2.0 GHz or higher
(Intel Itanium processors are not supported for Lync Server 2010 server roles.)
Memory - 4 GB RAM
Disk - Local storage with at least 72 GB free disk space on a 10,000 RPM disk drive - this is on the top of your OS install on C:\ that usually requires 70GB or so.
Network - 1 network adapter required (2 recommended), each 1 Gbps or higher
0
 

Author Comment

by:07VASH
ID: 41786480
Thanks for your help and suggestion.
0
 
LVL 40

Expert Comment

by:lcohan
ID: 41807464
Did you find the answer/configuration you were looking for?
0
 
LVL 40

Expert Comment

by:lcohan
ID: 41828734
Did you find the answer/configuration you were looking for?
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

695 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