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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply