November Happy Hour will be moved to Thursday December 5th.

Upgrade to CMS 12.15.0 / Framework 12.11.0 causes significant increase in database size

Vote:
 

With the update from CMS 12.13.1 / Framework 12.9.3 to CMS 12.15.0 / Framework 12.11.0 I've observed huge change in database size.
Is there any known reason why it is happening or any insights how to prevent this?

Before the upgrade:


After the upgrade:

#292801
Dec 07, 2022 15:38
Vote:
 

If I'm reading the screenshots correctly, I'd guess the update involved some restructuring of the database which involved some data being recreated in its new structure then deleted from its old structure. That would mean that the database would have had to grow to accommodate the temporary duplicate data but then hasn't been shrunk afterwards. Similarly, if lots of rows are being updated, lots of data will be getting written to the transaction log. The contents of the transaction log will have been cleared when it was next backed up leaving lots of space reserved for the transaction log but not a lot of it in use. I suspect the size of the data is probably similar to what it was but the amount of allocated space has grown. If you're struggling for disk space you could probably shrink both the DB and the transaction log however growing them is fairly resource intensive so, if you've got the space to spare, it might be worth keeping them at their current size to allow for growth.

#292805
Dec 07, 2022 18:14
Vote:
 

I am not aware of such change. Could you run the db shrink command to see? 

https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database

#292806
Dec 07, 2022 20:53
Vote:
 

I think the size of database / log is probably fine - we're using Azure SQL, so it will automatically shrink the log.
However, the deployment of the upgrade required significant bump up of SQL resource (we've scaled the pool to 40 cores) to even execute the migration in reasonable time (about 25 minutes).
To me it doesn't look normally, even the upgrade from Episerver 11 to Episerver 12 wasn't as resource heavy as the Episerver 12.15 update.

#292854
Dec 08, 2022 12:18
Vote:
 

Right. In 12.10 there was a migration of tblContentProperty and tblWorkContentProperty - essentially rebuilding those tables. If your tables have a lot of rows that can be slow. Nothing we can really do at this point, but it's good that you brought it up so other devs are aware of this 

#292855
Dec 08, 2022 12:33
Karol Berezicki - Dec 08, 2022 12:35
Thank you Quan, we can obviously work around it by temporarily scaling up, but it's good to know why :)
Cheers :)
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.