Critical System Protection

 View Only
Back to discussions
Expand all | Collapse all

SCSP – Why is it important to not use the SQL Server Express Editions in a production environment?

  • 1.  SCSP – Why is it important to not use the SQL Server Express Editions in a production environment?

    Posted Sep 19, 2013 12:07 PM

    Still many persons are running CSP with the SQL Server Express 2005 Edition that comes with it in their production environment, so I thought of a little reminder.

    The reason is very simple; SQL Server Express Editions are all limited in size.

    SQL Server Versions

    RTM

    SP1

    SP2

    SP3

    SP4

    Size limitations

    2012

    11.00.2100.60

    11.00.3128.0

     

     

     

    10Gb

    2008 R2

    10.50.1600.1

    10.50.2500

    10.50.4000

     

     

    10Gb

    2008

    10.00.1600.22

    10.00.2531

    10.00.4000

    10.00.5500

     

    4Gb

    2005

    9.00.1399.06

    9.00.2047

    9.00.3042

    9.00.4035

    9.00.5000

    4Gb

    So what can happen once your CSP database is full?

    • Login to CSP Console might fail,
    • Agents will stop sending events,
    • Agents will appear offline,

    etc.

    The purpose of the SQL Server 2005 Express Edition that comes with SCSP is for Evaluation only.

    Therefore, I would strongly recommend the upgrade of the SQL Server to a Standard or Enterprise Edition to avoid these issues, and save time!