Author Archives: Luciano Gomes

Monitoring PostgreSQL Server

This blog is contributed by my friend Luciano Gomes, a VMware Technical Account Manager in Rio de Janeiro Area, Brazil. Thank you, Lucky!

vRealize Operations can monitor many databases in the market, including PostgreSQL. If you have the Enterprise license for vR Ops, the Plugin for PostgreSQL is for free. If you would like to monitor Oracle Database or MySQL, please visit BlueMedora for more information.

Pre-requisites:

  1. vR Ops Enterprise Edition
  2. Endpoint Operations Agent
  3. PostgreSQL plugin
  4. PostgreSQL adjustments

Steps:

  1. Download the PostgreSQL plugin, from VMware Marketplace here
  2. Follow the instructions to install this Plugin here
  3. Download the EP Ops agent (must be the same of your vR Ops version) here
  4. Install the EP Ops agent, instructions here
  5. Adjust your PostgreSQL:
    • Edit the file pg_hba.conf and change the line:
      • from: local all all peer to: local all all md5
      • and add something like that: host all all localhost md5
      • Your postgres user, need to have a password: 
        • sudo -u postgres psql postgres \password postgres
      • Ensure that the user has the permission to view tables and statistics objects in the PostgreSQL cluster. For example:
        • GRANT SELECT ON ALL TABLES IN SCHEMA public TO <username>;
  6. Configure PostgreSQL credentials in vR Ops:
    • In the left pane of vRealize Operations
      • Click Administration, then click Inventory Explorer.
      • Select Adapter Instances > EP Ops Adapter Instance.
      • Select the PostgreSQL instance for which you want to collect metrics and click the Edit Object icon. The Edit Object dialog box opens.
      • Click on the Add New plus sign beside Credentials. You will see the Manage Credentials dialog box.
    • Enter the credential details.
      • Credential Name
      • postgresql.user
      • postgresql.pass
  7. Import the Dashboards from here and happy customizing!

Hope you like it!

Monitoring Data Center Power Consumption

This blog is contributed by my friend Luciano Gomes, a VMware Technical Account Manager in Rio de Janeiro Area, Brazil. Thank you, Lucky!

This dashboard helps you measure, understand and predict the power consumption of your Datacenter. vRealize Operations also allows you to measure how much power a particular Virtual Machine is consuming and how much that Virtual Machine will consume in the future. 

You need vR Ops Advanced Edition as the minimum, as custom dashboard is required.

Step 1: enable Power Metrics metric

Choose your active policy, and follow as shown below:

Step 2: Import the dashboard and view

I’ve prepared them here

Voila! That’s it!

Hope you find useful. If you have other requirements for vR Ops dashboards, let me know!

Monitoring Oracle WebLogic Servers

This blog is contributed by my friend Luciano Gomes, a VMware Technical Account Manager in Rio de Janeiro Area, Brazil. Thank you, Lucky!

You can monitor Oracle WebLogic Server using vR Ops. This helps you see the correlation between Application and Infrastructure. I’ve created 3 custom dashboards to jump start your effort.

First of all, the pre-requisites:

  1. vR Ops Enterprise edition.
  2. Weblogic Solution Installed
    1. Download here and see here how to install
    2. We support WebLogic 10.3 and above. These dashboards were made for 10.3. If you have a different version you need to update the metrics files.
  3. EP Ops Agent installed on each WebLogic servers that you want to monitor
    1. See here how to install
  4. Import all Dashboards, Views and re-create all metrics files available.
    1. See here how to import

To import, follow these 3 steps:

  1. Import the dashboards available here
  2. Import the views available here
  3. Recreate the Metrics files, available below (See here how to recreate this metrics files below). The files must have the same name as shown below.

weblogic-admin-server.xml

<?xml version="1.0" encoding="UTF-8"?>
 <AdapterKinds>
 <AdapterKind adapterKindKey="EP Ops Adapter">
 <ResourceKind resourceKindKey="Weblogic Admin 10.3">
 <Metric attrkey="PERFORMANCE|JVMTotalGarbageCollectionTime" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="PERFORMANCE|JVMTotalGarbageCollectionTimeperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|InvalidLoginAttemptsperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|JTAActiveTransactionsperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|JTACommittedTransactionsperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|JMSActiveServers" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|JTASecondsActiveperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|JTASystemTransactionsRolledBackperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|JTATransactionsRolledBackperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|SocketsOpen" label="" unit="" yellow="" orange="" red=""/>
 </ResourceKind>
 </AdapterKind>
 </AdapterKinds>

weblogic-jdbc-connection-pool.xml

<?xml version="1.0" encoding="UTF-8"?>
 <AdapterKinds>
 <AdapterKind adapterKindKey="EP Ops Adapter">
 <ResourceKind resourceKindKey="Weblogic 10.3 JDBC Connection Pool">
 <Metric attrkey="UTILIZATION|ActiveConnections" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|FailurestoReconnectperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|HighActiveConnections" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|LeakedConnectionsperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|MaxConnectionsperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|TotalConnectionsperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="AVAILABILITY|ResourceAvailability" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|ConnectionDelayTime" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|TotalConnections" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|WaitingForConnectionCurrentCount" label="" unit="" yellow="" orange="" red=""/>
 </ResourceKind>
 </AdapterKind>
 </AdapterKinds>

weblogic-jta-resource.xml

<?xml version="1.0" encoding="UTF-8"?>
 <AdapterKinds>
 <AdapterKind adapterKindKey="EP Ops Adapter">
 <ResourceKind resourceKindKey="Weblogic 10.3 JTA Resource">
 <Metric attrkey="AVAILABILITY|ResourceAvailability" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionHeuristicCommitsperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionHeuristicHazardTotalperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionHeuristicMixedTotalperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionHeuristicRollbacksperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionHeuristicsTotalperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionsCommittedperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionsRolledBackperMinute" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionsTotal" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="THROUGHPUT|TransactionHeuristicCommits" label="" unit="" yellow="" orange="" red=""/>
 </ResourceKind>
 </AdapterKind>
 </AdapterKinds>

weblogic-webapp.xml

<?xml version="1.0" encoding="UTF-8"?>
 <AdapterKinds>
 <AdapterKind adapterKindKey="EP Ops Adapter">
 <ResourceKind resourceKindKey="Weblogic 10.3 Webapp">
 <Metric attrkey="AVAILABILITY|ResourceAvailability" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|CurrentActiveSessions" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|SessionsCreated" label="" unit="" yellow="" orange="" red=""/>
 <Metric attrkey="UTILIZATION|SessionsCreatedperMinute" label="" unit="" yellow="" orange="" red=""/>
 </ResourceKind>
 </AdapterKind>
 </AdapterKinds>

Once you got them imported, you’ll get the dashboards below. I’ve added some help on the dashboard image.

Weblogic Components Dashboard:

Weblogic Components Menu

Weblogic Overview

Hope you find it useful. Do reach out via Linkedin and Twitter. Thanks for reading!