GREAT PLANS DATABASE SPEED OPTIMIZATION

Great plain database same server, different instance, same size of database, the speed is slow,

How to optimize it O/S :  

Great plain version : 8.

 Database : SQL SERVER 2000

 O/S windows 2003
backer-mAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

When you say the "speed is slow", you'll need to provide more specific information.  Are reports slow?  Data entry?  Lookup?  Posting?  SmartLists?  Login?

There are several possible issues, but I suspect the issue lies with SQL Server and your physical server, and not with the GP application.

How much physical RAM do you have in the server?  How much free memory is there when both instances are running?  If you have insufficient RAM, SQL Server will have to swap to disk more, which will slow things down.

If you shut down your first instance, does the performance gradually improve on your second instance?

If you run the same report in both instances (i.e. detail trial balance or AR aging), how long does each take?  Run this test with the same report multiple times and see if performance gradually improves.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional



0
backer-mAuthor Commented:
Thanks for the reply.  

Slow seed in lookup and posting.

I wil ltry shut down first instance.

Currently we are using test data base only. We have not yet gone line.

We have another new server hardware "Hp proliant ML350" with good configuration.

1. I have installed GP8, SQL server.  I am planning to keep data only this server and terminal service and GP in the old server. What is your suggestion.

2.For the client mahcine for the performance which is better . Insalling GP in the client mahcing
or terminal service.



3.For remote locations which is better? (Insalling GP in the client mahcing
or terminal service.)



0
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

For the performance issue, my first guess is still memory, so I would check available memory on the server with both instances, and try running just one instance to see if that helps.  

You could try reindexing, but that shouldn't be an issue if you don't have much data.

If you are planning on running Terminal Server, definitely do that on a separate machine from your SQL Server.  I agree with your plan of having two separate servers.

I don't know if the performance of Terminal Server vs. client workstation install will be noticeably different.  Once the application is loaded, performance should be fine with both as long as you have a 100Mbit or faster network.  GP is pretty network intensive, so you want a fast, reliable network.

Terminal Servers are much more convenient if you have users spread out, or in different offices, as it saves you from having to touch each workstation for maintenance or upgrades.  But Terminal Services can be a hassle for users, as they have to login via RDP and deal with occasional printing issues.  Citrix is ideal, but expensive and additional administration.

As an administrator, your life will be easier with Terminal Server.  But make sure the machine has plenty of RAM (if I recall correctly, 1-2 GB extra for the OS, plus somewhere around 250-500MB per active user) and CPU capacity (i.e. dual CPU machine).

For remote locations, definitely Terminal Server.  You do NOT want to try and run GP over a WAN link or VPN, it will be horribly slow.


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional



0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
backer-mAuthor Commented:
Thanks for the solution.


We will install SQL server separate machine.

But, what  is  your suggestion for  installing Great Plains, in  terminal server machine or in SQL server machine ?

0
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

If you have the hardware for a good Terminal Server, I think GP on Terminal Server makes more sense, since you avoid having to install (and support and upgrade) GP on multiple desktops.

However, I have clients that don't want Terminal Server and prefer to install on desktops, since that is where employees have their e-mail, other apps, Office, and desktop profiles, etc.  

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional



0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Tax / Financial Software

From novice to tech pro — start learning today.