In Part 1 of this blog, I discussed how you can monitor vCenter’s vPostgres database remotely using Blue Medora’s Management Pack for PostgreSQL. For those of you with larger environments with Oracle or MS SQL databases supporting vCenter, you’ll want to monitor those as well.
In this blog, I’ll step through how one can monitor a Microsoft SQL server remotely using vRealize Operations Manager. Similar steps can be taken to monitor an Oracle database remotely with Blue Medora’s Management Pack for Oracle. This includes setting up the requisite credentials on the SQL server, creating relationships to vCenter, and a custom dashboard that shows SQL performance for vCenter.
First, create a monitoring user on the Microsoft SQL database following the security standards and best practices in place at your company. At minimum, this user will require “VIEW SERVER STATE” and “VIEW ANY DEFINITION” on the SQL Server, and the “db_datareader” role on the vCenter database, which is “VCDB” by default.
Next, install the vROps Management Pack for Microsoft SQL Server, which will allow for remote monitoring of the SQL database. Follow the instructions found in the Installation and Configuration Guide, and configure it to collect data from the vCenter Microsoft SQL Server. This adapter will remotely collect data from your SQL Server and apply vRealize Operations’ predictive analytics, dynamic thresholding, reporting, dashboarding, and capacity planning for your vCenter database.
We’ll want to create a relationship between the vCenter Server and the Microsoft SQL database in vROps so that we can easily create some dashboards and navigate between the resources.
Figure 1 – Creating Relationship to vCenter Server
Next, we’ll import a dashboard which allows you to select your vCenter Server and see the Microsoft SQL Server supporting it, along with some capacity and health data. From here, you can customize the dashboard to add other metrics or use it to create your own custom dashboard to monitor your vCenter SQL database.
To import the custom dashboard:
Figure 2 – vCenter Microsoft SQL Dashboard
Now we have a custom dashboard which will show SQL health relative to our vCenter server. Since we created the relationship between our vCenter and SQL server, we’ll also be able to see when SQL performance is affecting vCenter health. With vRealize Operations’ capacity planning capabilities, we’ll also be able to determine if our vCenter SQL database has sufficient memory, CPU, and disk allocated to it.
This blog post was originally posted on VMware Cloud Management Blog. Read the full post here.