Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

REASON

IDERA SQL Inventory Manager has detected that Autoshrink is enabled on one or more databases. This configuration option causes significant performance problems and it is a best practice to disable it for all databases.

RESOLUTION

You can disable Autoshrink by running the command ALTER DATABASE <dbname> SET AUTO_SHRINK OFF.

...