Home Gitesh Portfolio Blog About Me Gallery Contact

Optimizing Sitecore XConnect: Identifying and Addressing High Interactions Per Contact

SQL query to find amount of interactions per contact. More the number (1000+ of interactions per contact can degrade the performance. 
​SELECT TOP (100) ContactId, COUNT(ContactId) as Count
FROM [xdb_collection].[Interactions]
GROUP BY ContactId
ORDER BY Count DESC


So if you have got interactions more than 1000 per contact , you should purge the interactions which is mentioned in this blog. 
https://www.giteshportfolio.com/blog/sitecore/november-2022/sitecore-delete-xdb-xconnect-collection-data-from-
 

Posted: 18/11/2023 6:28:20 p.m. by Gitesh Shah | with 0 comments


Read/Get a SQL connection s...

Click read more to find the answer...

How to add a user via phpMy...

Click ReadMore to find solution...

Tips on Network Load balancing

Softwares should be same on all the servers (Also recommended to keep hardware's same)
Maximum 32 clusters supported by Microso...

Change database permissions...

Property Owner is not available for Database ‘[test_db]‘. This property may not exist for this object, or may...