1

Events Table Optimization

Forum / Questions & Answers

We are trying to optimize performance of the Events and Event Properties table, is it advisable to add Indexing and table partitions to achieve this?

2 replies

null
    • smason
    • yesterday
    • Reported - view

    Hi ,
    We've never had anyone try this so I can't say it is advisable. We try to optimize the events table as much as we can. Manipulating this database could potentially create undesired outcomes which may make it harder to maintain and troubleshoot.

    • derrick
    • yesterday
    • Reported - view

     , thank you for your response, based on previous experience, when we try to prune or delete records (say like records older than 3 years) from a table with a lot of records, we have noticed that the 'Delete' operations tends to deadlock the MSSQL service, when this happens will Canary's events be stored in queue and then be re-inserted when MSSQL is available or will they be lost?

Login to reply

Content aside

print this pagePrint this page
  • 1 Likes
  • yesterdayLast active
  • 2Replies
  • 20Views
  • 3 Following