Monitor table activity in a DB

[cleoleeps1]

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 · Accepted solution]

Hi,

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

Best regards

[cleoleeps1]

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

[AntonPineiro]

Hi,

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

Best regards

[Peter_Youssef · Accepted solution]

Hello @cleoleeps1 

PFA options regarding the raised concern:

• https://www.dynatrace.com/hub/detail/mysql/
• https://docs.dynatrace.com/docs/ingest-from/extend-dynatrace/extend-metrics/ingestion-methods/sql/my...
• https://www.dynatrace.com/hub/detail/mysql-remote-monitoring-v2/

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

• https://www.youtube.com/watch?v=t9kHPKL9yKY
• https://docs.dynatrace.com/docs/ingest-from/technology-support/dynatrace-extensions/dynatrace-extens...
• https://docs.dynatrace.com/docs/ingest-from/extensions20/data-sources/sql/mysql-monitoring
• https://docs.dynatrace.com/docs/ingest-from/extend-dynatrace/extend-metrics/ingestion-methods/sql/my...

The third option:

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

All the best &&Hoping it helps.

BR,

Peter