Monitoring heterogeneous database environments, including Microsoft SQL Server, typically requires multiple tools for complete coverage. With SelectStar, however, you can monitor Microsoft SQL Server and your other database environments in one place! Read on to learn more about Microsoft SQL Server monitoring.
Health, Compliance, & Configuration
When you first log in to SelectStar you will see all of you monitored databases, from Microsoft SQL Server to Oracle Database to MariaDB. You can filter this list to just Microsoft SQL Server using the search box.
Clicking on any of the Microsoft SQL Servers listed will bring you to the database home page. SQL Server Health, Compliance, Configuration, Alerts, and Recommendations are the first things you’ll notice at the top of the page and right sidebar. The Health section is tied to the number and severity of Alerts that are present, while the Compliance section is tied to active Recommendations. Health and Alerts are performance-focused indicators, while Compliance and Recommendations tend to relate to configuration properties.
Finally, the Configuration Details section provides information about setup, versioning, underlying infrastructure, and collector status of the Microsoft SQL Server.
Deep Dive with Analysis
After the top section is the Analysis section. Key metrics for Microsoft SQL Server monitoring are displayed here such as Wait Time, Query Execution Time, Session, and Disk Capacity. Additionally, infrastructure-specific metrics will display below the SQL Server Disks (if connected to SelectStar).
Each of the metrics can be clicked to get more detail and control over the chart. For example, clicking on the Queries metric will bring you to a page that displays the queries being executed on the Microsoft SQL Server with the ability to change time ranges and filter to specific queries. Metrics like execution time and execution count are also available in the Queries page, which aid in identifying poorly performing queries. See Figure 4 below for an example of drilling down to a single query and identifying its performance over time, average execution time, execution count, and more.
Using the breadcrumb links in the header, you can easily navigate back to the Microsoft SQL Server resource.
The next section, labeled Advanced, displays all the metric categories that are collected for Microsoft SQL Server. These include Activity, Cache, Memory, and Version information.
Each of these metric categories can be clicked to display all the metrics available within the metric category. For example, clicking on the “Activity” section will bring you to a page with the following metrics: Batch Requests, Batch Request Rate, Forced Parameterizations, Forced Parameterizations Rate, Runnable Tasks Count, SQL Compilations, and more. Once again, each of these metrics can be clicked to get even more information and control over the charting period.
The final section in the Microsoft SQL Server page is Relationships, where all related targets are displayed hierarchically. This includes infrastructure resources, as well as any other targets specific to Microsoft SQL Server such as disks and databases.
Figure 7: The Relationships section for a sample Microsoft SQL Server. Resources include infrastructure targets (vcsa-test/w12r2…), disks (C:\), and databases (master, model, msdb, tempdb, tpcc).
Clicking on any of these targets will bring you to the selected resource page. For example, clicking on a database will show you information specific that database. This includes Health, Compliance, Configuration, Alerts, Recommendations, Advanced metric categories section, and a relationship section where you can dig down to the file level!
There are a lot of other features available within SelectStar that let you customize your Microsoft SQL Server monitoring such as custom Alerts and Recommendations.
To learn more about SelectStar or request a free trial, visit selectstar.io.