Details
-
Bug
-
Resolution: Fixed
-
Test Blocker
-
None
-
None
-
None
Description
The depiction of index residency to trigger error 5390 is accurate and easy to follow but what isn't in the section is detail about how to avoid it and states when it may happen again, etc.
Per Bingjie it seems that index scans would improve the resident ratio and allow the statistics update to work. Also indexes which become much less used could trigger again in the future.