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

Last edited Sep 25, 2014 at 2:47 PM by jackli, version 4

Comments

No comments yet.