cancel
Showing results for 
Search instead for 
Did you mean: 

SAP CCV2 User Data Limits

0 Kudos
207

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,

Accepted Solutions (0)

Answers (1)

Answers (1)

christoph_probst
Active Participant
0 Kudos

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))