Performance Counters Missing in SQL 2016 SP2

  • Hi, I'm looking for a fix to an issue where performance counters are missing from SQL 2016 (SP2).

    All SQL related counters are available in the OS i.e. Perfmon but only and small amount related to XTP are available in SQL itself e.g. if I run the following

    SELECT * FROM sys.dm_os_performance_counters

    It returns 57 rows and all counters deal with XTP, everything else is missing.

    Any suggestions for a fix greatly appreciated.

    Thanks in advance.

  • You need to unload and reload the counters.

    Plenty on the internet with a quick search for this.

    Heres one from Pinal https://blog.sqlauthority.com/2014/11/07/sql-server-performance-counter-missing-how-to-get-them-back/

  • Thanks for your reply, but Pinals article describes a fix to the opposite of the problem I'm having.

    All of the articles I've been able to find describe the reverse of the situation I'm having, hence the forum post.

    Describing it again for clarity, SQL counters are available in Perfmon, but (mostly) absent from sys.dm_os_performance_counters.

    Thanks.

  • As a guess, could it be permission related?  I am wondering if you are running it with a restricted account and you need a full sysadmin to see all of the rows?

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!

  • Resolved by rebooting the server, in case anyone ever needs to know.

    Not permissions related, my account has SA privilege's on the server in question.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply