Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager 7.0.x
Situation
How do I determine what processes are blocked within SQL?
Resolution
Once the SQL_BlockedProcesses knowledge script generates an event have the Action_RunSQL Knowledge Script create an output file of the 'sp_who2' SQL query. This query shows a snapshot of all the users and processes being used.
- Create a new job with the SQL_BlockedProcesses Knowledge Script
- Add an action to the job with the Action_RunSQL Knowledge Script
- Access the properties on the Action_RunSQL Knowledge Script
- Fill in the relevant information and use the following query for the 'SQL statement'
sp_who2 - Save the query results to an output file
- Open the output file and look for the process(es) that have an entry in the 'blkby' column
Additional Information
Formerly known as NETIQKB12877