topic Re: Monitor table activity in a DB in Open Q&A

Monitor table activity in a DB

cleoleeps1 — Tue, 19 Nov 2024 17:21:59 GMT

I'm not sure how I can do this about Database. Appreciate pointers from the Gurus here.

FYI, we have many DBs in a MS SQL servers. And there are plenty of tables in each DB.

My interest is only on 2 tables.

I would like to be able to view a DB table's growth such as how and when data was added or deleted over a period of time.

I wonder how can I do that?

Note: Currently we do not use activeGate anyway.

AntonPineiro — Tue, 19 Nov 2024 18:20:59 GMT

Hi,

I would say creating your own extension where you execute SQL queries or logs. But you would need an ActiveGate.

Best regards

cleoleeps1 — Wed, 20 Nov 2024 05:12:44 GMT

Hi AntonPineiro, I believe what you mentioned is similar to this https://docs.dynatrace.com/docs/ingest-from/extensions20/data-sources/sql#supported-database-providers ? It involves creating extensions, SQL server config including activeGate and SSL?

Peter_Youssef — Wed, 20 Nov 2024 07:03:57 GMT

PFA options regarding the raised concern:

You can also build your own Extension as highlighted by @AntonPineiro

The third option:

Contacting Dynatrace Extensions team for developing the required extension "Professional paid service"

All the best &&Hoping it helps.

BR,

Peter

AntonPineiro — Wed, 20 Nov 2024 09:07:19 GMT

Hi,

Yes, if official SQL extension does not provide you that information. We can create your own.

Best regards