topic Re: Databases & Services in Open Q&A

Databases & Services

Adi_10 — Wed, 22 Jan 2025 16:27:35 GMT

Hi Team,

Need help - I have installed OneAgent in full stack mode for 8 servers for 2 different application and created MZ,

Now for my master dashboard I am not getting all the data as needed, I needed Databases, Services, Process and Host Health Data.

However, I am looking to get the below data.

How should I troubleshoot this and get the relevant data for DB and service dashboard.

Re: Databases & Services

Adi_10 — Wed, 22 Jan 2025 16:39:16 GMT

@Peter_Youssef & @HannahM Need Help 🙂

Re: Databases & Services

KeeganNelson — Wed, 22 Jan 2025 17:04:33 GMT

After installing the OneAgent has everything been restarted? Also are you seeing data on the services app? If so when you click into a specific service is it running on the host that you recently installed the OneAgent on?

Re: Databases & Services

KeeganNelson — Wed, 22 Jan 2025 17:08:38 GMT

Also note if you head into the "Deployment status" page, you will see the OneAgent deployments. Check to make sure that the servers where OneAgent was just installed on don't require process restarts.

Re: Databases & Services

Adi_10 — Thu, 23 Jan 2025 07:33:22 GMT

After installing the OneAgent

Has everything been restarted? = NO

Also are you seeing data on the services app? = No

Also are you seeing data on the database services app? = No

No running services on host only Process are running's

Re: Databases & Services

Adi_10 — Thu, 23 Jan 2025 07:35:01 GMT

In Deployment status" page, you will see the OneAgent deployments. It dont need any process restarts

Re: Databases & Services

Adi_10 — Thu, 23 Jan 2025 07:35:29 GMT

@KeeganNelson What should be my next step of actions ?

Re: Databases & Services

KeeganNelson — Thu, 23 Jan 2025 16:07:24 GMT

From this picture above it looks like the monitoring has been disabled for these services. Are these services the ones you are expecting to see monitored?

Re: Databases & Services

AntonPineiro — Thu, 23 Jan 2025 16:58:16 GMT

Hi,

Services and database services would be discovered when processes are restarted.

Best regards

Re: Databases & Services

Adi_10 — Fri, 24 Jan 2025 08:12:24 GMT

Which processes are needed to be restarted.? As there are 7 host and 100+ processes

For ex below -

Re: Databases & Services

AntonPineiro — Fri, 24 Jan 2025 08:57:59 GMT

Hi,

I would say:

Check those are pending to be restarted. Dynatrace tells it to you in Status column, and you can review them in Dynatrace Status section as well.
Check databases processes, and checks which processses are talking to that database process.

In general I would say application servers + Java / .NET. You can review How database activity is monitored.

Best regards

Re: Databases & Services

Abidyaseen — Fri, 24 Jan 2025 13:00:27 GMT

Just open tiles and select edit in data explorer and change the required fields like seperate with required tags or host groups and add tagging rules make sure you have put database rule in tagging rules

Re: Databases & Services

Adi_10 — Fri, 24 Jan 2025 13:29:43 GMT

This cant be done this is my master dashboard for 100+ applications

I need to find a way to get service and database data on it

Re: Databases & Services

Adi_10 — Fri, 24 Jan 2025 13:33:47 GMT

1 Thing i want to understand here:

Correct me if i am wrong

IF one Agent installed and process detected on host , Service is the (a part of process) small steps to do an action like checking the time.

Now when process restart then only i am able to see the service data if that service is available on that procès, and If that service having any calls to database anywhere in dt that or MZ for that app can be tracked in database service?

Re: Databases & Services

AntonPineiro — Fri, 24 Jan 2025 14:09:06 GMT

Hi,

Let me paste an screenshot about database service "chew". This view is backtrace:

That database service was automatically discovered because .NET, Apache and Tomcat processes were restarted and they are living in hosts in Full stack mode.

Best regards

Re: Databases & Services

Adi_10 — Fri, 24 Jan 2025 14:12:11 GMT

Yes, These are process/services i want to monitor and want to be available on Dashboard.

I have turn on deep monitor and will restart those services, Can this will also bring the data for my database services ?

I am so confused between process, services and db services.

Re: Databases & Services

Mizső — Sun, 26 Jan 2025 18:03:51 GMT

Hi @Adi_10,

Is it possible to share your MZ rules?

Recommendation from DT to user processes as a base of the MZ in case of services. So services can de added to the MZ via Processes (underlying services and uderlying hosts).

Despite of the above mentioned resommendation regading database services I also use the method which was mentioned by @AntonPineiro and I always add database services as service to the MZ (with database name or database host name).

Best regards,

János

Re: Databases & Services

Adi_10 — Mon, 27 Jan 2025 08:27:28 GMT

I have not restarted any process or my server, Here is my MZ rules @Mizső

Re: Databases & Services

RohitBisht — Tue, 28 Jan 2025 01:25:21 GMT

I am curious to know what these info icons say next to DOTNET processes.
ALso, are these DOTNET ones calling the database?

Re: Databases & Services

Adi_10 — Mon, 03 Feb 2025 06:31:47 GMT

I have rebooted the server as well as services which i want to monitor still I am not getting the data for databases and services.

@Mizső @AntonPineiro @Abidyaseen @RohitBisht

Help me on this,

However same MZ configuration is working on other server with getting the database and services graphs