June 16, 2021 at 1:23 am
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.
June 16, 2021 at 10:55 am
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/
June 17, 2021 at 12:22 am
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.
June 21, 2021 at 5:05 pm
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!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 22, 2021 at 11:21 pm
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply