We've noticed on one of our servers, that after some time queries are falling to full table scan, seems due the outdated statistics. SQL Server is quite busy, receiving hundreds of queries/row modifications per minute, can it be a reason, why statistics are not updated?
We noticed, that if we stop the app, statistics get updated, hence wondering if there might be a case that SQL Server does not find a window or something to update statistics, or that is not possible and there's another reason hiding?
Manually triggering statistics update works, but I would like to avoid scheduling periodic statistics update if possible, as I did not find information that statistics update would be prevented because of stream of selects/inserts/updates.
Update: Auto statistics update is enabled