Good morning,
I would need to put under application monitoring DBs installed on VM linux or Windows.
Understand then whether the DB has locked tables or locked users or other issues.
Do you know if there is a script that allows me to do so by vROps?
Thanks.
First, this really isn't a vRealize Automation issue and belongs in the vROps forum. Secondly, there's not going to be any good solution for you without using a combination of the EpOps agents in-guest, or the management packs from Blue Medora. If you have an Advanced license, you can use the Endpoint Operations agents. By default, recent versions of vROps have the SQL plug-in embedded for the EpOps agents, so when you deploy to a system with MSSQL the agent can, after configuration, collect on certain metrics. But to do what you want in the best way really requires an Enterprise license, and Blue Medora pack for SQL is really excellent although not free.
Blue Medora offers vRealize Operations Management Packs for a wide array of databases including Microsoft SQL and Oracle Database.
You can find more details on the vROps Management Pack for Oracle Database here.
You can find more details on the vROps Management Pack for Microsoft SQL Server here.
Including those two databases, Blue Medora's vROps Management Packs provide deep visibility, often down to the SQL query level (were applicable), for the following database types:
SQL Databases
Oracle Database
Microsoft SQL Server
IBM DB2
MySQL
PostgreSQL
NoSQL Databases
MongoDB
SAP HANA
Cloud Databases
Amazon DynamoDB
Amazon Aurora DB
Amazon RDS - Oracle DB
Amazon RDS - Microsoft SQL
Amazon RDS - MariaDB
Amazon RDS - PostgreSQL
Amazon RDS - MySQL
Big Data
Cassandra
Hadoop
These Management Packs can be licensed directly from VMware.
Yes, I confirm, but to monitor the DB on the application side I need a version of Enterprise vROps while mine is advanced and the plugins are paid. I'm trying to figure out whether the application side monitoring can be either half script or stored procedure.
Is there someone that can halp me?
Thanks?
First, this really isn't a vRealize Automation issue and belongs in the vROps forum. Secondly, there's not going to be any good solution for you without using a combination of the EpOps agents in-guest, or the management packs from Blue Medora. If you have an Advanced license, you can use the Endpoint Operations agents. By default, recent versions of vROps have the SQL plug-in embedded for the EpOps agents, so when you deploy to a system with MSSQL the agent can, after configuration, collect on certain metrics. But to do what you want in the best way really requires an Enterprise license, and Blue Medora pack for SQL is really excellent although not free.