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
28 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
  • 5
  • 3
9 Comments
 
LVL 39

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 39

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
 

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
Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

 
LVL 39

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 39

Expert Comment

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

Expert Comment

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

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
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…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now