How do I determine what processes are blocked within SQL? (NETIQKB12877)

  • 7712877
  • 02-Feb-2007
  • 20-Oct-2010

Environment

NetIQ AppManager 6.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.

  1. Create a new job with the SQL_BlockedProcesses Knowledge Script
  2. Add an action to the job with the Action_RunSQL Knowledge Script
  3. Access the properties on the Action_RunSQL Knowledge Script
  4. Fill in the relevant information and use the following query for the 'SQL statement'

    sp_who2

  5. Save the query results to an output file
  6. Open the output file and look for the process(es) that have an entry in the 'blkby' column

Additional Information

Formerly known as NETIQKB12877