locked
OCS Database Size RRS feed

  • Question

  •  

    We just deployed OCS 2007 Standard Edition, which only uses SQL Server 2005 Express Edition. I understand their is a limitation of 4 GB of size for a database in the Express Edition.

    We are planning on having about 3,000 users in our OCS environment. Initially we are only planning on enabling, Presence, IM (Federated & PIC).

    What I would like to know is does anyone have any idea how large an OCS database will get for about 3000 users?

    Thursday, December 4, 2008 2:26 PM

Answers

  • Have a look at the planning guide for Supported Maximum users per topology

    STD Edition can handle up to 5000 users

     

    Table 30 Maximum Supported Users for each Topology

    Topology

    Servers Required

    Maximum Users Supported

    Standard Edition Server

    1 Standard Edition server

    (Optional) Archiving Server collocated

    5,000

    Enterprise pool: Consolidated Configuration

    4 Enterprise Edition Front-End servers running all server roles

    1 Backend SQL Server

    (Optional) 1 Archiving Server

    30,000

    Enterprise pool: Expanded configuration

    With Mid-Range Performance SQL Backend

    4 Front-End Servers

    2 Web Conferencing Servers

    2 A/V Conferencing Servers

    2 IIS Servers

    1 Backend SQL Server

    (Optional) 1 Archiving Server

    50,000

    Enterprise pool: Expanded configuration

    With High Performance SQL Backend

    8 Front-End Servers

    4 Web Conferencing Servers

    4 A/V Conferencing Servers

    2 IIS Servers

    1 Backend SQL Server

    (Optional)2 Archiving Servers

    125,000

     

    http://www.microsoft.com/downloads/details.aspx?FamilyId=723347C6-FA1F-44D8-A7FA-8974C3B596F4&displaylang=en

    Thursday, December 4, 2008 6:13 PM

All replies

  • The OCS databases do not contain a great deal of information.  For 3000 users you are looking at under 1gb of data.  If your main goal is to determine whether or not you can safely use SQL Express then the answer is definitely yes.

    Thursday, December 4, 2008 4:24 PM
    Moderator
  • Have a look at the planning guide for Supported Maximum users per topology

    STD Edition can handle up to 5000 users

     

    Table 30 Maximum Supported Users for each Topology

    Topology

    Servers Required

    Maximum Users Supported

    Standard Edition Server

    1 Standard Edition server

    (Optional) Archiving Server collocated

    5,000

    Enterprise pool: Consolidated Configuration

    4 Enterprise Edition Front-End servers running all server roles

    1 Backend SQL Server

    (Optional) 1 Archiving Server

    30,000

    Enterprise pool: Expanded configuration

    With Mid-Range Performance SQL Backend

    4 Front-End Servers

    2 Web Conferencing Servers

    2 A/V Conferencing Servers

    2 IIS Servers

    1 Backend SQL Server

    (Optional) 1 Archiving Server

    50,000

    Enterprise pool: Expanded configuration

    With High Performance SQL Backend

    8 Front-End Servers

    4 Web Conferencing Servers

    4 A/V Conferencing Servers

    2 IIS Servers

    1 Backend SQL Server

    (Optional)2 Archiving Servers

    125,000

     

    http://www.microsoft.com/downloads/details.aspx?FamilyId=723347C6-FA1F-44D8-A7FA-8974C3B596F4&displaylang=en

    Thursday, December 4, 2008 6:13 PM
  • Enabling chat archiving is where your database size grows, and the need for a different SQL instance, etc. etc.

    The SQL hardware requirements have changed between R1 and R2 and you'll need a bigger, beefier box.

     

     

    Jason Collier

     

    Monday, January 26, 2009 10:27 PM