slow system performance

 29 Replies
 3 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Page 1 of 212 > >>
Author
Messages
DougAB
Advanced Member
Posts: 28
Advanced Member
    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
    Veteran Member
    Posts: 44
    Veteran Member
      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
      Advanced Member
      Posts: 28
      Advanced Member
        Thanks, Phil, for the suggestions. We'll start with those ideas first. We're on a SQL db, also.
        Phil Romov
        Veteran Member
        Posts: 44
        Veteran Member
          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
          Advanced Member
          Posts: 28
          Advanced Member
            Thanks, Phil. I'll have our DBA check these settings.
            Paul Fisher
            New Member
            Posts: 1
            New Member
              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
              Basic Member
              Posts: 4
              Basic Member
                Your DBA should check the SQL server configuration , Max Degree of Parallelism . Also check your CXPACKET wait .

                Thanks,
                Omran
                trueblueg8tor
                Advanced Member
                Posts: 41
                Advanced Member
                  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
                  Veteran Member
                  Posts: 93
                  Veteran Member
                    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
                    Veteran Member
                    Posts: 50
                    Veteran Member
                      I'm interested.
                      troelofs
                      Advanced Member
                      Posts: 19
                      Advanced Member
                        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
                        Veteran Member
                        Posts: 93
                        Veteran Member
                          Message me your email addresses, and I will send the documentation.
                          Chris12
                          Veteran Member
                          Posts: 150
                          Veteran Member
                            Having the same issue, can you share the docmentation?
                            Chris12
                            Veteran Member
                            Posts: 150
                            Veteran Member
                              Having the same issue, can you share the docmentation?
                              J.W.
                              Basic Member
                              Posts: 7
                              Basic Member
                                Could someone share the document with me?  We are seeing the same issue.

                                Thanks
                                Greg_Larson_Iowa
                                New Member
                                Posts: 1
                                New Member
                                  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
                                  Posts: 3353
                                    Are you on Windows and if so, do you have Broadcom NICs?
                                    Thanks for using the LawsonGuru.com forums!
                                    John
                                    Scott
                                    New Member
                                    Posts: 2
                                    New Member
                                      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
                                      New Member
                                      Posts: 2
                                      New Member
                                        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
                                        New Member
                                        Posts: 3
                                        New Member
                                          If anyone has the documentation, I would like to get a copy.
                                          JcThiel
                                          New Member
                                          Posts: 1
                                          New Member
                                            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
                                            New Member
                                            Posts: 1
                                            New Member

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

                                               

                                              Thx very much

                                              Greg Moeller
                                              Veteran Member
                                              Posts: 1498
                                              Veteran Member
                                                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
                                                Veteran Member
                                                Posts: 479
                                                Veteran Member
                                                  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.
                                                  Me
                                                  Veteran Member
                                                  Posts: 96
                                                  Veteran Member
                                                    Greg - I'm interested in the Health-Check Infor did.  What's that entail exactly and was there a fee?
                                                    Page 1 of 212 > >>