Ind write

Index writes per second.

Higher than expected values can indicate unnecessary indexes.

When a write operation is made to a table, this counter is incremented for each index that must be updated.

Ind nomrg write

Number of nonmerged rows (committed and uncommitted) in the Bonsai tree. This counter applies only to disk-based tables.

High or growing values means the Bonsai tree is too large.

This counter is essentially the size of the Bonsai tree. If this counter is large or is constantly growing, performance is affected because the Bonsai tree consumes more database cache. This leaves less room for data caching and might ultimately cause disk paging.