Database Configuration
Report Purpose
This report shows database properties such as auto close, auto stats etc. It also shows all database files.
Data Collection
- 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--“
Technical Details
- 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
