Moviri Integrator for TrueSight Capacity Optimization - Dynatrace

"Moviri Integrator for TrueSight Capacity Optimization – Dynatrace" is an additional component of BMC TrueSight Capacity Optimization product. It allows extracting data from Dynatrace.  Relevant capacity metrics are loaded into BMC TrueSight Capacity Optimization, which provides advanced analytics over the extracted data.

The integration supports the extraction of both performance and configuration.

The documentation is targeted at BMC TrueSight Capacity Optimization administrators, in charge of configuring and monitoring the integration between BMC TrueSight Capacity Optimization and Dynatrace.

Requirements

Supported versions of data source software

  • Dynatrace SaaS
  • API version: v1

Supported versions of TSCO

  • 11.3.01

Installation

Downloading the additional package

ETL Module is made available in the form of an additional component, which you may download from BMC electronic distribution site (EPD) or retrieve from your content media.

Installing the additional package

To install the connector in the form of a TrueSight Capacity Optimization additional package, refer to Performing system maintenance tasks instructions.

Datasource Check and Configuration

Preparing to connect to the data source software

The Dynatrace Connector requires an authorization token in order to access Dynatrace API.

To generate the token follow these steps:

  1. Login to the Dynatrace environment

  2. From the left bar select “Settings”

  3. Expand the “Integration” menu

  4. Select “Dynatrace API”

  5. The only required permission is “Access problem and event feed, metrics, and topology”

  6. Give a name to the token and then click “Generate Token”

  7. Copy the generated token and use it in the ETL configuration.

In order to verify if the token is working, you can execute the following command from a linux console:

  • curl -H "Authorization: Api-Token <token>" https://<dyantrace-fqdn>/api/v1/config/clusterversion


An output similar to the following should be obtained:

{"version": "1.137.79.20180123-105448"}

Connector configuration attributes

The following table shows specific properties of the connector, all the other generic properties are documented here.


Property Name

Value Type

Required?

Default

Description

Dynatrace - Connection Parameters

Dynatrace URL prefix

String

Yes

-

Dynatrace URL.

The URL must be in the form "https://{id}.live.dynatrace.com"

Dynatrace API Token

String

Yes


Dynatrace API Token

Use HTTP Proxy to connect to Dynatrace

Boolean

Yes

No

Select yes if a HTTP proxy is required in order to connect to Dynatrace API

Use HTTPS

Boolean

No

No

Whether or not use HTTPS to connect to the HTTP(S) proxy.

HTTP Proxy address

String

No

-

HTTP Proxy FQDN or IP Address

HTTP Proxy port

Number

No

-

HTTP(S) proxy server port

HTTP Proxy username

String

No

-

HTTP(S) proxy server username

HTTP Proxy password

String

No

-

HTTP(S) proxy server password

Dynatrace - Extraction

Default Lastcounter (YYYY-MM-DD HH24:MI:SS)

String

Yes

-

Initial timestamp from which extract data.

Batch Size

Number

Yes

10

Specify how many entities is extracted at the same time from Dynatrace

Data Resolution

Select

Yes

5 Minutes

Select at which resolution data will be imported into TSCO.

Possible values are:

  • 5 Minutes
  • 15 Minutes
  • 30 Minutes
  • 1 Hour

Dynatrace - FIlter

Collect infrastructure metrics

Boolean

Yes

Yes

If selected, the connector will collect metrics at host level (VM, Generic)

Application Whitelist

String

No

-

Semicolon separated list of Java Regular Expression that will be used to filter the extracted applications

Application Blacklist

String

No

-

Semicolon separated list of Java Regular Expression that will be used to filter the extracted applications

The following image shows the list of options in the ETL configuration menu, with advanced properties.


Supported entities

The following entities are supported:

TSCO EntityDynatrace entity
Virtual Machine (VMware, Hyper-V) / GenericHosts
Application Server InstanceProcess Groups of JBoss, Tomcat and JVM
Web Server InstanceProcess Groups of Apache HTTPD and Nginx
Database Server InstanceProcess Groups of MySQL and Postgres Databases

Additional information on Dynatrace entities can be found in the official Dynatrace documentation: https://www.dynatrace.com/support/help/.

Hierarchy

The connector is able to replicate relationships and logical dependencies among these entities. In particular all the available Application are imported with their services and hosts. Additional hosts and services that are not part of a specific application will be imported in another domain tree.

Configuration and performance metrics mapping


