Microsoft SQL Server (MS SQL) is one of the most deployed databases in the enterprise world. It is not surprising that many of our vRealize customers request top-of-the-line monitoring for this database. Using the management pack for Microsoft SQL Server, the VMware administrator can quickly identify whether any performance degradation is a result of poor database performance or whether the root cause is actually the underlying virtual infrastructure. The management pack has hundreds of in-depth performance and capacity metrics that allow the VMware administrator and the DBA to quickly identify the root cause of any performance issue.
First, let's take a look at performance. At Blue Medora, we provide in-depth dashboards that give the administrator the information they need to solve any problem. These dashboards may seem complicated; however, they are actually very simple and easy to use. While looking at performance, let's take a look at two specific dashboards: