Track if IIDs are assigned within transaction

What does this MR do?

This adds a metric to track if IIDs are being generated within a transaction that might lead to contention as described in #325861 (closed) and whether the solution is the !57412 (closed).

Does this MR meet the acceptance criteria?

Conformity

• 📋 Does this MR need a changelog?
  • I have not included a changelog entry because internal change.
• Code review guidelines
• Style guides