There are several potential causes of performance issues:
β
The following are generally best looked into by your own IT team:
Resource contention on the server(s) or client PCs - Typically, servers must have a reasonable amount of resource headroom for RAM and CPU, typically 20% or greater.
Network connectivity - Supply Chain requires a reliable, high speed network connection between client PCs and servers, wifi must be strong.
If you have just moved onto this server the SQL Maximum server memory may be left at the default which effectively means that SQL will be hogging all of the memory on the server. Get whoever supports your SQL server to check this and set to a more reasonable amount based on the installed memory.
Abnormal number of waits or locks in SQL - These are viewable in SQL Server Management Studio's Activity Monitor, and would typically indicate an underlying resource issue.
In SQL there may be some large queries being run and this is investigated in the Activity Monitor in Active or recent Expensive Queries
Is the ASC Database healthy you may have excessive fragmentation on the database tables if a maintenance plan has not been setup as fragmentation increase over time and your SQL support provider will have to deal with that.
It may just be a case of stopping and restarting the ASC Servers or getting your users off and rebooting them all.
