This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
COURSE of the MONTH
13 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Backend SQL server hardware requirement for Lync server databse for 3000 users. Including archiving monitoring databse as well.
Posted on 2016-09-01
- Windows Server 2008
- Microsoft Applications
- Microsoft SQL Server 2008
- Server Hardware
- Microsoft Virtual Server
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.
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.
[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
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.
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.
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.
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.
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.
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.
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.
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
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
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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…
A procedure for exporting installed hotfix details of remote computers using powershell
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 …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month13 days, 6 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.