Is it Add-Ins?

Sort:
You are not authorized to post a reply.
Author
Messages
Shari
Veteran Member
Posts: 78
Veteran Member
    We recently moved our Lawson environment/application/database to Windows 2008 R2 64-bit servers (LSF 9.0.1.9 / Apps 9.0.1.7 / SQL Server 2008 / Lawson Security).  Performance has improved tremendously - however, there are times when our CPU spikes to 100% and I'm noticing it's caused by the db client msfdb2000.exe's - either one or many takes up the majority of the CPU.  User name is usually "lawson".  We suspect it's Add-Ins.  Is there any way to know, definitively, if this is caused by poorly-written add-ins queries?  Or any other way to determine what, exactly, is causing these spikes in CPU?  Obviously we have performance issues when the CPU stays at 100% usage for long periods of time.

    (We are also looking in to end-to-end peformance monitoring - using ITK's tool). 

    Any feedback would be welcome!  Thanks!

    -Shari
    Roger French
    Veteran Member
    Posts: 545
    Veteran Member
      Have you tried simple means of finding out, such as taskmgr on the server?
      Is it the 'lawson' user who is running these add-ins? How many users or which users have access to poorly written add-ins? Can you check ios.log and ladb.log and the timing of these spikes? It also could be caused by Lawson jobs. Also check the windows event logs.
      You are not authorized to post a reply.