Do database restart affect create Index suggestion? If I restart database then right after running the sp_BlitzIndex @GetAllDatabases = 1 is it going to give an accurate index statistic? If no, how long do we need to wait after restart database to get accurate index statistic?

We are using MSSQL 2008 R2 enterprise edition.

  • Are you asking if a restart will change your indexes and statistics? Or if it clears the system tables that track missing index data? – Zane Dec 4 at 18:00
  • 2
    Assuming that sp_blitzindex uses the DMV's when executed to get it's recomendations it's likely to not return any index recomendations immidiately after a restart as the DMV's are cleared out. – Zane Dec 4 at 18:22

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.