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
  • 15 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
      tftaylorcpa
      June 13, 2021

      Hi Vivien,

      Are you still working on the Quickbooks Team?

      I'm having issues opening company files in Quickbooks Pro 2018 & 2020 versions, on my computer.  The company QBW files are located on a separate server.

       

      Everything was working fine until about 2-3 weeks ago.  Now it takes forever to open a company file, and once open, all operations are too slow to keep the company file open.

      Other computers in my office access the same company QBW files from the same server and do not have any issues.

       

      While my computer is trying to open a QBW file, I see intermittent lines in the Task Manager under Quickbooks that show "SQL Anywhere Network Server (32 bit)" and also "SQL Anywhere Personal Server (32 bit)" with leading Lightening Bolts in from of the words.  I suspect that is identifying the hang up, but I haven't been able to resolve the problem yet.  I've spoken to Intuit Support and they went through several operations, but to no avail yet.  They - Uninstalled and reinstalled Quickbooks Pro 2020; Ran the Quickbook Doctor and Quickbooks Tools apps.

       

      I need someone at Intuit & Quickbooks who knows how to fix this problem.  My business is suffering!!

      Thanks

       

       

       

       

      Jen_D
      Jen_D
      Level 8
      June 13, 2021

      Thanks for updating this thread, @tftaylorcpa,

       

      I want to make sure this QuickBooks issue is resolved, so we need to forward you to the right department to help you with this. I know you already contacted our support for this, but we're unable to assist technical and account management issues here in the community.

       

      Our Technical Support Team can better help you, and you can request them to get this escalated to our Data Services Department. They have the tools necessary to check your company file problems and provide relevant troubleshooting to rule out the problem. 

       

      To get our support, follow the steps below:

       

      1. Open QuickBooks and click the Help menu.
      2. Select QuickBooks Desktop Help.
      3. On the pop-up screen select Contact us.
      4. Click the Search for Something else button then type your concern in the Ask us anything box.
      5. Hit Search then scroll down to get your contact options.

       

      Refer to this article to learn more about our contact options and support availability: Contact QuickBooks Desktop support

       

      Kindly update me on the results in the comment. I want to ensure everything is working well for you, and I'm here to provide further assistance and insights. Have a great day!

      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