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
Hello there,
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.
Hello,
checking if you have an answer for my last message?
many thanks
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.