Database Configuration

Report Purpose

This report shows database properties such as auto close, auto stats etc.  It also shows all database files.

Data Collection

  1. The data is collected in file *_MiscPssdiagInfo_Startup.OUT.  Example file:  MyServer_MyInstance_MiscPssdiagInfo_Startup.OUT
  2. The data is identified as “--sys.databases_ex—--““--database files--“

Technical Details

  1. The chart will color code (red) for any databases that have auto update or auto create stats disabled
  2. tbl_DatabaseFiles and tbl_SysDatabases contain data for this report

 

 

image