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!

      L
      landscape1
      May 27, 2019

      I've been struggling with this issue for MONTHS (maybe years) now with my Enterprise edition of Quickbooks.  (Why on earth I ever bought into the BS that Enterprise would make Quickbooks faster ...  what a sucker I was.  Biggest rip off EVER and there's no going back so I just pay the thousand dollar tax every year for nothing.)

       

      Last time I called the 800 number for Enterprise support, I was told to F*** O** and call Microsoft.  Call Microsoft?!??!??  Really?!?!???!?

       

      By the time I notice the second SQL running, it's because the processor is already chasing it's own tail and my battery is already drained.  Working off batter on my PC with Quickbooks is an absurd insinuation.  Intuit:  What else can you guys do to amaze me?!?!?!?  What's next??@?!???!

        Rose-A
        Rose-A
        Level 10
        May 27, 2019

        Hi, landscape1.

        Allow me to help and provide you some insights about the SQL Anywhere Network Server issue in QuickBooks Desktop.

         

        Accessing a SQL Anywhere server using a database file that is located other than on the machine where the server is running is possible, but not in all situations. The following lists some of the architectures you may be considering for use with your SQL Anywhere database.

         

        There are two main requirements for vendors of SAN/NAS hardware/software which determine whether or not SQL Anywhere will function properly:

         

        1. The order of file writes is guaranteed. This means that if the server says write A, then write B, the SAN/NAS guarantees that A is written to the physical medium before B. Additionally, on Windows, Microsoft guarantees that a call to SetEndOfFile(...) followed by FlushFileBuffers(...) is sufficient to force the file metadata to the physical medium. We require those same semantics to be respected by a SAN/NAS. 
        2. When a writen request is issued in this environment, the write has actually been completed to the physical medium (not buffered by the operating system or the drive's internal cache) when the SAN/NAS returns from the right call. This is generally true if point 1) above is enforced.

        I can pass along all the issue you have to the appropriate channels so you're able to reach a point of resolution as quickly as possible.

         

        I know you've already called in. However, I still suggest getting in touch with our QuickBooks Desktop Support to have this re-investigated. Our phone support has the appropriate looks, like screen sharing, and they can take a better look at this.

         

        1. Within your QuickBooks Desktop, click Help at the top menu bar.
        2. Click Contact us.
        3. To route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
        4. We’ll provide you a few options. You choose which one is best for you

        You may find this article helpful: QuickBooks Desktop Enterprise System Requirements.

         

        Feel free to hit Reply below if you have additional questions about the SQL Anywhere Network issue in QuickBooks Desktop. I'll be around 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