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.

 

IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >
  • No labels