In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
Backend SQL server hardware requirement for Lync server databse for 3000 users. Including archiving monitoring databse as well.
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.
Who is Participating?
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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month6 days, 9 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
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.