Dyantrace entity
TSCO entity
PERF/CONF
Dynatrace Metric
TSCO Metric
Conversion factor
Business Driver
Key RequestBusiness DriverPerfcom.dynatrace.builtin:servicemethod.responsetimeEVENT_RESPONSE_TIME0.000001
Key RequestBusiness DriverPerfcom.dynatrace.builtin:servicemethod.requestsperminEVENT_RATE1.0 / 60.0
Hosts (Generic, VMware Virtual Machine, Hyper-v Virtual Machine)
HostGeneric/VM
Perf
com.dynatrace.builtin:host.cpu.system + com.dynatrace.builtin:host.cpu.other + com.dynatrace.builtin:host.cpu.user
CPU_UTIL0.001
HostGeneric/VM
Perf
com.dynatrace.builtin:host.cpu.idleCPU_UTIL_IDLE0.001
HostGeneric/VM
Perf
com.dynatrace.builtin:host.cpu.system + com.dynatrace.builtin:host.cpu.otherCPU_UTIL_SYSTEM0.001
HostGeneric/VM
Perf
com.dynatrace.builtin:host.cpu.userCPU_UTIL_USER0.001
HostGeneric/VM
Perf
com.dynatrace.builtin:host.cpu.iowaitCPU_UTIL_WAIO0.001
HostGeneric/VM
Perf
com.dynatrace.builtin:host.cpu.stealCPU_UTIL_OVERHEAD0.001
HostGeneric/VM
Perf
(com.dynatrace.builtin:host.cpu.system + com.dynatrace.builtin:host.cpu.other + com.dynatrace.builtin:host.cpu.user) *
cpuCores
CPU_USED_NUM
HostGeneric/VMPerfcom.dynatrace.builtin:host.mem.availableMEM_FREE
HostGeneric/VMPerfcom.dynatrace.builtin:host.mem.availablepercentageMEM_UTIL
HostGeneric/VMPerfcom.dynatrace.builtin:host.mem.usedMEM_USED
HostGeneric/VMPerfSUM(com.dynatrace.builtin:host.nic.bytesreceived)NET_IN_BYTE_RATE
HostGeneric/VMPerfSUM(com.dynatrace.builtin:host.nic.bytessent)NET_OUT_BYTE_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.nic.bytesreceivedBYIF_IN_BYTE_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.nic.bytessentBYIF_OUT_BYTE_RATE
HostGeneric/VMPerfSUM(com.dynatrace.builtin:host.nic.packetsreceived)NET_IN_PKT_RATE
HostGeneric/VMPerfSUM(com.dynatrace.builtin:host.nic.packetssent)NET_OUT_PKT_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.nic.packetsreceivedBYIF_IN_PKT_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.nic.packetsreceivederrors + com.dynatrace.builtin:host.nic.packetsreceiveddroppedBYIF_IN_PKT_ERROR_RATE
HostGeneric/VMPerfSUM(com.dynatrace.builtin:host.nic.packetsreceivederrors + com.dynatrace.builtin:host.nic.packetsreceiveddropped)NET_IN_PKT_ERROR_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.nic.packetssentBYIF_OUT_PKT_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.nic.packetssenterrors + com.dynatrace.builtin:host.nic.packetssentdroppedBYIF_OUT_PKT_ERROR_RATE
HostGeneric/VMPerfSUM(com.dynatrace.builtin:host.nic.packetssenterrors + com.dynatrace.builtin:host.nic.packetssentdropped)NET_OUT_PKT_ERROR_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.availablespaceBYFS_FREE
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.bytesreadBYFS_READ_BYTE_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.byteswrittenBYFS_WRITE_BYTE_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.freespacepercentageBYFS_USED_SPACE_PCT
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.queuelengthBYDISK_QUEUE_SIZE
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.readoperationsBYFS_READ_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.writeoperationsBYFS_WRITE_RATE
HostGeneric/VMPerfcom.dynatrace.builtin:host.disk.usedspaceBYFS_USED
HostGeneric/VMerfcom.dynatrace.builtin:host.disk.freespacepercentageBYFS_USED_SPACE_PCT
HostGeneric/VMConfcom.dynatrace.builtin:host.disk.availablespace + com.dynatrace.builtin:host.disk.usedspace BYFS_SIZE
HostGeneric/VMConfSUM(com.dynatrace.builtin:host.disk.availablespace + com.dynatrace.builtin:host.disk.usedspace)TOTAL_FS_SIZE
HostGeneric/VMConfSUM(com.dynatrace.builtin:host.disk.usedspace)TOTAL_FS_USED
HostGeneric/VMConfcom.dynatrace.builtin:host.mem.available + com.dynatrace.builtin:host.mem.usedTOTAL_REAL_MEM
HostGeneric/VMConfosTypeOS_FAMILY
HostGeneric/VMConfosVersionOS_TYPE
HostGeneric/VMConfipAddressesNET_IP_ADDRESSES
HostGeneric/VMConfcpuCoresCPU_NUM
HostGeneric/VMConflogicalCpuCoresCPU_CORES_PER_SOCKET
HostGeneric/VMConfhypervisorTypeHW_VENDOR
HostGeneric/VMConfbitnessCPU_FAMILY
Services
Tomcat / JBossApplication Server InstancePerfcom.dynatrace.builtin:service.requestsperminBYENDPOINT_TRANSACTION_RATE1 / 60
Tomcat / JBossApplication Server InstancePerfcom.dynatrace.builtin:service.responsetimeBYENDPOINT_RESPONSE_TIME1 / 60
Httpd / NginxWeb Server InstancePerfcom.dynatrace.builtin:service.requestsperminBYENDPOINT_TRANSACTION_RATE1 / 60
Httpd / NginxWeb Server InstancePerfcom.dynatrace.builtin:service.responsetimeBYENDPOINT_RESPONSE_TIME1 / 60
Process Groups

