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!