Share this page

# ALM Advisor

ALM Advisor collects and analyzes environment details to assess the current ALM deployment and to recommend usage improvements. The collected data can also be helpful when contacting support.

In this topic:

## Collect and assess ALM data

You can assess the current ALM deployment and recommend usage improvements based on the collected environment details.

To collect environment details:

1. From the Site Administration masthead, select Tools > ALM Advisor to open the ALM Advisor window.

2. Select the Data Protection checkbox to protect sensitive data. Click the question mark icon for more information about the data protection process.

3. Click Collect to begin the data collection process.

   The collected data is stored in the following package: C:\ProgramData\Micro Focus\ALM\Repository\productData\assessment\results\AssessmentInfo_<current date>.zip

   An email notification is sent when the process is completed. If the collection process is not completed successfully, ensure that all nodes are active and rerun the data collection process.

4. After the data collection process is completed, click the Go to Site link to open the ALM Advisor website.

5. Follow the instructions on the website to upload the collected data and to complete the assessment process.

Back to top

## Database common data

ALM Advisor collects the following database common data of your environment.

Property Name | Description
--- | ---
Name | DB Server name
Version | DB Server version

Back to top

## SQL Server data

ALM Advisor collects the following SQL Server data of your environment.

Property Name | Description
--- | ---
productLevel | The level of the version of the SQL Server instance
edition | The installed product edition of the SQL Server instance
engineEdition | Database Engine edition of the SQL Server instance installed on the server
editionId | The edition ID of the SQL Server instance
isFullTextInstalled | Indicates whether the full-text and semantic indexing components are installed on the current SQL Server instance.
collation | Name of the default collation for the server
osMachineName | Windows computer name on which the server instance is running

Some of the SQL Server properties require the site administrator of that database to have advanced options permissions. To ensure these permissions, run the following:

Copy code

    sp_configure 'show advanced options', 1
    GO
    RECONFIGURE
    GO

Back to top

## Oracle database data

ALM Advisor collects the following Oracle database data of your environment.

Property Name | Description
--- | ---
sga_max_size | Hard limit up to which sga_target can dynamically adjust sizes
processes | The maximum number of operating system user processes that can simultaneously connect to Oracle
sessions | Maximum number of sessions that can be created in the system
cpu_count | The number of CPUs available for use by the Oracle database
db_cache_size | The size of the DEFAULT buffer pool for buffers with the primary block size
log_buffer | The amount of memory (in bytes) that Oracle uses when buffering redo entries to a redo log file
shared_pool_size | The size of the shared pool
large_pool_size | The size of the large pool allocation heap
java_pool_size | The size of the Java pool, from which the Java memory manager allocates most Java state during runtime execution
pga_aggregate_target | The target aggregate PGA memory available to all server processes attached to the instance
optimizer_mode | Establishes the default behavior for choosing an optimization approach for the instance.
optimizer_features_enable | Acts as an umbrella parameter for enabling a series of optimizer features based on an Oracle release number.
compatible | Allows using a new release of Oracle, while at the same time guaranteeing backward compatibility with an earlier release.
cursor_sharing | Determines what kind of SQL statements can share the same cursors.
open_cursors | Specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once.
session_cached_cursors | Specifies the number of session cursors to cache.
memory_max_target | Specifies the maximum value to which a DBA can set the MEMORY_TARGET initialization parameter.
sga_target | Specifies the total size of all SGA components.
NLS Parameters (NLS_CHARACTERSET, NLS_LANGUAGE , NLS_TERRITORY, NLS_LENGTH_SEMANTICS) | Character set related information

Back to top

## Site usage data

ALM Advisor collects the following site usage data of your environment.

Property Name | Description
--- | ---
usersCount | Number of site users
activeUsersCount | Number of active site users
operativeUsersCount | Number of active site users who opened a session in the last 30 days
projectsCount | Number of projects
activeProjectsCount | Number of active projects
operativeProjectsCount | Number of active projects that had a session in the last 30 days

Back to top

## Application server data

ALM Advisor collects the following application server data of your environment.

Property Name | Description
--- | ---
maxDbConnectionsAllowed | The maximum concurrent db connections allowed
connectorName | Jetty connector name
maxConnectionsRequest | The maximum number of connections requests
maxConnectionsOpen | The maximum number of open connections
maxConnectionsDuration | The maximum duration of connections

