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?

3 replies

null
    • smason
    • 2 wk ago
    • 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
    • 2 wk ago
    • 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?

      • smason
      • 2 wk ago
      • Reported - view

      Without having tested it to be sure, it is doubtful that it would attempt to re-insert old events. It's not like a calculation that can buffer if the Historian is unavailable. If you know deleting records locks up MSSQL, I would recommend turning the Calcs service off before doing so, that way you don't miss any events that may occur while it is down.

Login to reply

Content aside

print this pagePrint this page
  • 1 Likes
  • 2 wk agoLast active
  • 3Replies
  • 31Views
  • 3 Following