Transcript MIST System Management

MIST System Management
Reviewing and further understanding
systems management - using “MIST
2006 Data Cleaning Tools” - running
a “tight” system - data entry, tables,
codes,. Installation etc
MIST System Management
 Database Sizes
 Tables which may grow large





Edcards
Batches
Batchtiming
Scanbatch
Scanfiles
MIST System Management
 Database Sizes
 ‘Old’ records can be removed from tables
 Data Entry Databases
 Records only needed until data export/import
occurs.
 Reporting Databases
 Assuming that a set number of years of
information is being kept, any records which
fall outside that period may be deleted.
 In all cases, database backups should be
done before erasing records.
MIST System Management
 Periodically shrink database to keep
database size manageable.
 Tables which are not in use, may be
deleted from the database.
 Placing indexes on various fields in
edcards may improve performance.
MIST System maintenance
 Database backups
 Direct backup of database files
 Problems with locking of files
 Stop SQL Server
 Place database offline
 Backup from within SQL Server
 Can be done when needed
 Scheduled backup
 Can backup directly to a backup device or
drive.