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.



SQL Inventory Manager Discover and visualize your SQL Server environment.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal



  • No labels