slow system performance

Have you checked various lawson logs such as LAWDIR/system/*.log as well as various database logs (what kind of database is it) for clues? (Fast queries are great, but update jobs update the data as well, I suppose)

That would be my first step.

Lawson also has some settings in its DATABASE file (e.g. LAWDIR/prodline/MICROSOFT for MS Sql, LAWDIR/prodline/IBM for DB2, etc) that can be tweaked, ARRAYBUFSIZE and INSERTBUFSIZE or something similar, just trying to remember off the top of my head

Thanks, Phil, for the suggestions. We'll start with those ideas first. We're on a SQL db, also.

For SQL Server, we've found speedup by setting the following options on the database level:
* recovery model - Simple
* auto create statistics - false
* auto update statistics - false

Thanks, Phil. I'll have our DBA check these settings.

Hi Doug,

We are also experiencing similiar slowness with no obvious errors or resource issues. Have you had any luck? We are also looking at the ARRAYBUFSIZE, INSERTBUFSIZE and the auto statistics.

Any information you could provide would be appreciated.

Thanks,
Paul Fisher

Your DBA should check the SQL server configuration , Max Degree of Parallelism . Also check your CXPACKET wait .

Thanks,
Omran

We're on DB2 so we have a file named IBM in $LAWDIR/prodline. What is your INSERTBUFSIZE set to in the SQL server equivalent of this file?

Not sure if this is still an issue - thread is pretty old, but we have similar performance issues when we went the 64bit (9019) We ended up escalating this with Microsoft Tier 3 support, and there were some DB NIC Card settings that needed to be modified. Assuming your DB server is seperate. I have alot of documentation on this if you like to see it? Im happy to share.

I'm interested.

We've seen some slowness and some connection errors in ladb.log like the one below. Infor support is saying it's a Microsoft SQL Server issue so I'd be interested in seeing the documentation as well.

*** begin msfdb2000 error message ***
Fri Jan 10 14:25:38 2014 - program 'lawsec', User 'OSID:NT00000001', RMId 'lawson'  Driver Version '9.0.1.12.204 2013-03-29 04:00:00'
AGGRANGEDBREC() error on file 'EXECUTABLE' in 'GEN'

AggRngSqlRec(dbo."EXECUTABLE", 0)
CMsfCSRSqlStatement::First(AGGF0055I00_V00) -
  SQL Server Error Code: 0, Source: Microsoft OLE DB Provider for SQL Server, Description: Connection failure

*** end msfdb2000 error message ***

Message me your email addresses, and I will send the documentation.

Having the same issue, can you share the docmentation?

Having the same issue, can you share the docmentation?

Could someone share the document with me?  We are seeing the same issue.

Thanks

It sounds like this is a fairly common problem. We have three separate systems and all of them have this same connection error. I would be interested in seeing this documentation as well, if that is possible. We have been puling our hair out trying to figure out what's happening and if the solution has worked we would love to get more information.

Are you on Windows and if so, do you have Broadcom NICs?

I know this thread is very old but we're moving to Infor10 and have the same issues with LPA performance.  If you could send me the documents you have it would be greatly appreciated.

I know this thread is very old but we're moving to Infor10 and have the same issues with LPA performance.  If you could send me the documents you have it would be greatly appreciated.

If anyone has the documentation, I would like to get a copy.

Could you send me your available documentation on the subject ?
Facing performance issue on Sql Server, with MITBAL at 30.000.000 i.e.

Please, could you send me your available documentation on the subject ?

 

Thx very much

We just had Infor do a Health-Check on our system(s). Although no official recommendations are yet available, this system was just installed/go-live in March. Shouldn't "most" of these tuning recommendations have been done already by the installer?

A cognizant installer, yes. An independent installer, as best they are trained.
Infor's installer, no.

Why?

Part of the value add the first two bring to the table is knowing your operational practices, system architecture, and internal processes.
Infor cannot reasonably know it's clients at that level, just as Microsoft cannot.
So for Infor, an installer, installs. Period. Sure they do their best to make reasonable choices, but they typically aren't able to know the nuances of a large part of the product matrix AND the nuances at your location.

...Enter ICS performance group, groups that provide testing and automation tools, and independents who specialize in knowing exactly how the infrastructure stack works.

TL;DR: No one can know everything, so typical the person that installed it, isn't the person that can tune it, isn't the person that can configure it for use by business users.

Greg - I'm interested in the Health-Check Infor did.  What's that entail exactly and was there a fee?