SQL Express Limitation in a Multi-tenant Environment

ararat85

Dear All,

We are planning to implement a NAV2018 multitenant environment and considering SQL Express to go with it. I wonder if the restriction of 10 Gb per database stands for customer databases or is it the total size of every customer databases related to the application database.


Thanks and Regards,
Ararat

Juhl

Express is limited to 1GB of memory pr. instance.
Multitenant runs on same sql instance, so all nav instances has to share 1GB of memory.

That could be a problem.

Juhl

Its Per database. But the memory restriction is NOT!

ararat85

Juhl wrote: »

Its Per database. But the memory restriction is NOT!

Thanks for the answer but can you elaborate a bit, please? Thanks.

Juhl

Express is limited to 1GB of memory pr. instance.
Multitenant runs on same sql instance, so all nav instances has to share 1GB of memory.

That could be a problem.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

Juhl

You got 1gb if memory to share amongs all tenants!