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
  • 21 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!

      T
      ThangTran
      July 13, 2022

      Every single time we try to contact QuickBooks supporters, we always reach out very low level support agent, such as Tier 1 or Tier 2 at max. With all my respect, all they try to do is running QuickBooks ToolHub, QuickBooks File Doctor, Database Server Manager. Once they all done and issue doesn't solve, they blame the server, the network, and they tell me that I "need  to consult Microsoft". It's QuickBooks designation, it's QuickBooks behavior. Do you guys really want to support and help your clients?

      Jen_D
      Jen_D
      Level 8
      July 13, 2022

      I appreciate you taking the time letting us know about this server issue you have, @ThangTran.

       

      Not getting the help you needed from our support can be really troublesome and time consuming. It is our main goal to help you with whatever issues you have while using our services. 

       

      If the troubleshooting shared on this page didn't work, we always recommend contacting our Technical Support. This is because, only our online reps can provide more troubleshooting steps and report the problem to our engineers when needed. I know you already called them several times. We want to inform you that you can always request for a supervisor on set of the call if you have complaints and get immediate help with this technical issue, without going through Tier 1 or Tier 2 support.

       

      When contacting our support, it is best to always ask for a case number. This is a unique ID created by our representative for documentation purposes. Using that case ID, any agent who will receive your call will be able to pull up your contact history, including the name of the last person you've talked to. Also, all our call and chat channels are recorded, so they can look up your interaction easily in case you want to report your contact experience.

       

      I'll be right here if you have other things to ask about this topic or need other help with the program. Also, please update this thread on how your call went. I want to make sure this is taken care of for you.

      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