Is SQL Server Express 2008 R2 supported for Appian ? We have a proposed 20 user

Is SQL Server Express 2008 R2 supported for Appian ? We have a proposed 20 user site.
I have tested it in a Dev environment without issue but would like some feedback on SQL Express for a production environment.
...

OriginalPostID-64644

OriginalPostID-64644

  Discussion posts and replies are publicly visible

Parents
  • Thanks Alok, apart from the 10GB database restriction, 1GB memory limit and the lack of lightweight pooling, are there any other issues you have encountered in testing ? This should not affect the Appian performance directly as there is a small amount of data they will be utilising in Tempo and the Business Db.
    We have been running it successfully in a dev environment as we want to simplify the client's upgrade path to SQL Std edition when they scale their installation to a larger user base, rather than implementing MySQL.
Reply
  • Thanks Alok, apart from the 10GB database restriction, 1GB memory limit and the lack of lightweight pooling, are there any other issues you have encountered in testing ? This should not affect the Appian performance directly as there is a small amount of data they will be utilising in Tempo and the Business Db.
    We have been running it successfully in a dev environment as we want to simplify the client's upgrade path to SQL Std edition when they scale their installation to a larger user base, rather than implementing MySQL.
Children
No Data