Sage Payroll too slow to use

Help!

I have a client that uses Sage Manufacturing, Line 50 Accounts and Payroll.

Several users access SMan and L50 from data shared on the Windows 2008 Server. Payroll is accessed by one user, data also on server in pretty much the same location.

SMan and L50 work fine for all users but Payroll is so slow it's almost unuseable.

We recently introduced a Meraki managed switch to increase security but can't see how this would affect just Payroll.

So far we've tried:
1/ Running Payroll on server - data local - result some improvement but not great
2/ Moving data from server to local on slow client no improvement
3/ Installing Payroll on another client and accessing data on server just as slow
4/ Repairing payroll data using Sage utilities - no change

I'm in the process of installing Payroll on a device outside of the business environment (i.e. my own laptop) and will test there.

Any suggestions welcome please.

Gordon
Gordon710Asked:
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.

Andy MInternal Systems ManagerCommented:
We had a client with similar issues - payroll been extremely slow no matter where the data was moved to. It got rectified eventually but we never did find out exactly what was the cause. The steps done at our side for it (in no particular order) though was:

1. Remove any disconnected/old printers from the computers.
2. Put all the anti-virus exclusions in on both the server and machines for Payroll (folder locations, program files, file types, etc)
3. Disabled IPv6 on the computer
4. Removed a lot of unnecessary programs from startup (other security programs, virtual drive softare, etc)

I think one of our other engineers noted that the company file they were accessing was very large, after condensing this the speed improved too.
0
Gordon710Author Commented:
Thanks, will try that.

The main PC in question is a new build, top spec i5 and so should eat Sage in any disguise. I'll get back with success (or not)
0
Gordon710Author Commented:
Install to my laptop and data restore and Payroll works just fine. Partly expected but wanted to be certain!

Next job the above as suggested by Andy Morton. I must say that I've come across "disabling IP6" before making an improvement so I'll try that first.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Gordon710Author Commented:
No improvement at all I'm sorry to say.

I did come across this too

http://www.experts-exchange.com/Database/Software/Q_27652415.html

It's not over yet ............
0
Gordon710Author Commented:
At last a solution.

We  recently installed a managed switch and set the DNS servers to the Open DNS option, i.e. 208.67.220.220 and 208.67.200.200

Previously the server was acting as DNS and of course when opening Payroll on the Server it found the data easily. Sage requires the paths to data to be full UNC and doesn't work with a mapped drive. hence when the client tried to connect they went to the Open DNS and took simply ages to find their way back (I'm surprised they did to be frank).

By setting the DNS settings in the switch to first the server, then Open DNS it worked like it was supposed too.

Hope this saves someone else the ball ache I've had the past few weeks.

Can I award myself the point????
1

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
Gordon710Author Commented:
I found the solution myself
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.