We help IT Professionals succeed at work.
Get Started

Microsoft Access database get dramatically slower as day progresses

383 Views
Last Modified: 2019-05-05
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.
Comment
Watch Question
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2020
Commented:
This problem has been solved!
Unlock 1 Answer and 57 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE