cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

SQL Anywhere Network Server - maxes out disk drive

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

Solved
Best answer 12-18-2018

Accepted Solutions
QuickBooks Team

Re: SQL Anywhere Network Server - maxes out disk drive

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!

6 Comments
QuickBooks Team

Re: SQL Anywhere Network Server - maxes out disk drive

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!

Not applicable

Re: SQL Anywhere Network Server - maxes out disk drive

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.

QuickBooks Team

Re: SQL Anywhere Network Server - maxes out disk drive

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.

10.PNG

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

Not applicable

Re: SQL Anywhere Network Server - maxes out disk drive

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??@?!???!

Moderator

Re: SQL Anywhere Network Server - maxes out disk drive

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.

Not applicable

Re: SQL Anywhere Network Server - maxes out disk drive

you can still switch back to Desktop Pro from Enterprise, check out "http://q2q-us.com/q2qwiki/Converting_QuickBooks_Versions" I used them for a few of my customers and they did a good job.

Need to get in touch?

Contact us