topic Re: Monitoring using MS SQL Extension in infrastructure monitoring mode in Extensions

Monitoring using MS SQL Extension in infrastructure monitoring mode

Shirai — Tue, 26 Nov 2024 02:57:56 GMT

I installed OneAgent on the DB server where MS SQL is running, and set it to infrastructure mode for monitoring. I needed to monitor MS SQL, so I set up the extension "Microsoft SQL Server (local) Ver. 1.2.14", and the status was displayed as "OK".
However, nothing is displayed on the dashboard, and I cannot obtain any metrics. I would like to find the cause of this problem.
Based on the documentation, I believe this extension will work in infrastructure mode as well.
I would like to find the cause of this problem.

Re: Monitoring using MS SQL Extension in infrastructure monitoring mode

rastislav_danis — Thu, 28 Nov 2024 14:28:25 GMT

Local MSSQL extension is running local wmi checks via oneagent (even in infra mode). I suppose EEC was enabled on agent, where extension is running and mssql metrics are accessible via wmi locally. Please check extension logs and maybe change logging level to DEBUG to see more info in log (you can find logs locally or retrieve them via agent diagnostic). You can also click on OK in extension's config to see basic log entries from extension via dynatrace gui.