I won’t cover why enabling AutoShrink is such a bad idea. There are numerous articles on the web, pointing this out in great detail. However, as a DBA you might want to know how many AutoShrink databases are active on your servers.
List auto-shrink enabled databases – The Script
The powershell script below can help you with this and can be extended to your liking.
Note: Before proceeding it’s important to know that some software vendors require enabling auto-shrink… Yes, believe it or not. Therefore, just disabling this feature might turn into a software support drama (or a comedy, depending on how you look at life).
Well, that’s pretty much it… Of course this is just one of a list of options you might be interesting in.Other options are (Which I will cover in future posts);
- Amount of available disk space .
- Size of Data files and log.
- Has the Database been backed up recently?
- Consistency has been verified recently?
- State in a usable state?
- File size of tempdb
- Auto update statistics enabled?
- Statistics recent?