Post Maintenance jobs execution at SQL 2019 Ent.Ed CU 7, VM get unresponsive at AWS with CPU usage of 40-45%, Machine config, 32 core 256 RAM, DB size 1 TB RRS feed

  • Question

  • Dear professionals,

    We are in process to migrate our current SQL 2016 Ent.ed sp2 to SQL 2019 Ent.ed CU 7, We have migrated the DB from latest backup on same config VM, 32 core 256 GB RAm at AWS EC2, Db size is 1 TB, When we are executing the maintenance jobs VM get non-responsive with 40-45% of CPu utilization. RDP shows An internal error has occurred.


    Thanks Subhash Chander

    Sunday, September 20, 2020 5:05 AM