Troubleshooting Database Churn

Database transaction issues are not a common problem. If you experience a performance problem with your storefront, there are several other areas you might want to check before looking at the Object Churn Trends report. See also Troubleshooting Salesforce B2C Commerce Performance.

Below is an example of the object churn trend report:

Using the Object Churn Trend Report

The object churn trend report is available on your Production instance. You can use it to see spikes in database operations related to creating, updating, and deleting objects in the database.

If you have experienced a problem in performance and you suspect it might be because of a database deadlock or a spike in database transactions, do the following:

  1. Identify any code or data changes made immediately prior to the problem you experienced. If they are related to a specific object type, check the box for that object type. Otherwise, check the box for Session and Basket, because session and basket data are often involved in database churn.
  2. In the calendar control, click the date on which you experienced the problem.
  3. Select the Daily Report tab and drag the time slider handles so that there is several hours worth of data on either side of when you experienced the problem. As you change the time frame on the graph, the values shown in the dynamic value axis dynamically change to match the maximum value represented in the graph.
  4. Look for distinct changes in trend for key object events, such as basket creation or basket updates. If a specific object shows a noticeable change in churn trend, examine the recent code and data changes related to that object. It might also be useful to interpret the trend in relation to the Session object for comparison purposes.

    Seeing the number of sessions in relation to specific objects shows you how many of the object are being created, updated, or deleted per session. For example, If you know the average number of carts created for your site, as indicated by the metric ‘Cart Rate’ ( A Cart Rate of 25% means that one in every four sessions create a Basket object), then your basket trend line should be at the 4th quartile from where your session trend line is.

    However, if trend lines for baskets are close to the trend line for session creation, then the number of baskets created is close to the number of sessions created. You are most likely automatically creating baskets for the session, rather than when a customer adds a product to the cart. This indicates that you have many unnecessary baskets that could be causing a performance problem. In the previous example, if the blue and red lines were close together, this would indicate a problem with unnecessary baskets.
    Note: If you select two objects for the graph, but only one has data, only the object that has data shows up in the legend.

Data point Details

If you want more detailed data, hover a data point on the graph to see a summary of the database transactions for that data point.

Real time Data

Use the Real Time Trend tab to see data from the last hour in near real-time. This graph automatically updates.

Related Links

Troubleshooting B2C Commerce

Site Performance

Analytic Reports: Object Churn Trends

Best Practices for Improving Site Performance

Tools for Improving Site Performance