(Freeware) SQL Heartbeat

Monitor activity on your server for FREE!

• Monitor server wait categories
• Monitor IO activity
• Check your current Cache Hits ratio
• Analyze your I/O system performance
• Get details about active processes
• Display locks and deadlocks

http://www.sqlsolutions.com/products/Heartbeat/index.html