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.
You can disable Autoshrink by running the command ALTER DATABASE <dbname> SET AUTO_SHRINK OFF
.
SQL Inventory Manager Discover and visualize your SQL Server environment. | | | | | | | |