Google for "SQL Monitoring tools" and you get plenty of hits for products that can watch the actual DBs, including transactions, locks, etc. That may or may not be what you are looking for.

Intermapper offers solid visual network monitoring with real-time mapping and alerts, but shows its age against modern ...