Interprise Suite Community / Interprise Suite Community Forums / Questions and Comments About Features, Functions and Workarounds / System Manager / USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS / Latest Posts

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

ise_user — Tue, 06 Oct 2009 03:00:28 GMT

There are reported issues with memory leaks on your release, the reason for my questions - to see if this is effecting you......

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

Duke — Tue, 06 Oct 2009 02:50:13 GMT

We have just come to realise that entering data remotely, is not only faster but also almost crash free!
One of the Directors entered approx. 30 jobs remotely , reported that it not only was very responsive, but had no crashes at all!

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

ise_user — Mon, 28 Sep 2009 11:54:39 GMT

p.s. leave Task Manager/Performance monitor running on a workstation you know is problem. Keep an eye on the IS application/task - whats the CPU and memory getting up to before the crash or go slow.

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

ise_user — Mon, 28 Sep 2009 11:51:17 GMT

On a workstation reboot and check the performance - is the workstation fast to start with?

On the workstation use MSSQL Ent Manager to run a few of the IS Views - to confirm performance of the MSSQL DB (very unlikely this is the issue)

Are you able to roll back to an earlier release of IS - or at least install an earlier release on one of the workstations to test against the existing server.

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

Duke — Mon, 28 Sep 2009 05:09:54 GMT

Hi Antony,

the 'dealer' keeps assuring us that the 'soon to be available' software upgrade will alleviate these problems, but they have been saying that for 3-4 months now - all coding is being done in the Philippines it seems.
Not sure how much beta testing has been done, I'm guessing we are about to do that for them!
System load has NO affect on the performance at all. Even at 6pm, with only two users on-line, the system constantly crashes the terminals.
No, we do not run our web site on the system at all.
We have noticed that if a terminal crashes, then it is most likely that several others will too. Converting orders to invoices and/or printing invoices seems to be the most common action prior to crashes. Generally though the whole system is woefully SLOW at even the simplest tasks. Just composing a simple invoice initially takes 12-14 seconds!
Search of the data base for a product code can take longer.
We surely can't be alone in this mess.

HELP!!!

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

ise_user — Mon, 28 Sep 2009 03:41:57 GMT

Hi Duke
Sorry for delay been away from the office - I feel your pain on this:)

Nothing obviously wrong in your hardware setup. What have your IS support said - I'm sure lots of us here would love to know their responce?

What effect does load have on your timings? Say you do the same tests when no other users are on the system.
Are you running a website off the system or is it just the account apps?

I have a decent live dev server that you are welcome to test against - to try and narrow down where the issue is.
Cheers
Antony

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

Duke — Thu, 24 Sep 2009 02:09:48 GMT

Hi Antony,
I FINALLY have answers to the configuration questions you raised. They are:
We are running Interprise Suite 2007 SP5.3)

Hardware in the terminals, version of SQL server:
DL 180G5 (on terminal server) was 2GB ram (now 4GB)

Backend – ML150 G3 3GB ram
SQL Server 2005 Service Pack 3 2005.90.4035 workgroup edition.

The server, terminals connected together via 100MB LAN
ADSL2+ Internet remote (theoretically)

No cache databases on clients.

The database is no bigger then 2GB. The log is no bigger then 1GB

We have now replaced/exchanged all hardware and found no difference to the performance so can conclude it is to do with the software and / or its configuration.

It is not uncommon for every terminal in the company to crash 5-6 times per day, and very slow response times.
Appreciate any help we can get!
thanks David

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

mattfc — Sat, 19 Sep 2009 07:08:08 GMT

Hi

I have a few:

Change dbase recovery model to simple ( Be aware of backup implications ! http://msdn.microsoft.com/en-us/library/aa173563(SQL.80).aspx)

Shrink, Rebuild Index, Reorganise index, logs and databases using an SQL daily maintenance plan. Especially check your log file sizes as they can get really large (100gb!! + ) and are largely pointless if you have a proper backup schedule.

Make sure you are at least using SQL server standard ( http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx ) well worth the investment if you are using the database a lot.

Optimize SQL server memory settings, processor affinity and etc.

Use a cache database, really speeds things up.

Improve network speeds between server and clients.

Get a better server, use Server 2008 (x64 if possible) at least Intel x3320 or better at least, 4gb ram min and a descent raid array.
Could split Dbase and Web Server if running a real monster of a website.

Matt

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

NAYLARD — Fri, 18 Sep 2009 07:19:19 GMT

We have similar issues. By chance do you have any general configuration suggestions on how to improve the performance of IS.

Cheers

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

Duke — Fri, 18 Sep 2009 04:23:16 GMT

Thanks,
I am waiting for a response to those questions, as soon as I get them I will post again, meantime we waste hours each day with terminal crashes and very SLOW response times.

thanks

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

ise_user — Sat, 05 Sep 2009 09:54:40 GMT

Hi
Some of the issues you describe are associated with earlier releases of IS. Even the later or current release can give such results if not configured correctly.
If you let us know the version number you are running, and the specs etc as per Matt's post we should be able to give you some useful feedback.
Cheers
Antony

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

Duke — Tue, 01 Sep 2009 04:42:03 GMT

Thanks Matt,
I will get back to you

DB

RE: USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

mattfc — Mon, 31 Aug 2009 01:27:11 GMT

Hi

What version are you running? Also what hardware you got in the terminals, what version of SQL server you running on the server / clients and what hardware? How are your server, terminals connected together ( LAN / Internet and what speed). Are you using any cache databases on your clients? Also how big is the main database / log files roughly?

Thanks
Matt

USER TERMINALS CRASHING, SLOW RESPONSE SPEEDS

Duke — Fri, 28 Aug 2009 16:31:54 GMT

Recently I started work with a company using Interprise.
We have approx. 5-6000 stock items in database, separate server managing email/net etc. have just spent lots of money installing new server to fix speed problems.
I was amazed to see how slow the response at the terminal level was, 5 seconds to add a stock item to an order, 12 secs. to display an invoice to print, 15 secs to display an item number that has several possibilities etc. etc.
Worse, it routinely crashes terminals at the site, often 4-5 times per day (not every terminal).
Sometimes whilst entering a sales order, the client list fills the screen, and so on with many problems.
It is a nightmare. We are waiting for the "upgrade fix" that has been promised, which is apparently being written in the Philippines, and I believe we do not even have a dealer/distributor in our country now, only a 'reseller'.
Are we alone in this? do we need someone to properly configure our server and PCs? or is this all sounding very familiar?
HELP please.