Skip to main content
Skip table of contents

Source Target Sizing

The Target Sizing section shows information about the source which can be used to choose the sizing of the target. Using information form the whole analysis and this section in particular can help in determining the size of a target to accommodate the current workloads.

Source Target Sizing (MongoDB).png

The Target Sizing section for MongoDB sources

The parameters in this section vary by source DB engine:

HBase

Parameter

Description

Table Count

Number of all user-defined tables in HBase.

Region Server Count

Number of all region servers that HMaster is currently aware of.

Region Count

Number of all regions across all user-defined tables.

Max. Used Heap Size

Size of the largest used heap on a single region server.

Avg. Used Heap Size

Average size of the used heaps across region servers.

Max. Requests Per Second

Largest number of requests per second on a single region server.

Avg. Requests Per Second

Average number of requests per second across region servers.

Max. Store File Index Size

Largest size of a store-file index on a single region server.

Avg. Store File Index Size

Average size of the store-file indexes across region servers.

Max. Uncompressed Store File Index Size

Largest size of an uncompressed store-file index on a single region server.

Avg. Uncompressed Store File Index Size

Average size of the uncompressed store-file indexes across region servers.

Max. Uncompressed Store File Size

Largest size of an uncompressed store-file on a single region server.

Avg. Uncompressed Store File Size

Average size of the uncompressed store-files across region servers.

Max. Store File Size

Largest size of a store-file on a single region server.

Avg. Store File Size

Average size of all store-files across region servers (excluding replication).

Max. Store File Count

Maximum number of store files on a single region server.

Avg. Store File Count

Average number of store files on a across region servers.

Total Uncompressed Store File Size

Sum of the uncompressed size of all store files across region servers (excluding replicas).

Total Store File Size

Sum of the size of all store files across region servers (excluding replicas).

MongoDB

Parameter

Description

Data node with max # CPU

The highest number of CPUs detected on any single data-bearing node.

Data node with max RAM (GB)

The highest RAM size detected on any single data-bearing node.

Number of shards

The number of shards in the cluster. On non-sharded clusters this value is zero.

Total collection count

The number of user collections across all data-bearing nodes.

Only user-created collections are included in this count.

Non sharded collections are counted in sharded collections.

A sharded is counted as one, regardless of shard count.

A replicated collection is counted as one, regardless of the number of replicas.

Total index count

The number of distinct indexes on all user collections across all data-bearing nodes.

Calibrate IO MBPS

Not applicable for MongoDB.

Multi-region setup

Indication of whether regional affinity was detected. This is based on tag-aware sharding setup.

Applicable only to sharded clusters.

Max size on disk (GB)

The highest data size on disk detected on any single data-bearing node.

Number of users

Number of users across all databases. This includes the users defined in the admin database as well as those defined in user-created databases.

Number of custom roles

Number of roles user-defined (not built-in) roles, across all databases.

Max replica set member count

The maximum number of Replica Set members found in the cluster in a single Replica Set.

In a sharded topology, this count relates to the shard with the highest number of members.

In a single Replica Set topology, it is equivalent to the Replica Set’s member count.

Not applicable for stand-alone deployment topology.

Oracle

Parameter

Description

Max average active sessions

Maximum across all active session averages collected.

Average 10 max active sessions

Average across top 10 session averages collected.

Average soft parse (%)

The ratio of soft parses vs. all statements parsed.

A soft parse is one for which an existing reusable cached SQL statement exists.

Average CPU time ratio (%)

Average of database CPU time utilization.

Average max CPU time ratio (%)

Average of the database’s overall maximum CPU time utilization.

Average host CPU utilization (%)

Average CPU utilization by the host.

Average 50 host CPU utilization (%)

Average top 50 CPU utilization by the host.

Average Instance CPU Utilization (%)

Average percentage of time the instance processor is busy.

Avg Physical Read Ops/Sec

Physical Read IOPs per second.

Avg Physical Write Ops/Sec

Physical Write IOPs per second.

Peak redo/sec (MB)

