Sandbox Data Guidelines fair usage and How to check it

[Romulus]

As documented in SAP Commerce Cloud Service Description, SAP Commerce Cloud offers a variety of different sizes of sandbox environments with their own respective resource limitations.

As such, often one may see an issue starting with Data related aspects of the application if these limitations are not taken in account. E.g.: Import Database backup from higher tier into lower environments, specially in case of Development.

• Most common but not limited issue observed as cosenquence of the above example would be, Solr indexing starting to fail with pods restarting due to Insufficient Memory (OOM Killed).

Therefore, in this case it is worth highlighting the content found in Sandbox Data Guidelines:

• "After rigorous testing, the recommended data volume works well with standard SAP Commerce code in the corresponding environments. If you exceed the recommended data volume limits, SAP can't guarantee resource-related system stability in your sandbox environments, which includes aspects such as service speed, pod OOM/restarts, disk storage, and DTU saturation thresholds."
• In the above document it will be also available to compare each type of Sandbox environment (Dev / Stag) and their respective Data Volume limitations / guidelines.

Now in case you're not sure how to check the sizes of the referred tables from this document, you may perform this simply by accessing your HAC endpoint and running queries to check this Data Volume.

• E.g.: The following groovy script would provide you with the data:

import de.hybris.platform.servicelayer.search.FlexibleSearchQuery;
import de.hybris.platform.servicelayer.search.SearchResult;

FlexibleSearchQuery flexibleSearchQuery=null;
/*Check the size of the given types*/
def types = ["Product","ProductFeature","Cart","Order","User","Address"];
types.each{type->
  query = "select count(*) from {"+type+"}";
  flexibleSearchQuery = new FlexibleSearchQuery(query);
  List l = new ArrayList();
  l.add(Integer.class);
  flexibleSearchQuery.setResultClassList(l);
  SearchResult result = spring.getBean("flexibleSearchService").search(flexibleSearchQuery);
  println type +": " + result.getResult().get(0);
}

[adamreisberg · Accepted solution]

Hi @Romulus 

Thanks for the helpful Groovy Script and link to recommended maximums for CCV2 (SAP Commerce Cloud) sandbox environments.

I'd also recommend utilizing the HAC Azure SQL Schema browser if you are able to understand the mapping of item types to database tables.

• Schema Browser | SAP Help Portal

[Romulus · Accepted solution]

Thanks a lot for your feedback @adamreisberg, I'll make sure to check your recommendation as well!