0

I have set up a Perfmon data collector set on one of our servers with SQL server running on it. I also have a scheduled task which imports this data into SQL (set up by following this open source project: https://github.com/heraflux/BLGtoSQL ). All this runs with one user on the local machine.

After leaving this running for a couple of weeks I have created a report to look at the data gathered so far. All the Perfmon counters EXCEPT the SQL ones work. All the SQL counters return zero - even though I know at least some of these counters CAN'T always be zero (e.g. User Connections, Free Memory KB etc).

What's odd is that when I run and import the exact same setup on our development server the SQL counters work as desired. I've checked and the user has the same local permissions on each server.

I've also granted the user with the following permissions on the SQL server: Connect Any Database, Connect SQL, View Server State.

When looking at the SQL counters live on Perfmon I've found that they also don't seem to be working. I'm pretty stumped as to why they aren't showing anything.

Samantha
  • 81
  • 6
  • 1
    There are a bunch of issues listed here - see if any of the recommended fixes work for you. https://dba.stackexchange.com/q/13733/1186 – Aaron Bertrand Jun 27 '19 at 11:20
  • @aaron all of the links in that list are to fix when the SQL counters are missing. Mine are not missing, they are all returning as zero. – Samantha Jul 09 '19 at 13:50
  • Okay, but reloading the counters or performing other types of repairs might also fix your issue (which I have never heard of before). So in the absence of any solution proven to fix your specific issue, it can’t hurt to at least try other resolutions known to fix similar (but not identical) problems... kind of like the reboot your computer thing. – Aaron Bertrand Jul 09 '19 at 14:09

0 Answers0