Maximum changes per second based on the Redo log.

DB Block Changes Per Sec

DB block changes per second calculated over a maximum of the past 30 days.

Buffer cache hit (%)

The percentage of memory pages found in the buffer cache without having to read from disk. Based on cache hits divided over the past few thousand page-accesses statistics.

Max sessions

The maximum of the average number of sessions which were allowed detected in the database metrics. This includes both active and inactive sessions at those sampling periods.

Max active sessions

The maximum of the average number of active sessions detected in the database metrics.

Max allowed sessions

The configured limit on the number of concurrent sessions.

Calibrate IO IOPS

Maximum IOPS the source can handle.

Calibrate IO MBPS

Maximum MBPS the source can handle.

Physical to logical reads ratio (%)

Ratio of physical to logical reads. Physical reads are reads which could not be satisfied from PGA/cache and required a read from disk.

Redo Generated Per Sec (in MB)

Redo entries generated per second over a maximum of the past 30 days.

Physical Reads Total MBps

Source total physical reads per second in megabytes.

Physical Writes Total MBps

Source total physical writes per second in megabytes.

User Transaction Per Sec

User transaction per second over a maximum of the past 30 days.

User Commits Per Sec

User commits per second over a maximum of the past 30 days.

User Rollbacks Per Sec

User rollbacks per second over a maximum of the past 30 days.

PostgreSQL and MySQL

The fields shown for PostgreSQL and MySQL sources are:

  • Average 10 max active sessions

  • Average soft parse (%)

  • Average CPU time ratio (%)

  • Average max CPU time ratio (%)

  • Average host CPU utilization (%)

  • Average 50 host CPU utilization (%)

  • Buffer cache hit (%)

  • Calibrate IO IOPS

  • Calibrate IO MBPS

  • Max sessions

  • Max active sessions

  • Max allowed sessions

  • Max average active sessions

  • Peak redo/sec (MB)

  • Physical to logical reads ratio (%)

SQL Server

Parameter

Description

Max sessions

The maximum of the average number of sessions which were allowed detected in the database metrics. This includes both active and inactive sessions at those sampling periods.

Max active sessions

The average concurrent sessions among the top 10 connected session hosts.

Max allowed sessions

The configured limit on the number of concurrent sessions.

Buffer cache hit (%)

The percentage of memory pages found in the buffer cache without having to read from disk. Based on cache hits divided over the past few thousand page-accesses statistics.

Calibrate IO IOPS

Not applicable for SQL server.

Calibrate IO MBPS

Not applicable for SQL server.

Max average active sessions

The maximum of the average number of sessions which were allowed detected in the database metrics. This includes both active and inactive sessions at those sampling periods.

Average 10 max active sessions

Average across top 10 session averages collected.

Average soft parse (%)

The ratio of soft parses vs. all statements parsed.

A soft parse is one for which an existing reusable cached SQL statement exists.

Average CPU time ratio (%)

Average of database CPU time utilization.

Average max CPU time ratio (%)

Average of the database’s overall maximum CPU time utilization.

Peak redo/sec (MB)

Maximum changes per second based on the Redo log.

Physical to logical reads ratio (%)

Ratio of physical to logical reads. Physical reads are reads which could not be satisfied from memory and required a hard read from disk.

Average host CPU utilization (%)

An estimated average of CPU utilization on the host, outside of the database.

Average 50 host CPU utilization (%)

An estimated average of CPU utilization on the host, outside of the database, over the top 50 utilization peaks.

Average Task Count

Average number of tasks currently running or scheduled to execute in the database.

Top Total Worker Time for entire instance

The maximum worker time detected for a single worker in a database across the instance.

Total I/O Utilization By source (MB)

Total I/O utilization across all databases.

This measure includes reads and writes.

Top Waits 8

The highest wait time detected. Based on the maximum wait-duration detected.

Max Instance Memory (MB)

Maximum memory usage at the Instance level.

Resource Defined Limit (MB)

Maximum memory allowed to be utilized in the Instance.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.