Monitoring user processes on AOS

[Freezie]

We currently have several users running server-side code that writes records
to SQL. Currently the AOS starts to slow down to a crawl and the users see
the client Ax screen as 'frozen' until the process finishes.

Is there a way or a toolset to monitor AOS code or processes currently still
executing on the AOS server by user so that we can see that they haven't
'hogged' the system with their process?

Thanks.

[Klaas Deforche]

Hi,

Go to administration -> online users.
There you can see all online user sessions. You will see a column that says
'SPIDs'.
Those SPIDs are process id's from sql server.
You can get more information in SQL Management Studio - Activity monitor
(google/bing it).
That's the tool I use to see if users have processes that are blocking other
users/processes. You can see the sql statements that they are executing by
double clicking in the grid, if they are blocking other processes (scroll to
the right), or being block. You can even kill those processes (use with
caution!).

What I do, is go to the Activity monitor, see what processes are blocking
others (and why), go to the online user screen, and end the user session that
has the SPID (if it's ok to be killed). Ending sessions in AX is safer than
killing spids on sql.

Hope this helps,
Klaas deforche
----------------
http://www.artofcreation.be

Post by Freezie
We currently have several users running server-side code that writes records
to SQL. Currently the AOS starts to slow down to a crawl and the users see
the client Ax screen as 'frozen' until the process finishes.
Is there a way or a toolset to monitor AOS code or processes currently still
executing on the AOS server by user so that we can see that they haven't
'hogged' the system with their process?
Thanks.