| System maintenance & setup > Database maintenance > Updating database statistics

Updating database statistics

Accurate and up-to-date statistics are important to the efficient performance of SQL Server. We recommend that the database administrator update statistics for the PowerSchool SMS system’s database at least once a month. When updating statistics, it is also useful to recompile the stored procedures. The database administrator can use a script in Query Analyzer for these tasks.

To update statistics and recompile stored procedures: [DA]

Pearson
Always Learning
www.pearsonschoolsystems.com 
Tel: 866-434-6276
Email: psstechsupp@pearson.com