If you are just trying to see a summary of the query stats either periodically or on demand, you can use a query such as shown below. The sys.dm_exec_query_stats view has a number of other columns that also may be of interest to you.
SELECT q.total_elapsed_time / 1000.0 AS [Totalms],
q.total_elapsed_time / 1000.0 / q.execution_count Average,
e.[text] AS queryText
FROM sys.dm_exec_query_stats q
CROSS APPLY sys.dm_exec_sql_text(q.sql_handle) AS e
1 DESCYou also mentioned transactions. sys.dm_os_performance_counters may be a good one to look at. It has summary information such as Active Transactions, Transactions/sec etc.