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
33 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
A procedure for exporting installed hotfix details of remote computers using powershell
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…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

910 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