This guide shows you how to install and manage version 3.10 (latest)of Google Cloud's Agent for SAP on a fleet of Compute Engine VMs within a specific zone by using VM Extension Manager .
VM Extension Manager policy lets you perform tasks such as the following:
- Fleet-wide installation: Install Google Cloud's Agent for SAP on all VMs in a zone, or on a subset of VMs identified by labels in a zone.
- Configuration management: Apply a custom configuration to the agent instance on all VMs managed by a policy.
To install and configure the agent on a Compute Engine instance by using a package manager, see Install Google Cloud's Agent for SAP on a Compute Engine instance .
Before you begin
Before you install Google Cloud's Agent for SAP on your VM fleet by using VM Extension Manager, make sure that the following prerequisites are met:
- The Linux or Windows operating system (OS) version running on your VM fleet
satisfies the following criteria:
- The OS version is certified by SAP for use with your target SAP application or database. For more information, see OS support for SAP HANA on Google Cloud and OS support for SAP NetWeaver on Google Cloud .
- The OS version is compatible with VM Extension Manager. For information about the OS versions that VM Extension Manager supports, see Supported operating systems .
- You've set up VM Extension Manager .
- You've granted the required IAM roles for the agent .
- You've enabled access to Google Cloud APIs .
Set up VM Extension Manager
To set up VM Extension Manager, complete the following steps:
- In the VM Extension Manager documentation, review the Before you begin section.
-
Set up the IAM roles needed to create and manage VM Extension Manager policies. For more information, see the following:
Required IAM roles for the agent
To access Google Cloud resources, the Agent for SAP uses the service account attached to the VM hosting the agent.
To ensure that this service account has the necessary permissions to let Google Cloud's Agent for SAP send metrics to the SAP Host Agent, ask your administrator to grant the service account the following IAM roles on your project:
- Compute Viewer (
roles/compute.viewer) : to collect metrics from the Compute Engine instance that hosts your SAP system. - (Recommended) Logs Writer (
roles/logging.logWriter) : to send agent logs to Cloud Logging - Monitoring Viewer (
roles/monitoring.viewer) to view the metrics collected in Cloud Monitoring. - Workload Manager Insights Writer (
roles/workloadmanager.insightWriter) : to write the collected metrics to Workload Manager data warehouse.
For more information about granting roles, see Manage access to projects, folders, and organizations .
These predefined roles contain the permissions required to let Google Cloud's Agent for SAP send metrics to the SAP Host Agent. Your administrator might also be able to give the service account these permissions with custom roles or other predefined roles .
Enable access to Google Cloud APIs
Compute Engine recommends configuring your compute instances to allow all access scopes to all Cloud APIs and using only the IAM permissions of the instance service account to control access to Google Cloud resources. For more information, see Create a VM that uses a user-managed service account .
If you limit access to the Cloud APIs, then Google Cloud's Agent for SAP requires the following minimum access scopes on the host Compute Engine instance:
- Cloud Platform: Enabled
- Compute Engine: Read Only
- Stackdriver Monitoring API: Read Only
If you are running SAP applications on a compute instance that does not have an external IP address, then you need to enable Private Google Access on the subnet of the compute instance so that Google Cloud's Agent for SAP can access Google APIs and services. To enable Private Google Access on a subnet, see Configure Private Google Access .
Install the agent on a fleet of VMs
To install the latest version of Google Cloud's Agent for SAP on your VM fleet within a specific zone by using a VM Extension Manager policy, complete the following steps:
Console
-
In the Google Cloud console, go to the VM extension policiespage.
-
Click Create extension policy.
-
In the Namefield, enter a name for the policy.
-
Optional: In the Descriptionfield, enter a description for the policy.
-
In the Priorityfield, specify a priority number to resolve conflicts between policies. Lower numbers indicate higher priority. The default value is
1000. -
Using the Regionand Zonelists, select the zone where you want to apply this policy.
-
In the Extensionssection, click Add extensionand then do the following:
- From the Extensionlist, select Google Cloud's Extension for SAP.
-
Leave the Versionfield blank.
This directs the policy to install the latest version of Google Cloud's Agent for SAP.
-
Optional: In the Configuration file contentfield, enter the configuration that you want to apply to the agent.
For information about the configuration parameters supported by the agent, see Configuration parameters .
-
Click Done.
-
Optional: To limit the policy rollout to the required VMs, do the following:
- Click Add labelsand include the labels that identify the required VMs.
- Click Done.
-
Click Create.
gcloud
gcloud beta compute zone-vm-extension-policies create POLICY_NAME \ --zone = ZONE \ --extensions = google-cloud-sap-extension \ [ --description = " DESCRIPTION " \] [ --config-from-file = google-cloud-sap-extension = CONFIG_FILE_PATH \] [ --inclusion-labels = KEY_1 = VALUE_1 \] [ --inclusion-labels = KEY_2 = VALUE_2 , KEY_3 = VALUE_3 \] [ --priority = PRIORITY ]
Replace the following:
-
POLICY_NAME: a name for the VM extension policy.The command fails if a policy with the specified name already exists in the zone.
-
ZONE: the zone where you want to apply this policy. -
DESCRIPTION: an optional description for the policy. -
CONFIG_FILE_PATH: the local path to the JSON file that contains the configuration for the Agent for SAP.- Alternatively, to provide configuration as an inline string, use the
--configflag instead of--config-from-file. For example,--config=google-cloud-sap-extension=" CONFIG ". - You can use either
--config-from-fileor--config, but not both in the same command. - For information about the configuration parameters supported by the agent, see Configuration parameters .
- Alternatively, to provide configuration as an inline string, use the
-
KEY_1 = VALUE_1: a comma-separated list of key-value pairs that define the labels using which the policy targets VMs.- For a VM to be targeted by your policy, the VM must have all the specified labels.
- If you specify
--inclusion-labelsmultiple times, then the policy targets VMs that match any of the provided selectors (logicalOR). If you omit this flag, then the policy targets all VMs in the specified zone.
-
PRIORITY: an integer from0to65535that defines the policy's priority. Lower numbers indicate higher priority. The default value is1000.
Example:
The following command creates a policy named test-sap-agent-policy
in the
Google Cloud project named test-project
, which installs the latest version of
Google Cloud's Agent for SAP on all VMs deployed in the zone us-centrail-f
.
The configuration specified in the agent-config.json
is applied to the
agent.
gcloud beta compute zone-vm-extension-policies create test-sap-agent-policy \ --project = test-project \ --zone = us-central1-f \ --extensions = google-cloud-sap-extension \ --config-file-path = google-cloud-sap-extension = "/usr/agent-config.json"
Default configuration file
The following snippet is an example of the default configuration of version 3.10 (latest) of Google Cloud's Agent for SAP:
{ "provide_sap_host_agent_metrics" : true , "bare_metal" : , "log_level" : "INFO" , "log_to_cloud" : true , "collection_configuration" : { "collect_workload_validation_metrics" : true , "collect_process_metrics" : false }, "discovery_configuration" : { "enable_discovery" : true , "enable_workload_discovery" : true }, "hana_monitoring_configuration" : { "enabled" : false } }
To view feature-specific example configuration files, see the configuration guide for that feature.
Configuration parameters
The following table describes the configuration parameters of Google Cloud's Agent for SAP that is running on a Compute Engine VM, including the parameters related to the collection of metrics. For information about the configuration parameters related to the Backint feature of the agent, see Configuration parameters .
provide_sap_host_agent_metrics
Boolean
To enable the collection of the metrics required by the
SAP Host Agent, specify true
.
Default is true
.
Don't set provide_sap_host_agent_metrics
to false
unless you are directed by Cloud Customer Care or SAP Support.
bare_metal
Boolean
When the agent is installed on a Bare Metal Solution server, specify true
. Default is false
.
log_level
String
To set the logging level of the agent, set the required value. The available log levels are as follows:
-
DEBUG -
INFO -
WARNING -
ERROR
Default is INFO
. Don't change the logging level unless you
are directed by Cloud Customer Care.
log_to_cloud
Boolean
To redirect the agent's logs to Cloud Logging
, specify true
. The default is true
.
cloud_properties.project_id
String
If your SAP system is running on a Bare Metal Solution server, then
specify the project ID of the Google Cloud project that you are
using with Bare Metal Solution.
When the agent runs on a Compute Engine instance, by default,
the agent detects the project ID automatically.
cloud_properties.instance_name
String
If your SAP system is running on a Compute Engine instance, then specify the name that compute instance. The agent automatically detects the compute instance name upon installation.
If your SAP system is running on a Bare Metal Solution server, then specify the name of that server.
cloud_properties.region
String
If your SAP system is running on a Bare Metal Solution server,
then specify the region
of the Bare Metal Solution server.
When the agent runs on a compute instance, by default,
the agent uses the region where the compute instance is deployed.
cloud_properties.zone
String
When the agent runs on a compute instance, by default, the agent uses the zone where the compute instance is deployed.
cloud_properties.image
String
Specify the OS image name of the instance.
When the agent runs on a compute instance, by default, the agent
automatically detects the OS image used by the compute instance.
cloud_properties.numeric_project_id
String
Specify the numeric ID of the Google Cloud project where the SAP system
is running.
When the agent runs on a compute instance, by default, the agent
automatically detects project number.
discovery_configuration.enable_workload_discovery
Boolean
To let the agent collect the names and versions of the SAP products
running on the host, specify true
. The default value is true
.
For more information, see the agent's codebase in the google-cloud-sap-agent
GitHub repository under GoogleCloudPlatform/sapagent
.
discovery_configuration.enable_discovery
Boolean
To send to Cloud Logging the information that the agent collects about
the SAP products running on the host, specify true
. The
default value is true
.
If you specify the value false
, then the agent stores the
collected information on the host and doesn't send it to Cloud Logging.
collection_configuration.collect_process_metrics
Boolean
To enable Process Monitoring metrics collection, specify true
.
Default is false
.
This parameter is applicable only for Linux.
If you enable Process metrics collection for SAP HANA, then you need to
set up additional parameters listed under hana_metrics_config
.
collection_configuration.process_metrics_frequency
Int
From version 2.6, this parameter determines the collection frequency of the fast-changing Process Monitoring metrics
,
in seconds. Fast-changing Process Monitoring metrics are: sap/hana/availability
, sap/hana/ha/availability
, and sap/nw/availability
.
The default value for this parameter is 30
seconds. We recommend that you use this default value.
All other ( slow-changing
) Process Monitoring metrics are collected at a
default frequency of 120 seconds. To change the collection frequency of
the slow-changing Process Monitoring metrics, use the parameter slow_process_metrics_frequency
.
collection_configuration.slow_process_metrics_frequency
Int
Specify the collection frequency of the slow-changing Process Monitoring metrics , in seconds.
The default value for this parameter is 120
seconds.
collection_configuration.process_metrics_to_skip
Array
Specify the Process Monitoring metrics
that you don't want the agent to collect. This parameter accepts a
comma-separated value of Process Monitoring metric names. For example: "process_metrics_to_skip": ["/sap/nw/abap/sessions", "/sap/nw/abap/rfc"]
.
collection_configuration.hana_metrics_config.hana_db_user
String
Specify the database user account that the agent uses to query
SAP HANA. Default is SYSTEM
.
collection_configuration.hana_metrics_config.hana_db_password
String
Specify the plain text password for the database user account that the agent uses to query SAP HANA.
Instead of specifying a plain text password, we recommend that you use one of the following options:
-
hana_db_password_secret_name, for which you specify a secret stored in Secret Manager . -
hdbuserstore_key, for which you specify anhdbuserstorekey .
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the hana_db_password
parameter, which
is preferred over the hana_db_password_secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
collection_configuration.hana_metrics_config.hana_db_password_secret_name
String
To securely provide the password for the database user account that the agent uses to query SAP HANA, specify the name of the secret that contains the security credentials for the database user account.
The agent collects the SAP HANA related metrics only when you specify
either hana_db_password_secret_name
, hdbuserstore_key
,
or hana_db_password
.
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the hana_db_password
parameter, which
is preferred over the hana_db_password_secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
collection_configuration.hana_metrics_config.hdbuserstore_key
String
To securely connect to an SAP HANA system, specify a Secure user store ( hdbuserstore
)
key that you've created for that
system.
To use an hdbuserstore
key for authentication, ensure the following:
- The SAP tools
hdbsqlandhdbuserstoreare installed on the compute instance hosting the agent. - The
hdbuserstorekey corresponds to one specific SAP HANA instance. You can't use keys that contain hostnames of multiple SAP HANA instances. - The
SID admuser can query the SAP HANA database using this key. HereSIDrefers to the value that you've specified for thesidparameter. You can verify this by running the following command as theSID admuser:hdbsql -U HDB_USERSTORE_KEY "SELECT * FROM DUMMY"
This configuration parameter is supported from version 3.3 of the agent.
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the hana_db_password
parameter, which
is preferred over the hana_db_password_secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
collection_configuration.hana_metrics_config.sid
String
Specify the SID of your SAP HANA instance.
If you're using an hdbuserstore
key to authenticate to SAP
HANA, then refer to the hdbuserstore_key
section.
collection_configuration.collect_workload_validation_metrics
Boolean
To enable Workload Manager evaluation metrics collection,
specify true
. From version 3.2, the default value is true
.
This parameter is applicable only for Linux.
collection_configuration.workload_validation_metrics_frequency
Int
The collection frequency of the Workload Manager
evaluation metrics in seconds. The default value is 300
seconds.
If you need to modify the collection frequency of the
Workload Manager metrics, then add the workload_validation_metrics_frequency
parameter under the collection_configuration
section and
provide the required value.
collection_configuration.workload_validation_collection_definition.fetch_latest_config
Boolean
Optional. The default value is true
, which enables the agent
to collect the latest set of Workload Manager evaluation
metrics without requiring you to update the agent. If you want to turn off
this behavior, then specify this parameter in your configuration file and
set its value to false
.
collection_configuration.workload_validation_db_metrics_config.hana_db_user
String
Specify the user account that is used to query the SAP HANA instance. The user account must have the read permission to the SAP HANA database.
collection_configuration.workload_validation_db_metrics_config.hana_db_password
String
Specify the password for the user account that is used to query the SAP HANA instance.
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the hana_db_password
parameter, which
is preferred over the hana_db_password_secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
collection_configuration.workload_validation_db_metrics_config.hana_db_password_secret_name
String
Specify the name of the secret in Secret Manager that stores the user account's password.
Alternatively, you can specify the hdbuserstore_key
configuration parameter to authenticate the specified SAP HANA user.
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the hana_db_password
parameter, which
is preferred over the hana_db_password_secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
collection_configuration.workload_validation_db_metrics_config.hdbuserstore_key
String
To securely connect to an SAP HANA system, specify a Secure user store ( hdbuserstore
)
key that you've created for that
system.
To use an hdbuserstore
key for authentication, ensure the following:
- The SAP tools
hdbsqlandhdbuserstoreare installed on the compute instance hosting the agent. - The
hdbuserstorekey corresponds to one specific SAP HANA instance. You can't use keys that contain hostnames of multiple SAP HANA instances. - The
SID admuser can query the SAP HANA database using this key. HereSIDrefers to the value that you've specified for thesidparameter. You can verify this by running the following command as theSID admuser:hdbsql -U HDB_USERSTORE_KEY "SELECT * FROM DUMMY"
This configuration parameter is supported from version 3.3 of the agent.
If you specify hdbuserstore_key
, then you can skip specifying
the hostname
and port
parameters.
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the hana_db_password
parameter, which
is preferred over the hana_db_password_secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
collection_configuration.workload_validation_db_metrics_config.sid
String
Specify the SID of your SAP HANA instance.
collection_configuration.workload_validation_db_metrics_config.hostname
String
Specify the identifier for the machine, either local or remote, that hosts your SAP HANA instance. The following are the supported values:
- If the host is a local machine, then specify the string
localhostor the localhost loopback IP address, like127.0.0.1. - If the host is a remote machine, then specify its internal or external IP address.
collection_configuration.workload_validation_db_metrics_config.port
String
Specify the port on which your SAP HANA instance accepts queries. For
the first or only tenant database instance, the port is 3 NN
15
, where NN
is the
instance number of the SAP HANA instance.
collection_configuration.workload_validation_db_metrics_frequency
Int
The collection frequency of the SAP HANA database metrics, in seconds,
for Workload Manager evaluation.
Default is 3600
seconds.
Although you can update the collection frequency of the
SAP HANA database metrics, we recommend that you use
the default value. If you need to modify the default value, then add the workload_validation_db_metrics_frequency
parameter under
the collection_configuration
section and provide the required
value. Make sure that you don't set a collection frequency greater
than 3600
seconds.
hana_monitoring_configuration.enabled
Boolean
Optional. To enable Google Cloud's Agent for SAP to collect the SAP HANA
monitoring metrics, specify true
. The default value is false
.
hana_monitoring_configuration.enabled: true
.hana_monitoring_configuration.sample_interval_sec
Int
Optional. Specify the sample interval, in seconds, which determines the frequency at which Google Cloud's Agent for SAP queries your SAP HANA instances to collect the SAP HANA monitoring metrics. The default value is 300 seconds.
For each query defined in the configuration file of
Google Cloud's Agent for SAP, you can overwrite the global sample interval
by specifying the required interval to the parameter sample_interval_sec
. Sample intervals must be 5 seconds or
longer.
hana_monitoring_configuration.query_timeout_sec
Int
Optional. Specify the timeout for each query made to the SAP HANA instances. The default value is 300 seconds.
hana_monitoring_configuration.execution_threads
Int
Optional. Specify the number of threads used to send queries to the SAP HANA instances. Each query runs on its own thread. The default value is 10.
hana_monitoring_configuration.send_query_response_time
Boolean
Optional. Specify true
to have the agent capture the
response time for every SAP HANA monitoring query defined in the agent's
configuration file.
hana_monitoring_configuration.hana_instances.name
String
Specify the name identifier for your SAP HANA instance.
hana_monitoring_configuration.hana_instances.sid
String
Specify the SID of your SAP HANA instance. This string is added as a label to all the metrics resulting from querying your SAP HANA instances.
hana_monitoring_configuration.hana_instances.host
String
Specify the identifier for the machine, either local or remote, that hosts your SAP HANA instance. The following are the supported values:
- If the host is a local machine, then specify the string
localhostor the localhost loopback IP address, like127.0.0.1. - If the host is a remote machine, then specify its internal or external IP address.
hana_monitoring_configuration.hana_instances.port
String
Specify the port on which your SAP HANA instance accepts queries. For
the first or only tenant database instance, the port is 3 NN
15
, where NN
is the
instance number of the SAP HANA instance.
hana_monitoring_configuration.hana_instances.user
String
Specify the user account that is used to query the SAP HANA instance.
Make sure that this user has the privilege to read the monitoring views in your SAP HANA database. If this privilege is not granted, then the SAP HANA monitoring metrics related to the monitoring views contain no data.
hana_monitoring_configuration.hana_instances.password
String
Optional. Specify the password, as plain text, that authenticates the user account for querying the SAP HANA instance.
For authentication, you must specify one of the following:
- The plain text password to the parameter
password. - (Recommended) If you use Secret Manager
to store the password as a secret, then you must specify the
corresponding secret name to the parameter
secret_name. - (Recommended) An
hdbuserstorekey to the parameterhdbuserstore_key.
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the password
parameter, which
is preferred over the secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
hana_monitoring_configuration.hana_instances.secret_name
String
Optional. Specify the name of the secret in Secret Manager that stores the user account's password.
For SAP HANA authentication, the agent uses the following order of
preference: if specified, the hdbuserstore_key
configuration
parameter is preferred over the password
parameter, which
is preferred over the secret_name
parameter. We
recommend that you set only one authentication option in your configuration
file.
hana_monitoring_configuration.hana_instances.hdbuserstore_key
String
To securely connect to an SAP HANA system, specify a Secure user store ( hdbuserstore
)
key that you've created for that
system.
To use an hdbuserstore
key for authentication, ensure the following:
- The SAP tools
hdbsqlandhdbuserstoreare installed on the compute instance hosting the agent. - The
hdbuserstorekey corresponds to one specific SAP HANA instance. You can't use keys that contain hostnames of multiple SAP HANA instances. - The
SID admuser can query the SAP HANA database using this key. HereSIDrefers to the value that you've specified for thesidparameter. You can verify this by running the following command as theSID admuser:hdbsql -U HDB_USERSTORE_KEY "SELECT * FROM DUMMY"
This configuration parameter is supported from version 3.3 of the agent.
If you specify hdbuserstore_key
, then you can skip
specifying the host
and port
parameters.
hana_monitoring_configuration.hana_instances.is_local
Boolean
For monitoring HA systems, specify true
to tell the agent
that the defined SAP HANA instance is hosted on the same
Compute Engine instance as the agent. This then
makes the agent check at runtime if the defined SAP HANA instance is the
primary or the secondary node in that HA system. This awareness is required
by the agent to run the SAP HANA monitoring queries on the SAP HANA instance
type that you specify for the queries.run_on
parameter.
The default value for this parameter is false
, which makes
the agent run all the enabled SAP HANA monitoring queries on the
corresponding SAP HANA instance. For more information, see Monitoring
for multi-tenant and HA systems
.
This parameter is supported from version 3.7 of the agent.
hana_monitoring_configuration.hana_instances.instance_num
String
Specify the instance number that you've set for your SAP HANA instance. This information is required for the agent to discover your SAP HANA instance.
This parameter is supported from version 3.7 of the agent.
hana_monitoring_configuration.hana_instances.queries_to_run.run_all
Boolean
Optional. Specify true
to run all the SAP HANA monitoring
queries, default and custom, that are enabled in the agent's configuration
file on the specified SAP HANA instance. The default value is false
.
hana_monitoring_configuration.hana_instances.queries_to_run.query_name
String
Optional. Specify the queries that you want to run on the specified SAP HANA instance.
If you're running a multi-tenant SAP HANA database, then you can set up
tenant specific monitoring by using this configuration parameter. In the
following example configuration, two queries are run on HANA_TENANT_1
and all queries defined in the
configuration are run on HANA_TENANT_2
:
"hana_instances": [ { "name": " HANA_TENANT_1 , "queries_to_run": { "query_name": [" QUERY_NAME_1 ", " QUERY_NAME_2 "] } }, { "name": " HANA_TENANT_2 , "queries_to_run": { "run_all": true } } ... ]
hana_monitoring_configuration.hana_instances.enable_ssl
Boolean
Optional. Specifies whether or not SSL is enabled in your SAP HANA
instance. The default value is false
.
hana_monitoring_configuration.hana_instances.host_name_in_certificate
String
If you specify enable_ssl: true
for an SAP HANA
instance, then you must specify the hostname that is set in the SSL
certificate.
hana_monitoring_configuration.hana_instances.tls_root_ca_file
String
If you specify enable_ssl: true
for an SAP HANA
instance, then you must specify the path for your security
certificate.
hana_monitoring_configuration.queries.enabled
Boolean
Optional. To enable a SQL query for all your SAP HANA instances,
specify the value true
for the parameter enabled
for that SQL query.
hana_monitoring_configuration.queries.name
String
If you have defined custom queries in your configuration file, then you must specify a unique name for each custom query.
The query name must be unique because it is used to build the metric's default URL in Monitoring.
hana_monitoring_configuration.queries.run_on
String
Optional. Specify this parameter if you're monitoring an SAP HANA HA
system and want to run the SAP HANA monitoring queries on either the
primary or the secondary node. Supported values: PRIMARY
, SECONDARY
, ALL
. When you specify the value ALL
, the agent runs the SAP HANA monitoring queries on both
the primary and secondary nodes in your HA cluster.
This parameter is supported from version 3.7 of the agent. Also, to run the queries on the secondary node, make sure that your HA system is deployed with the Active/Active (Read Enabled) configuration.
hana_monitoring_configuration.queries.sql
String
Specify the SQL statement that the agent issues to your SAP HANA instances.
The SQL statement must conform to the SQL syntax defined by SAP in SAP HANA SQL and System Views Reference .hana_monitoring_configuration.queries.sample_interval_sec
Int
Optional. Specify the sample interval for the SQL query. This overrides the global sample interval. The value must be 5 seconds or longer.
hana_monitoring_configuration.queries.columns.name
String
Specify a name that uniquely identifies each column.
The column name must be unique because it is used to build the metric's default URL in Monitoring.
hana_monitoring_configuration.queries.columns.metric_type
String
For handling by Monitoring, specify one of the following
metric types: METRIC_LABEL
, METRIC_GAUGE
, or METRIC_CUMULATIVE
.
Metrics of type METRIC_LABEL
are appended as labels to
all the METRIC_GAUGE
and METRIC_CUMULATIVE
metrics that are sent to Monitoring.
hana_monitoring_configuration.queries.columns.value_type
String
For handling by Monitoring, specify a data type that is supported by the metric type.
The supported data types are as follows: VALUE_BOOL
, VALUE_INT64
, VALUE_STRING
, or VALUE_DOUBLE
. For more information, see Supported combination
.
hana_monitoring_configuration.queries.columns.name_override
String
Optional. For handling by Monitoring, specify the path that you want to show in the metric URL instead of the query and column names. For example:
- Metric's default URL:
workload.googleapis.com/sap/hanamonitoring/ QUERY_NAME / COLUMN_NAME - Metric URL using custom path:
workload.googleapis.com/sap/hanamonitoring/ CUSTOM_PATH
Modify agent configuration on a fleet of VMs
To modify the configuration of Agent for SAP instances that you've installed on your VM fleet by using a VM Extension Manager policy, you must edit that policy.
To modify agent configuration on your VM fleet, complete the following steps:
Console
-
In the Google Cloud console, go to the VM extension policiespage.
-
Click the policy that you want to modify.
-
In the Extension policy detailspage, click Edit.
-
In the Manage extensionssection, toggle Google Cloud's Extension for SAP.
-
In the Configuration file contentfield, enter the configuration that you want to apply to the agent.
For information about the configuration parameters supported by the agent, see Configuration parameters
-
Click Done.
-
Click Save.
gcloud
To modify the configuration of Agent for SAP on your VM fleet, run
the gcloud beta compute zone-vm-extension-policies update
command. When you update a policy by using gcloud, the request
acts as a complete replacement. Any optional fields you omit revert to their
default values instead of retaining existing values from the modified policy.
To modify the agent configuration:
gcloud
beta
compute
zone-vm-extension-policies
update
POLICY_NAME
\
--zone =
ZONE
\
--extensions =
google-cloud-sap-extension
\
--config-file-path =
google-cloud-sap-extension =
" CONFIG_FILE_PATH
"
\
[
--inclusion-labels =
KEY_1
=
VALUE_1
\]
[
--inclusion-labels =
KEY_2
=
VALUE_2
, KEY_3
=
VALUE_3
\]
[
--priority =
PRIORITY_NUMBER
\]
[
--description =
" DESCRIPTION
"
]
Replace the following:
-
POLICY_NAME: the name of the VM extension policy that you want to modify. -
ZONE: the Google Cloud zone where the policy applies. -
CONFIG_FILE_PATH: the local path to the JSON file that contains the configuration for the Agent for SAP.- You can also provide the agent configuration as an inline string by
using the
--configflag instead of--config-from-file. For example,--config=google-cloud-sap-extension=" CONFIG ". Google Cloud recommends that you use--config-from-file. - You can use either
--config-from-fileor--config, but not both in the same command. - For information about the configuration parameters supported by the agent, see Configuration parameters
- You can also provide the agent configuration as an inline string by
using the
-
KEY_1 = VALUE_1: a comma-separated list of key-value pairs that define the labels using which the policy targets VMs.- For a VM to be targeted by your policy, the VM must have all the specified labels.
- If you specify
--inclusion-labelsmultiple times, then the policy targets VMs that match any of the provided selectors (logicalOR). If you omit this flag, then the policy targets all VMs in the specified zone.
-
PRIORITY_NUMBER: the priority that you want to set for your policy. You can specify an integer from0to65535. -
DESCRIPTION: a description of the VM extension policy.
Uninstall agent from a VM fleet
To uninstall Google Cloud's Agent for SAP from your VM fleet, you must delete the VM Extension Manager policy that manages the VM fleet.
While deleting a policy, if another active, lower-priority policy applies to a VM and declares the Agent for SAP, then the agent remains installed on that VM based on the lower-priority policy.
VM Extension Manager removes the agent from all accessible VMs within one minute of policy deletion. If a VM is inaccessible because the guest agent is removed or the VM is deleted, then VM Extension Manager skips deletion of the Agent for SAP. If such a VM becomes available again, then VM Extension Manager removes the Agent for SAP at that time.
To uninstall Agent for SAP from your VM fleet, complete the following steps:
Console
-
In the Google Cloud console, go to the VM extension policiespage.
-
Click the policy that manages the Agent for SAP on your VM fleet.
-
In the Extension policy detailspage, click Deleteand confirm the deletion.
gcloud
gcloud beta compute zone-vm-extension-policies delete POLICY_NAME \ --project = PROJECT_ID \ --zone = ZONE
Replace the following:
-
POLICY_NAME: the name of the VM extension policy that you want to delete. -
PROJECT_ID: the ID of the Google Cloud project where the policy is located. -
ZONE: the Google Cloud zone where the policy is located.
Troubleshooting
For information about diagnosing and resolving issues that you might encounter when you install and configure Google Cloud's Agent for SAP, see Google Cloud's Agent for SAP troubleshooting guide .
Get support
If you need help resolving problems with Google Cloud's Agent for SAP, then collect all available diagnostic information and contact Cloud Customer Care. For information about contacting Customer Care, see Getting support for SAP on Google Cloud .

