What is a one sentence summary of your feature request?
Have a new Analysis Status table that can show last USN run times for Analysis so they can be rewritten to only recalculate where we have new data.
Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.
Given larger clients can take weeks and months to cycle through a complete scan of their environment if we had a status table that had a format something like:
JobName
AnalysisName
Host
FSAAUSN
SEEKUSN
FSACUSN
The Analysis could then be rewritten to only process the data for servers where the data has been updated since the last analysis saving SQL Processing and SQL Drive usage.
How do you currently solve the challenges you have by not having this feature?
In some instances I’ve rewritten the report to use a cursor loop to avoid maxing TempDB usage and for others done similar to what I’ve suggested here.
Naturally if we move to always on scanning without importing then we need to figure out how reporting is going to work (appreciate clients probably want a point in time report that multiple people can look at rather than a persistently dynamic report where the numbers are in flux)