| 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]


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

Copyright 2015-2016 PowerSchool Group LLC and/or its affiliate(s). All rights reserved. All trademarks are either owned or licensed by PowerSchool Group LLC and/or its affiliates.