Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
SW at Open Sesame
December 18, 2018
Solved

SQL Anywhere Network Server - maxes out disk drive

  • December 18, 2018
  • 4 replies
  • 7 views

We have QB Premier Plus Manufacturing and Wholesale Edition 2018, running on Windows 8.1.

In the last month or two I have noticed that the QB server computer sometimes gets extremely slow, so much so it is unusable by the other computers accessing the server. When I take a look on the server to see what task is creating a heavy load on the disk drive, I see it is something called the "SQL Anywhere Network Server", which is associated with QB it seems. This is a new task I have never seen before, only in the last couple of months (or so). When I have a problem like this and look, this item has my disk drive running at 100% capacity. And it lasts for several minutes, maybe a half hour. This is really unacceptable for a business where we constantly need to access QB.

 

Does anyone know anything about this and what can be done?

 

Thanks,

Steven Williams

    Best answer by VivienJ

    Hello Steven,

     

    I'm here to share a few details about the SQL Anywhere Network Server message and ensure you'll get back up and running again.

     

    The SQL Anywhere Network Server prompt is associated with the QBDBMgr.exe. This is the main executable file for the QuickBooks Database Manager which you can configure for multi-user access.

     

    Since most applications store data on your hard disk and in your system's registry, it's possible the QBDBMgr has fragmentation and accumulated invalid entries which affects your PC's performance.

     

    To fix this, please give us a quick call. Our specialists would need to securely access your account and perform troubleshooting steps specifically to the network server. Also, they have the necessary tools, such as a screen sharing session for better visibility of what's causing this to happen in your account.

     

    You'll want to copy the link of our thread in the address bar above and give it to the specialist. This way, you won't need to re-explain the situation.

     

    To reach us:

    1. Go to this link: https://help.quickbooks.intuit.com/en_US/contact.
    2. If you're prompted to choose a product, choose QuickBooks Desktop.
    3. Pick your QuickBooks Desktop version.
    4. Choose Solving Issues & Error Messages, then File & Network Management.
    5. Scroll down to the Here's how to connect with a QuickBooks expert page.
    6. Click the Get Phone number button.

    Please update me as to how things go. Rest assured, we're all here to make sure you can use QuickBooks again to its full potential.

     

    I'll be around!

    4 replies

    V
    VivienJAnswer
    December 19, 2018

    Hello Steven,

     

    I'm here to share a few details about the SQL Anywhere Network Server message and ensure you'll get back up and running again.

     

    The SQL Anywhere Network Server prompt is associated with the QBDBMgr.exe. This is the main executable file for the QuickBooks Database Manager which you can configure for multi-user access.

     

    Since most applications store data on your hard disk and in your system's registry, it's possible the QBDBMgr has fragmentation and accumulated invalid entries which affects your PC's performance.

     

    To fix this, please give us a quick call. Our specialists would need to securely access your account and perform troubleshooting steps specifically to the network server. Also, they have the necessary tools, such as a screen sharing session for better visibility of what's causing this to happen in your account.

     

    You'll want to copy the link of our thread in the address bar above and give it to the specialist. This way, you won't need to re-explain the situation.

     

    To reach us:

    1. Go to this link: https://help.quickbooks.intuit.com/en_US/contact.
    2. If you're prompted to choose a product, choose QuickBooks Desktop.
    3. Pick your QuickBooks Desktop version.
    4. Choose Solving Issues & Error Messages, then File & Network Management.
    5. Scroll down to the Here's how to connect with a QuickBooks expert page.
    6. Click the Get Phone number button.

    Please update me as to how things go. Rest assured, we're all here to make sure you can use QuickBooks again to its full potential.

     

    I'll be around!

      C
      cdolsonnd
      February 13, 2019

      I am having a very similar problem to this one. 

       

      Some time last year after an upgrade we began to have long hangs in our Quickbooks Enterprise Desktop. We are now running the latest version of 19 and it still happens quite regularly. 

       

      We see the QuickBooksDB29 process (nested under the SQL Anywhere Network Server) max out a single processor core whenever this happens. While this occurs, QuickBooks becomes unresponsive for the entire staff. 

       

      We are running a multi-core 2.6 GHz Intel Processor with 16GB of RAM with the file hosted on a new SSD. 

       

      Is there someone we could reach out to regarding this? We've done everything we can to solve the issue, including moving to another server, reinstalling quickbooks, etc., but the problem seems to follow the company file wherever it goes.

        C
        Charies_M
        Level 9
        February 13, 2019

        Hello there, cdolsonnd.

         

        I appreciate you for joining this thread and sharing your experience with QuickBooks having long hangs.

         

        If you have already done all the troubleshooting steps provided by my colleague @VivienJ and still having the same issue, I recommend you get in touch with our QuickBooks Desktop Support​. They have the tools to properly investigate this issue so they can come up with a permanent fix.

        Stay in touch with me and let me know how it works on your end. I'm always here to help.

        C
        constantissues
        March 7, 2022

        I took a photo of the Resources "SQL ANYWHERE PERSONAL SERVER (32 BIT)  was using on my workstation. but was a few seconds too late to catch the time the CPU usage was at 80% and Memory usage was in the 800 MB range!!!  By the time I took the photo, it dropped to what you see. Then within 5 seconds of this photo the process disappeared from the task manager....  entirely... as if it never existed.

         

        Quickbooks knows something about this but is apparently unwilling to deal with the issue. This photo was on my Dell AIO with I-5 processor, 1 TB drive and 64 GB memory, latest version of Win 10 And QB, the main file for QB is on a Dell Server, with Xeon Processor, 64 GB memory and raid 10 drive setup purchased in May 2021 and still practically shuts down my computer when this process runs and we can hear the fans in the server go to full speed. Intuit has an issue but seems unwilling to deal with it. I can't imagine they are too stupid to figure this out, so the reasons for the issue must be due to them not wanting to fix the issue. 

         

        Before I took the photo the CPU was maxed out at 80% and memory used was in the 800 MB range. By the time I could get my phone off my hip, sort the task manager by memory used and take the photo of the screen, the CPU usage dropped to 2.4% from 80% CPU usage.  Then, the process disappeared from the task manager lists. Before that point, my computer mouse was doing the "Circles" thing which hangs up the computer from doing one darn other thing. This is an obvious issue Quickbooks knows exists yet doesn't seem to want to deal with the issue and has been effecting our computer usage since day one of using Quickbooks enterprise edition.  Quickbooks needs to fix the issue before the class action lawsuits begin.  

          T
          Terryr1
          April 29, 2022

          I have QB Premeire 2017 Desktop and have a problem with SQL Anywhere Network Server and other QB programs running that causes my desktop to freeze up.  I've contacted support by Chat and was dropped after 3 hours of waiting.  I contacted Support again, this time asking for a call back.  The support person had no clue as to what I was trying to explain and only offered to email me an article to fix the problem myself.  It's been an hour and I still don't have an email.

          What am I supposed to do now?

          K
          Kevin_CModerator
          Moderator
          April 30, 2022

          Thanks for joining this thread, @Terryr1. I'll share some troubleshooting steps to help you isolate the issue with your QuickBooks Desktop (QBDT).

           

          We can run the QuickBooks Install Diagnostic Tool (QBInstall Tool). This will help us identify any component issues related to your QuickBooks Desktop. Here's how:

           

          1. Download the QuickBooks Install Diagnostic Tool.
          2. When prompted, save the file to the local Desktop.
          3. Close any open programs and run the QBInstall Tool. Note: It may take up to 20 minutes to complete, depending on your internet speed and the computer's performance.
          4. Restart the computer after running the tool to make sure the components are properly updated.

           

          If the issue persists, you can follow other troubleshooting steps in this article: QuickBooks Desktop won't open, has stopped working, or not responding.

           

          I'd also suggest reaching out to our QBDT Support Team. I understand you've already reached out to them. However, it would be best to contact them again. They have the tools to look into your account and check what caused this issue and can verify when you'll receive the email. 

           

          Please let me know how it goes by leaving a comment down below or clicking the Reply button. I'll be around if you need further assistance.

          Need QuickBooks guidance?
          Log in to access expert advice and community support instantly.
          Terms & ConditionsAccessibility statement