On 8th June we upgrading some tables to the new SQL typed columns, but looking at a 4 week picture we now seem to be running at a much higher usage the previously to this.
We do use a few Direct database queries and have updated them where needed, and they are working, so not sure if these are causing any issues, but in some instance we are still using the view in the query, i.e "x4_10", not sure if that is a problem.
We had some issues yesterday where a table got stuck migrating, and have since run full vacuums on a number of tables which has significantly reduced the database storage we were utilising, and we are no running consistently under 50% database CPU, but this still seems much higher than previously, before we started migrating any tables.
Is anyone else seeing similar issues?
Or am i reading this wrong and is this current usage going to look lower when viewing over a longer period of time than 24 hours? (which means the database clean up/full vacuums have actually fixed everything.
