Site and portal administrators now have the ability to see precisely what is running on their database server. Doyle ITS DatabaseActivityPro displays all processes running on the database server, both within the DNN portal database and all other databases!:

• Configure settings to pick the displayed fields. Pick from:
  • Process ID
  • Status
  • Login name
  • Host name
  • Blocking process ID
  • Database name
  • Command
  • CPU
  • Disk IO
  • Memory usage
  • Open transactions
  • Last batch
  • Login time
  • Program name
• Configure sorting and whether to display a filter screen
• Dynamic filters (optional)
  • Status
  • Login name
  • Host name
  • Blocked / unblocked
  • Database name
  • Command
  • Program name
• For SQL Server administrators, this is almost identical to the built-in stored procedure sp_who2