During performance tuning, it is imperative that we have data regarding the pain points (slow performing queries, high CPU utilizing queries, etc.). What tools are useful in getting these info?
Dynamic Management Views (DMV)
DBCC commands
Query plans
BCP