Tomcat / JBoss

Application Server Instance




Perf






com.dynatrace.builtin:pgi.cpu.usage



CPU_UTIL


0.001

Httpd / Nginx

Web Server Instance

Postgres / MySQL

Database Server Instance

Tomcat / JBoss

Application Server Instance



Perf


com.dynatrace.builtin:pgi.mem.usage


MEM_USED




Httpd / Nginx

Web Server Instance

Postgres / MySQL

Database Server Instance

Tomcat / JBoss

Application Server Instance


Perf


com.dynatrace.builtin:pgi.nic.bytesreceived
NET_IN_BYTE_RATE

Httpd / Nginx


Web Server Instance

Postgres / MySQL


Database Server Instance

Tomcat / JBoss


Application Server InstancePerfcom.dynatrace.builtin:pgi.nic.bytessentNET_OUT_BYTE_RATE

Httpd / Nginx


Web Server Instance

Postgres / MySQL


Database Server Instance

Tomcat / JBoss


Application Server InstanceConftechnologyType.type + technologyType.versionVERSION

Httpd / Nginx


Web Server Instance

Postgres / MySQL


Databases
MySQLDatabase Server InstancePerfruxit.python.mysql:innodb_buffer_pool_sizeDB_BUFFER_POOL_SIZE
MySQLDatabase Server InstancePerfruxit.python.mysql:innodb_buffer_pool_size - ((ruxit.python.mysql:innodb_buffer_pool_size / ruxit.python.mysql:innodb_buffer_pool_pages_total) * ruxit.python.mysql:innodb_buffer_pool_pages_free)DB_BUFFER_POOL_USED
MySQLDatabase Server InstancePerf((ruxit.python.mysql:innodb_buffer_pool_size / ruxit.python.mysql:innodb_buffer_pool_pages_total) * ruxit.python.mysql:innodb_buffer_pool_pages_free) / ruxit.python.mysql:innodb_buffer_pool_sizeDB_BUFFER_POOL_UTIL
MySQLDatabase Server InstancePerfruxit.python.mysql:innodb_data_readsDB_PHYSICAL_READS
MySQLDatabase Server InstancePerfruxit.python.mysql:innodb_data_writesDB_PHYSICAL_WRITES
MySQLDatabase Server InstancePerfruxit.python.mysql:queriesDB_QUERY_RATE
MySQLDatabase Server InstancePerfruxit.python.mysql:slow_queries_rateDB_SLOW_QUERY_PCT
MySQLDatabase Server InstancePerfruxit.python.mysql:threads_connectedDB_SESSIONS
MySQLDatabase Server InstancePerfruxit.python.mysql:threads_runningDB_ACTIVE_SESSIONS
Postgres Database Server InstancePerfruxit.python.postgresql:cache_hit_ratioDB_BUFFER_CACHE_HIT_RATIO
PostgresDatabase Server InstancePerfruxit.python.postgresql:idx_tup_fetch + ruxit.python.postgresql:seq_tup_readDB_SELECT_RATE
PostgresDatabase Server InstancePerfruxit.python.postgresql:tup_insertedDB_ROWS_UPDATED_RATE
PostgresDatabase Server InstancePerfruxit.python.postgresql:tup_updatedDB_ROWS_INSERTED_RATE
PostgresDatabase Server InstancePerfruxit.python.postgresql:tup_deletedDB_ROWS_DELETED_RATE
PostgresDatabase Server InstancePerfruxit.python.postgresql:xact_commitDB_COMMIT_RATE
MySQL / PostgresDatabase Server InstanceConfsoftwareTechnologies.typeDB_PRODUCT_NAME
MySQL / PostgresDatabase Server InstanceConfsoftwareTechnologies.versionDB_PRODUCT_VERSION
 

Troubleshooting

For ETL troubleshooting, please refer to official BMC documentation available here.

Was this page helpful? Yes No Submitting... Thank you

Comments