Is it Add-Ins?

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
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: 549
    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.