Hi All

I'm looking for functionality in MS SQL for statement monitoring to see
- Most run SQL statements
- Longest running SQL statements
- Ratio of rows read vs rows fetched
- etc.

I've worked with DB2 since 2001 and it has great SQL statement monitors, but in MS SQL I'm lost how to achieve this.
I'm looking for any ideas, perhaps even a blog post.

Kind regards
Marco