Our database runs quickly first thing in the morning. As the day progresses it slows dramatically.
We run it on Citrix. Only have 15-25 users accessing it per day and those users are evenly divided between 2 Citrix servers. Each user has their own frontend
I completely realize as the users log on more and more processes, bandwidth etc., are taking up resources. However, the servers never go above 20-30% CPU or Memory usage.
Servers are one Win 2016 physical machine and one 2016 Virtual
Miriam Bizup has been helping to see if there is any way to speed it up, but I am looking for some other thoughts on what might be the cause.
Let me know if you need any additional info.