When configuring a new instance of Sitecore XP or maintaining an existing one, you may encounter a situation where your interactions report shows far fewer interactions than expected.
One possible cause is interaction processing which hasn’t kept up with the interactions being logged on your website. In some cases this can be so slow that it appears collection, processing, and reporting aren’t working at all. Here are a few things you can look at to help you diagnose your issue.
Are interactions being recorded?
SELECT TOP 10 * FROM xdb_collection.Interactions ORDER BY StartDateTime ASC
Run this command in each of your shard databases to see the recent interactions which have been recorded. Compare the interactions being logged with the expected number and frequency of interactions in the environment you’re looking at.
How many interactions are waiting to be processed?
SELECT COUNT(*) FROM xdb_processing_pools.InteractionLiveProcessingPool
This command will indicate the number of interactions waiting to be processed. Monitoring the number of records in this table can give you an indication of the number of new records being created and the number of new interactions which are being queued for processing.
If the number of records is steadily building up, either processing isn’t working or it’s working too slowly to handle the workload.
If you’re collecting interactions but not seeing the size of the live interaction processing pool change at all, there might be an issue with aggregation.
This blog post is intended for those of you who would like a high level overview of Sitecore 7.5, need a reminder or have not had the time to investigate this release. At the bottom of this post is a list of useful resources related to Sitecore 7.5.
Sitecore 7.5 = Sitecore 7.2 + xDB.
xDB (Experience Database) is the new name for the Analytics database.
New Contact entity allows tracking an individual across devices, visits and cookies.
Requires some sort of mechanism of identifying the user( login, form submission, checkout etc)
New scalable analytics data architecture
Session DB (private and shared) (inProc, Sql or Mongo)
Collection DB i.e. xDB (Mongo)
Reporting DB (SQL)
Experience profile (xFile) i.e the contact
Sitecores cloud hosting offering for xDB
Pricing based on numbers of stored contacts.
Data stored in documents not tables
Collections of documents rather than tables with rows.
Scales horizontally not vertically
Data stored in BSON binary Json
Upgrade key points
Analytics API has many small changes
Migration of data from Analytics DB to xDB i.e. SQL to Mongo