MSSQL Server maintenance guidelines for optimal performance with Clarity

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Below are the SQL Server weekly and daily recommendations for database maintenance to ensure more optimal performance with the Clarity product line for our SQL Server customers

Environment

Release: All supported Clarity releases with SQL server 

Resolution

Guidelines for SQL Server maintenance (valid for all supported SQL Server releases)

• Request your DBA to review and schedule the attached updated SQL Maintenance script
• It will have recommendations for Daily/Weekly maintenance
• <updated on 4/15/2026 with adding heap tables as well>
• Please note the database name in the script is set to CLARITY - you must replace this if it's different on your environment

Additional Information

Also, it would be good to run DBCC SHRINKDATABASE and DBCC SHRINKFILE with 20% free space / 80% fill factor on a weekly basis.
Below are more details on them from MSDN.

http://msdn.microsoft.com/en-us/library/ms190488.aspx
http://msdn.microsoft.com/en-us/library/ms189493.aspx