Site and portal administrators now have the ability to see precisely what is running on their database server. Doyle ITS DatabaseActivity displays all processes running on the database server, both within the DNN portal database and all other databases! For SQL Server administrators, this is almost identical to the built-in stored procedure sp_who2. Configure the .ascx file to display more fields:
- 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