This report shows database properties such as auto close, auto stats etc. It also shows all database files.
- The data is collected in file *_MiscPssdiagInfo_Startup.OUT. Example file: MyServer_MyInstance_MiscPssdiagInfo_Startup.OUT
- The data is identified as “--sys.databases_ex—--““--database files--“
- The chart will color code (red) for any databases that have auto update or auto create stats disabled
- tbl_DatabaseFiles and tbl_SysDatabases contain data for this report