Share via

permisions on sys.dm_os_performance_counters

NeophyteSQL 241 Reputation points
2021-02-05T16:50:19.897+00:00

one of the sql accounts related to monitoring tools needs read permissions on the sys.dm_os_performance_counters

does this dmv exist only in master or should the reas permisions be provided to this dmv in all of the user databases as well

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,126 questions
0 comments
Accepted answer
  1. Sean Gallardy - MSFT 1,886 Reputation points Microsoft Employee
    2021-02-05T17:27:59.713+00:00

    one of the sql accounts related to monitoring tools needs read permissions on the sys.dm_os_performance_counters

    This is documented here, it'll need view server state to see that information.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,991 Reputation points Microsoft Vendor
    2021-02-08T03:04:23.037+00:00

    Hi @NeophyteSQL ,

    Was your issue resolved?
    As SeanGallardy mentioned, to query sys.dm_os_performance_counters requires VIEW SERVER STATE permission. This permission is applied at the server level. You can grant this permission from the server properties ->permissions page.
    65172-01.jpg

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. NeophyteSQL 241 Reputation points
    2021-02-22T17:32:21.237+00:00

    thank you all very much , Yes this has been resolved.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.