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?
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Answers (2)
0
Votes
I had it happen some
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.
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.
Updated - 27th Aug
Replies
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.
JSerrago@...
27th Aug
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.
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.
Slayer_
27th Aug
This site has some info
http://blog.quickbooksusers.com/quickbooks/my-quickbooks-file-is-huge-what-can-i-do/
http://blog.quickbooksusers.com/quickbooks/my-quickbooks-file-is-huge-what-can-i-do/
Slayer_
27th Aug
The database file is 800GB? Or is the whole entire directory 800GB?
Rob Kuhn
27th Aug
Just the QB file, is 800mb.
JSerrago@...
28th Aug
Than a single SSD would work. It would help remove the hard drive in the server as a bottleneck
Slayer_
29th Aug
0
Votes
RE 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 Type GPEdit.msc Press Enter Navigate to the following and make sure Enabled is checked -
Computer Configuration\Administrative Templates\Network\DNS Client
\Turn off Multicast Name Resolution Double click and change to Enabled
Go to Search Type GPEdit.msc Press Enter Navigate to the following and make sure Enabled is checked -
Computer Configuration\Administrative Templates\Network\DNS Client
\Turn off Multicast Name Resolution Double click and change to Enabled
27th Aug
