When should I consider using standard/full SQL instead of SQL express?

Need to understand requirement of Full SQL installation versus express.

8 years ago
SOTI MobiControl
ANSWERS
TB
TJ Bukoski
8 years ago (edited 8 years ago)

SQL Express has the following limitations:

  • 1GB RAM (Same in SQL 2008/2012)
  • 10GB size limit per database
  • Limited CPU usage

From a MobiControl perspective it depends on the environment. If you are collecting a lot of data, uploading a lot of packages or managing a large device count then SQL standard is not only recommended, but a necessity. 

If your device count is low and you are not keeping your collected data then you can get away with using SQL Express.

I consider device counts under 1000 to be small, 1000 to 5000 medium size, 5000 to 10000 to be mid-large and 10000+ as large deployments.