Watch SQL running queries - Performance aspect
===

Best Practice[s] for keeping an eye on SQL Queries execution,
Watching the performance, keep logging , simple or detailed.

Don't know weather the "Profiler" could do similar job or not.
Didn't find the piece I'm looking for in it .

**As an example :**

What could be an option if you are going to Select-Insert a quite simple query on about millions of records

Is there an option for using a countDown performance timer to see how much time each thousands records is taking ?

Code-Based practices or Tool-Based practices 

What do you suggest ?

*Any piece of information regarding these is appreciated.*