Is it Add-Ins?

 1 Replies
 0 Subscribed to this topic
 28 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
New Poster
New Poster
Congrats on posting!
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.