troubleshooting Question

Microsoft Access database get dramatically slower as day progresses

Avatar of J.R. Sitman
J.R. SitmanFlag for United States of America asked on
CitrixDatabasesMicrosoft Access
57 Comments1 Solution388 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 57 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 57 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros