Dashboard for the application

[khan_82]

I’d like to create a dashboard using DQL to monitor critical services and processes such as IIS, MSSQL, RabbitMQ, and others.

The dashboard will display each service’s availability, CPU usage, memory consumption, and total downtime. It will also include a single aggregated availability value representing all monitored services across all hosts where they are running.

Additionally, I want to track the availability of HTTP and HTTPS services across all hosts to ensure web-facing endpoints are functioning as expected.

Any help on this issue is much appreciated 🙂

[radek_jasinski · Accepted solution]

Hi @khan_82 

If you want to monitor CPU and memory, you can use the metrics builtin:host.cpu.* and builtin:host.mem.*.
To monitor service availability, you can use the metric builtin:pgi.availability.state, which shows if processes are available (Available or Unavailable).

You can filter by process.name or service.name to focus on specific services like IIS, MSSQL, or RabbitMQ.

I also recommend trying this app to practice DQL:
https://www.dynatrace.com/hub/detail/learn-dql/

Radek