SecurityInsight settings · Settings > Data & retention

Slow down large writes when the database is busy

Key	SI_SqlPacing_Enabled
Where	Settings > Data & retention > Database write pace
Type	On / off
Default	On
Edition	Community

What it does

Whether the large database writers (Risk Analysis storing its findings, the data sync preparing the views, the removal of old collections) look at how busy the database is before each batch.

When enabled

while the database is at its limit (log write, data reads or CPU above the high mark), each writer pauses before its next batch and writes smaller batches, so the web app and the other jobs keep a share; below the low mark it writes at full pace again. Nothing is left out -- the same rows are written, only slower while the database is saturated.

When disabled

the writers always write at full pace.

Risk and how to reverse it

Off: on a busy database the large writers keep it at its limit for as long as the daily run writes, and the web app is slow meanwhile. No data is changed either way. Reversible at once.

Requires

Nothing else.