Grant Server State
The single grant statement that lets a login view server performance counters and DMVs.
Monitoring tools - and most of the DMV queries in this collection - need the VIEW SERVER STATE permission. This is the one-line grant that gives it to a specific login without making them a sysadmin.
GRANT VIEW SERVER STATE TO << login name >>