Troubleshooting Database Churn

The Object Churn Trends report can help identify database transaction issues.

Database transaction issues are not a common problem. If you experience a performance problem with your storefront, investigate other areas first.

Here 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 performance problem, and you suspect a database deadlock or a spike in database transactions, do the following:

  1. Identify any code or data changes made immediately before the problem occurred. 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.
    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.
  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 to select several hours worth of data on either side of the problem. As you change the time frame on the graph, the range of the dynamic value axis changes to match the maximum value represented in the graph.

Look for distinct trend changes 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 can 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 your site’s Cart Rate metric (average number of baskets created per session) is 25%, it indicates that 25% of sessions create a basket. In that case, your basket trend line is at the fourth quartile of your session trend line.

However, if the basket trend line is close to the session creation trend line, then the number of baskets is close to the number of sessions. Your site probably automatically creates a basket for each session, rather than only when a customer adds a product to the cart. That 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, it would indicate a problem with unnecessary baskets.

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.

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used. By continuing to use this site you are giving us your consent to do this. Privacy Policy.