Microsoft SQL Deep Dive with SelectStar

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.

Figure 1: You can filter the SelectStar home page using the search box. Here, only Microsoft SQL Server instances are shown.

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.

Figure 2: The top section of a Microsoft SQL Server Instance page.

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).

Figure 3: The Analysis section for a sample Microsoft SQL Server.

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.

Figure 4: The Microsoft SQL Server Queries page, filtered to a single query and 3 days of history.

Using the breadcrumb links in the header, you can easily navigate back to the Microsoft SQL Server resource.

Advanced

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.

Figure 5: The Advanced section of a Microsoft SQL Server.

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.

Figure 6: The “Activity” page for Microsoft SQL Server. Clicking any of the metrics in this page will give you more information about the individual metric.

Relationships

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.

SelectStar Screenshot
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!

Figure 8: A sample Microsoft SQL Server database resource page.

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.

LET'S GET STARTED!

Try SelectStar for 14 days. No credit card required.

TRY IT NOW!