Post

1 follower Follow
0

Cssoptimize MUST be run after restoring databases - otherwise you may have performance problems

After restoring a database, you MUST run cssoptimize on it to restore the statistics on that database.

The statistics are not saved during the restoration so must be recreated with cssoptimize.

If this is not done, it can lead to performance issues.

See the following documentation on how to run cssoptimize:

https://doc.castsoftware.com/display/DOCCOM/CAST+Storage+Service+-+Maintenance+activities

The default option (analyze) is good for this step.  The vacuum options are not needed in a restoration case as the defragmentation is taken care of during the restoration.

Please sign in to leave a comment.