1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Access and SQL occational hanging issues on our workstati

Discussion in 'Business Applications' started by johnny7777, Nov 30, 2019.

Thread Status:
Not open for further replies.
  1. johnny7777

    johnny7777 Thread Starter

    Joined:
    Nov 30, 2019
    Messages:
    1
    We are running a custom database in one of my customer sites. The backend is running SQL and the front end is based on Microsoft Access. Our users occasionally experience issues with Access hanging on them and then they lose their reports. Other times, they experience sluggishness and with all these issues, we have not been able to narrow down why these issues happen.

    Here is the technical stuff

    SQL Server -> Windows 2012R2, 16GB ram, SQL version 2012, up to date windows updates. No additional AV running on this server.

    Workstations -> new Lenovo M710s, Windows 10 Pro (v1903, OS build 18362.476), 8GB ram, SSD drives, Office 2016 Pro Plus, AVG business edition (19.7.3103)

    HP Aruba Gbit managed switches (2530-24G-POE+)

    We are using POE because our phone system runs through the same connection.

    Server backups run between 9am – 10am when there are the least number of users on the system using the database.

    Things we’ve tried but didn’t make any difference
    1. Dropped in 3 new lines to the PC’s to take out the POE phones out of the equation.
    2. Removed AVG from a couple of stations for a few days.
    I’m hoping that someone can give us some guidance on this issue.
     
  2. Chawbacon

    Chawbacon

    Joined:
    Jul 9, 2018
    Messages:
    531
    First Name:
    Jack
    Hello Johnny7777,

    I completely understand your frustration. Been there a few times. :)

    Some additional questions though.

    Does the latency affect only MS Access, or does it affect other applications, or the network as a whole?
    Does the latency affect all networked users at the same time (when the latency starts can other users access other applications, or the Internet without noticeable latency)?

    The root cause for these types of random latency issues can are hard to pin down and can be caused by a multitude of possible issues from system, to application, to network, to malware, etc... Typically I attack this scenario by setting up server side, network, and application monitors, enabling verbose logging, and using the date/time stamp of the next occurring, shall we say opportunity, that negatively affects the network to narrow down the log search for the anomaly.

    Some of the things that I have encountered in the past that have caused similar issues (without jumping to a malware thought process):

    • Incompatible patch levels (operating system, or application) between the workstations, or server (especially if only affecting a few users)
    • Individual(s) pulling a very large query
    • Incorrectly defined query (this is ultimately a coding issue)
    • Logs not configured to overwrite correctly
    • Memory leak on the server, or in the application (garbage collection)
    • Hardware beginning to fail on the server, or network appliance (Fans, CPU, RAM, HDD, Power Supply, etc.)
    • Another program on the network (new, or outdated) that is reaching out for an Internet server that is not available.
    • Oh... Since it is holiday season... Mass shopping, or video/audio streaming that is consuming excessive bandwidth.
    It can be a tough nut to crack; but, time and pressure will eventually obtain the fruit.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1236450

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice