Question

Locked

Quickbooks performance

By JSerrago ·
I have QB enterprise edition 2012 installed and a terminal server. The QB file is also located on that server and the databse manager.

I have two users that live in QB. They say that when more then on of them is on that the performance is misserable. Now its not the hardware the server its running on is a Windows 2008 term server with 14gb of ram. Now I am thinking that having the QB program and the database server running on the same peice of hardware might be the issue. Anyone else have any expereince with this?

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

I had it happen some

by Slayer_ In reply to Quickbooks performance

When our quickbook file started to push 200 megs it got worse. I was never able to truly cure it. But like you, I only had 2 people actually using it, and one was only there for half a week at a time, so I moved the file to the local drive of the computer that needed it most and shared it to the other machine and that mostly fixed the problem. I had a nightly backup copying it back to the server, and then saving it to offsite storage.

Is your database server working your hard drive a lot, if so, maybe putting the QB file on a separate hard drive in the server would help, or even an SSD would work good.

Collapse -

Reponse To Answer

by JSerrago In reply to I had it happen some

Well this QB file is over 800gb, they have had it though about 5 upgrades. So it comes down to that it might just be to D*** big.

Collapse -

Reponse To Answer

by Slayer_ In reply to I had it happen some

Wow, that's a big one lol. That could definitely be the issue then.
Try putting it on its own drive, see if that helps. You can also buy two 512gb SSD's and span them together. Also, make sure your running at least gigabit network.

Collapse -

Reponse To Answer

by Rob Kuhn In reply to I had it happen some

The database file is 800GB? Or is the whole entire directory 800GB?

Collapse -

Reponse To Answer

by JSerrago In reply to I had it happen some

Just the QB file, is 800mb.

Collapse -

Reponse To Answer

by Slayer_ In reply to I had it happen some

Than a single SSD would work. It would help remove the hard drive in the server as a bottleneck

Collapse -

RE QuickBooks performance

by peary In reply to Quickbooks performance

Are the users running Windows 7 64 bit? if so try the following. This sped up some database files over a networks for several users.

Go to Search

Back to Networks Forum
9 total posts (Page 1 of 1)  

Hardware Forums