What is the permission needed for viewing performance dashboard reports

• M&M

  SSC-Insane

  Points: 21700

  More actions

  March 23, 2010 at 12:44 pm

  #156812

  Could you please let me know what permissions are required in order to view the performance dashboard reports in SQL Server.

  With sysadmin, I am able to view the reports. But I cannot grant sysadmin on my server to others. Please share your inputs.

  M&M

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 24, 2010 at 9:02 am

  #1138965

  Because they use DMV"s you need VIEW SERVER STATE and/or VIEW DATABASE STATE.

  http://technet.microsoft.com/en-us/library/ms188754.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• M&M

  SSC-Insane

  Points: 21700

  More actions

  March 24, 2010 at 11:14 am

  #1139082

  I tried below options and it worked.

  GRANT VIEW SERVER STATE TO user

  GRANT ALTER TRACE TO user

  M&M