• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Is it Add-Ins?

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Shari
Veteran Member Send Private Message
Posts: 78
Veteran Member
12/19/2012 7:18 PM
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 Send Private Message
Posts: 549
Veteran Member
12/19/2012 9:14 PM
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.