Perf counters from Windows Host agent
Hi,
Can the host agent in windows host collect custom performance counter measures. I did a quick test similar to what we do with .Net agent but it didn’t work.
What I’m trying to do is get the SQL server performance counters using the host agent installed on the DB host server.
Earlier we used to setup monitors but getting access to the DB server for our collectors is very difficult. So we got the agent installed on the Host.
It would be great is the agent can collect the performance stats of the SQL DB like the plugin does.
-Sreerag
The host agent has no capabilities in the moment to capture additional metrics outside those that it captures by default (Net, Disk, Mem, CPU). If you happen to have a .NET Agent installed on that same box you can capture custom Win Perf Counters assuming that the user that runs the.NET Process you monitor has privileges to capture any type of perf counters. If you dont have such an agent on that box you need to use a Collector and our Monitor plugins
Andi
Thanks Andi, I need to figure out a .Net process that i can instrument on the SQL server host.
Just a thought:
What if the host agent on SQL server could get the SQL server metrics.
Also associate that data to transaction and fill in the process status in the below screenshot.
-Sreerag
I agree - it is a great thought and I know we have plans to extend the host monitor agent. But right now the capability to capture additional metrics is not there. I am pretty sure there is already an RFE for this
Andi
