vROPS 6.1 – How to Monitor SQL Databases using EPOPs
In my earlier post I have written how to monitor Window Services and Processes. Monitoring SQL Databases are just as important in my opinion. This guide covers where to download the SQL plugin, how to install the plugin, how to monitor SQL database, and then how to add it to a dashboard.
How to Install SQL End-Point Plugins
In this example we will install a SQL Plugin to allow us to monitor SQL. The SQL server must have the EP Ops Agent installed.
Download the EPO Adapter for SQL Server on Solution Exchange here
Click on Administration à Solutions à
- Click on Browse
Browse for the EPOP Plugin and click on Open
Check both check boxes and then click on Upload
Wait till it is fully uploaded and click on Next
Accept the License agreement and click on Next
Wait till the installation is complete and then click on Finish
Go to Content à Plug-ins and verify that the plugin is installed and Online
How to Monitor SQL Databases
In this example we will monitor the SQL Database for availability.
Click on Environment à All Objects
- Expand MSSQL and MSSQL Database, make sure you see SQL Instances and SQL Databases
The bottom example shows how to monitor a single database using a Scoreboard widget
- The scoreboard should look like below
thank you for your post.
i am seeking for help, i am looking to monitor Veeam Backup & Replication results with vROps
i have found this url : https://neonmirrors.net/post/2017-09/monitoring-veeam-with-vrops/
so far i am stuck at finding a plugin for vROps that can monitor the SQL database
i found this post that also requires an SQL plugin however i am getting 404 when i try to fetch it. is there anyway you could help out here ?
thanks again for all the good stuff you have been doing.
checking if you have an answer for my last message?
You can monitor SQL using vROPS agent. If you are using vROPS 8.4 and above you will need to install and configure a Cloud Proxy appliance. Then use it to push out agents to your SQL server to get SQL metrics. https://www.brockpeterson.com/post/application-monitoring-with-vmware-vrealize-operations
Many thanks. will try it out
looking forward for your new post.