Questions

Quickbooks performance

+
0 Votes
Locked

Quickbooks performance

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?
+
0 Votes
Slayer_

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.

+
0 Votes
JSerrago

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.

+
0 Votes
Slayer_

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.

+
0 Votes
Rob Kuhn

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

+
0 Votes
JSerrago

Just the QB file, is 800mb.

+
0 Votes
Slayer_

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

+
0 Votes
peary

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