Back to top

## Architecture data

ALM Advisor collects the following architecture data of your environment.

Property Name | Description
--- | ---
activeNodes | Number of active nodes- application servers
totalNodes | Total number of nodes
serverName | Application server name
isActive | Application server status

Back to top

## General site data

ALM Advisor collects the following general site data of your environment.

Property Name | Description
--- | ---
almEdition | ALM edition
almEditionDisplayName | ALM edition display name
informationCollectionTime | Information collection time in milliseconds
extensionName | Extension name
extensionDisplayName | Extension display name
version | Extension version

Back to top

## Cache data

ALM Advisor collects the following cache data of your environment.

Property Name | Description
--- | ---
cacheManagerName | Name of the EHCache manager
cacheName | Name of the cache
objectCount | Number of items found in cache
maxElementsInMemory | Sets the maximum number of objects created in memory.
maxElementsOnDisk | Sets the maximum number of objects maintained in the DiskStore.
memoryStoreEvictionPolicy | Policy enforced upon reaching the maxElementsInMemory limit
eternal | Determines whether an element is eternal, meaning that timeouts are ignored and the element is never expired.
timeToIdleSeconds | Sets the time for an element to idle before it expires.
timeToLiveSeconds | Sets the time for an element to live before it expires.
overflowToDisk | Determines whether elements can overflow to disk when the memory store reaches the maxElementsInMemory limit.
diskPersistent | Determines whether the disk store persists between restarts of the Virtual Machine.
diskSpoolBufferSizeMB | The size to allocate the DiskStore for a spool buffer
diskExpiryThreadIntervalSeconds | The number of seconds between runs of the disk expiry thread
statisticsAccuracy | The accuracy of the cache statistics at the time the statistic was computed
cacheHits | The number of times a requested item was found in the cache
onDiskHits | The number of times a requested item was found in the Disk Store
inMemoryHits | The number of times a requested item was found in the Memory Store
misses | The number of times a requested element was not found in the cache
averageGetTime | The average get time
evictionCount | Gets the number of cache evictions since the cache was created or statistics were cleared.

Back to top

## JVM data

ALM Advisor collects the following JVM data of your environment.

Property Name | Description
--- | ---
jvmVersion | Version of JVM being used
usedHeapSize | The total amount of memory in the Java virtual machine
maxHeapSize | The maximum amount of memory that the Java virtual machine attempts to use
freeHeapSize | The amount of free memory in the Java virtual machine
nonHeapUsedSize | The amount of used memory in bytes
nonHeapInitSize | The amount of memory in bytes that the Java virtual machine initially requests from the operating system for memory management
nonHeapCommittedSize | The amount of memory in bytes that is committed for the Java virtual machine to use
nonHeapMaxSize | The maximum amount of memory in bytes that can be used for memory management
name | The name representing this memory manager
collectionElapseTime | The approximate accumulated collection elapsed time in milliseconds
innerCollectionCount | The total number of collections that have occurred
memoryPoolNames | The names of memory pools that this memory manager manages
architecture | Architecture of the JVM being used
is64Bit | Whether the JVM being used has 64 bits architecture
numberOfProcessorsAvailable | Number of processors available for this JVM

Back to top

## Machine specification data

ALM Advisor collects the following specification data of your machine.

Property Name | Description
--- | ---
totalMemoryMB | Total memory installed on the machine

Back to top

## QC Scene data

ALM Advisor collects the following QC Scene data in your environment.

Property Name | Description
--- | ---
startGroupingTime | Segment starting time
endGroupingTime | Segment ending time
nodeName | Name of the node for which the data was collected
measurementName | Name of the measurement collected during the segment
weightedMeanAverageValue | Weighted mean of the average value recorded during the segment
minimumValue | Minimum value recorded during the segment
weightedMeanMinimumValue | Weighted mean of the minimum value recorded during the segment
maximumValue | Maximum value recorded during the segment
weightedMeanMaximumValue | Weighted mean of the maximum value recorded during the segment
measurementsInspectedNumber | Number of records (measurement values) recorded during the segment

Back to top

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 16.00-16.0.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: