Sql HeartBeat

A very useful (and free!) product: Sql HeartBeat from SqlSolutions.

Very simple to use: select a sql server, connect to them and it shows info about:

• Waits
• Seek time
• Physical R/W
• Cache hits
• Process/Connection activity

A screenshot: