Monitoring System DMV - Activity Monitor - SQL Server 2008 R2 - Permissions

USE MASTER

GO

CREATE LOGIN [Domain\Username] FROM WINDOWS WITH

DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english]

GO

USE [DBA]

GO

CREATE USER [Domain\Username] FOR LOGIN [Domain\Username]

GO

USE [DBA]

GO

EXEC sp_addrolemember N'db_owner', N'Domain\Username'

GO

USE [master]

GO

CREATE USER [Domain\Username] FOR LOGIN [Domain\Username]

GO

GRANT VIEW SERVER STATE TO [Domain\Username]