locked
Skype for Business - SQL Capacity planning RRS feed

  • Question

  • Hi all,

    My DBA is asking for specifics for the SfB deployment in terms of databases sizes and capacity planning. We have around 1800 employees. I cannot find much info with regard to SQL requirements, instances, IOPS and capacity planning?

    Any info on this would be appreciated. 


    matt barnes

    Thursday, August 3, 2017 8:47 AM

All replies

  • Hi BD2013,

    The only information you will find is from the technet.

    https://technet.microsoft.com/en-us/library/gg615015.aspx


    regards Holger Technical Specialist UC

    Thursday, August 3, 2017 7:02 PM
  • Hi BD2013,

    Based on your description, you have 1800 employees for SFB enterprise edition, is that right?

    Per my knowledge, recommended hardware for Front End Servers, Back End Servers, Standard Edition servers, and Persistent Chat Servers:

    Moreover, you could use Skype for Business Server 2015 Capacity Planning Calculator, it will help you determine server requirements based on the number of users and the communication tools your organization uses, the following document is for your reference

    https://technet.microsoft.com/en-us/library/mt695947.aspx


    Regards,

    Alice Wang


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Alice-Wang Monday, August 14, 2017 9:01 AM
    Friday, August 4, 2017 2:22 AM
  • Hi Alice,

    Im familiar with this document, but there seems to be a lack of information in terms of specific SQL information. Even the capacity planner just tells you how many SQL servers you will need. I was looking for something more geared towards database usage so we can determine whether we will need a new SQL server or whether it can installed on our existing. Im also not sure whether it requires 3 instances on 1 server, or whether they are split between Backend database and front end servers. 

    Thanks


    Matt


    matt barnes

    Friday, August 4, 2017 8:19 AM
  • You can use "Archive Sizing" as a base to stipulate your capacity planning for SQL; at least it could give you some ideas.  

    https://technet.microsoft.com/en-us/library/gg398191(v=ocs.14).aspx 

    Saturday, August 5, 2017 4:14 AM
  • Hi BD2013,

    What't the status of this issue, are there any update?


    Regards,

    Alice Wang


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, August 28, 2017 9:03 AM