PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/03/2016 5:02 PM by  Greg Moeller
slow system performance
 28 Replies
Sort:
You are not authorized to post a reply.
Author Messages
DougAB
Manager of Financial Systems
Wayfair
Advanced Member
(56 points)
Advanced Member
Posts:28


Send Message:

--
08/17/2012 7:53 AM
    Hi all,

    Looking for some suggestions on how to rectify our system slowness.  We recently moved our Lawson servers from one side of our data center to the other side.  The outcome of this was that our Lawson servers were given new IP address.  The Lawson system is working after the move, but we noticed our update jobs take a significantly longer time to complete (14000 records would take about 14 secs; now it takes about 50 minutes). 

    We run the following tests:

    ·         Networking Between machines (Packet tracing and TCP dumps are all good)

    ·         DB confirms that querying tables is extremely fast on the database server (1000 milliseconds to write queries)

    ·         Perfmon on all servers not getting pegged (RAM/Hard Disk Performance/CPU) -

    ·         Web site is running fast (HTML files)

    The other difference now is that the Lawson apps server is on a different subnet than our db, before they were on the same.

    Any suggestions on what to look for or check?  I appreciate any feedback.

    Thanks,
    D

    Phil Romov
    Consultant
    redthree.com
    Veteran Member
    (114 points)
    Veteran Member
    Posts:44


    Send Message:

    --
    08/17/2012 8:23 AM
    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
    DougAB
    Manager of Financial Systems
    Wayfair
    Advanced Member
    (56 points)
    Advanced Member
    Posts:28


    Send Message:

    --
    08/17/2012 9:36 AM
    Thanks, Phil, for the suggestions. We'll start with those ideas first. We're on a SQL db, also.
    Phil Romov
    Consultant
    redthree.com
    Veteran Member
    (114 points)
    Veteran Member
    Posts:44


    Send Message:

    --
    08/20/2012 10:00 AM
    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
    DougAB
    Manager of Financial Systems
    Wayfair
    Advanced Member
    (56 points)
    Advanced Member
    Posts:28


    Send Message:

    --
    08/20/2012 10:56 AM
    Thanks, Phil. I'll have our DBA check these settings.
    Paul Fisher
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    08/26/2013 9:41 AM
    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
    Omran
    Dba
    Alas a
    Basic Member
    (12 points)
    Basic Member
    Posts:4


    Send Message:

    --
    12/08/2013 10:45 AM
    Your DBA should check the SQL server configuration , Max Degree of Parallelism . Also check your CXPACKET wait .

    Thanks,
    Omran
    trueblueg8tor
    Private
    Private
    Advanced Member
    (93 points)
    Advanced Member
    Posts:41


    Send Message:

    --
    12/18/2013 8:49 AM
    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?
    This_Guy
    Private
    Private
    Veteran Member
    (225 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    01/21/2014 4:30 PM
    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.
    Randy
    Systems Administrator
    Rochester Regional Health
    Advanced Member
    (85 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    01/22/2014 6:58 AM
    I'm interested.
    troelofs
    Project Team Leader
    Van Andel Institute
    Advanced Member
    (51 points)
    Advanced Member
    Posts:19


    Send Message:

    --
    01/22/2014 8:33 AM
    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 ***

    This_Guy
    Private
    Private
    Veteran Member
    (225 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    01/29/2014 4:23 PM
    Message me your email addresses, and I will send the documentation.
    Chris12
    Private
    Private
    Veteran Member
    (366 points)
    Veteran Member
    Posts:150


    Send Message:

    --
    01/30/2014 8:51 AM
    Having the same issue, can you share the docmentation?
    Chris12
    Private
    Private
    Veteran Member
    (366 points)
    Veteran Member
    Posts:150


    Send Message:

    --
    01/30/2014 8:51 AM
    Having the same issue, can you share the docmentation?
    J.W.
    Private
    Private
    Basic Member
    (15 points)
    Basic Member
    Posts:7


    Send Message:

    --
    07/24/2014 8:24 AM
    Could someone share the document with me?  We are seeing the same issue.

    Thanks
    Greg_Larson_Iowa
    System Admin
    UnityPoint Health
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    08/07/2014 3:16 PM
    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.
    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    08/14/2014 4:42 PM
    Are you on Windows and if so, do you have Broadcom NICs?
    Thanks for using the LawsonGuru.com forums!
    John
    Scott
    HRIS Manager
    Kaweah Delta
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    07/24/2015 10:42 AM
    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.
    Scott
    HRIS Manager
    Kaweah Delta
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    07/24/2015 10:42 AM
    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.
    Ann
    Systems Analyst
    Baylor
    New Member
    (4 points)
    New Member
    Posts:2


    Send Message:

    --
    06/27/2016 3:02 PM
    If anyone has the documentation, I would like to get a copy.
    JcThiel
    Project leader
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    08/30/2016 12:28 PM
    Could you send me your available documentation on the subject ?
    Facing performance issue on Sql Server, with MITBAL at 30.000.000 i.e.
    artwork
    IT
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    09/19/2016 4:25 AM

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

     

    Thx very much

    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    09/19/2016 8:08 AM
    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?
    Kwane McNeal
    Private
    Private
    Veteran Member
    (1197 points)
    Veteran Member
    Posts:399


    Send Message:

    --
    09/19/2016 8:28 AM
    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.
    Neil Allen
    Supply Chain IS Analyst
    Private
    Veteran Member
    (165 points)
    Veteran Member
    Posts:81


    Send Message:

    --
    09/19/2016 9:23 AM
    Greg - I'm interested in the Health-Check Infor did.  What's that entail exactly and was there a fee?
    This_Guy
    Private
    Private
    Veteran Member
    (225 points)
    Veteran Member
    Posts:93


    Send Message:

    --
    09/21/2016 9:25 AM

    By the way - there is some pretty good documentation on System tuning available. Look for LSF Performance Best Practices, and IPA Best Practices (for you IPA folks) 

    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    11/03/2016 4:59 PM
    Not sure if I can share "legally"...
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    11/03/2016 5:01 PM
    @Nelil -- Well, Infor did a 2 or 3 day health-check. Yes, there was a fee, but I don't know what it was/is. Just came back with a 32 page document of recommendations. Mostly setting changes to *.properties files scattered all over the place, and WAS JVM setting adjustments.

    We have just looked at the document today, and are deciding which settings to change first....

    I'd be happy to share the document with you, but I'm not sure if I "legally" can...? You may not have the same set up that we do... there are some overall
    general best-practice adjustments in there as well.

    -Greg
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    11/03/2016 5:02 PM
    Oh, and made some recommendations of vRAM increases to 3 of our servers.
    You are not authorized to post a reply.