SCSM 2019 Performance Issues
I'm working on migrating from SCSM 2016 to 2019, I have our 2019 instances running side by side currently with our 2016 and I have synced the data with LMA tool. However I'm having terrible performance in both the console and web app, I'm seeing
The database subscription query is longer than expected. Messages on the primary management server for what seems like most of the workflows as well as some
Transaction (Process ID 105) was deadlocked on lock resources with another process and has been chosen as the deadlock victim warnings. I don't have any custom workflows and there is no one using this system right now.
I've used the minutes behind query from troubleshooting workflow performance and everything is caught up, I've tried to verify indices are okay and as far as I can tell they are. I'm not much of a DBA so not sure what else I can do to figure out what's going on with SQL. I will see the SQL server CPU spike to 100% every so often, but usually it's around 10-15% usage.
Details about our configuration:
Primary mgmt server: Server 2019, 4 cpu cores, 32gb ram
Database server: Server 2019, SQL 2017, 8 cpu cores, 32gb ram
Secondary mgmt/portal serevr: Server 2019, 4 cpu cores, 24gb ram
All servers are VM's on Citrix xen server hypervisor. CPU's are Xeon Gold 6230, same virtual pool and same subnet for networking.
Any thoughts or ideas on how to troubleshoot would be greatly appreciated!