on 2022 Jul 22 5:51 PM
In SAP CCV2, we are planning on associating a lot of text data with a user, more than likely an array of CLOBs. Wondering are there any capacity limits to be aware of.
Thanks,
Request clarification before answering.
On CCv2 system a single databases using the DTU purchasing model is used. You can find the limits here https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-single-databases?view=...
For productions systems the premium service tier is the one you should look at. (Standard config is P2 can be scaled up to P15).
Development and staging environment using a database from Standard service tier I think S2 respectively S4.
For datatypes and size restrictions you can have a look at https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16 (a clob would be VARCHAR(max))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
19 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.