| System maintenance & setup > Upgrading an existing system > Post-upgrade tasks > Run processes and diagnostics

Run processes and diagnostics

After the upgrade, perform the following tasks:

Installing critical operating system updates [>>].

Run data mapping [>>].

Wait for the overnight processes to complete.

Perform the additional tasks:

Check for I/O errors (ensures pages were not corrupted since they were last written to the disk) by executing the following once:
ALTER <your database name> SET PAGE_VERIFY CHECKSUM;

Create missing statistics on columns used by indexes by executing either the first or second statement after each upgrade:
EXEC sp_createstats 'indexonly';(This will create statistics using the default sampling rate.)
OR
EXEC sp_createstats 'indexonly', 'fullscan'; (This will create statistics using full scan.)

www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com