Monitoring for MS SQL Server databases

Check this against your version

This article was last updated on Aug 22, 2024, before Applicare 10.0 was released (Jun 19, 2026), and has not been re-checked for Applicare 10.0. Confirm the steps in your environment or contact Support.

Access the Applicare controller and navigate to the Server Analyzer menu to view the details.

Dashboard

Database performance metrics help you monitor and improve the performance of your database. They cover the whole server, not just the specific database mentioned in the JDBC URL.

Screenshot 1 — Monitoring for MS SQL Server databases

SQL

SQL Statement Profiling shows how well your database queries are performing. It helps you see which queries are slow and find out what’s causing performance problems. You’ll get details like the number of queries, their average time, and other useful stats.

Screenshot 2 — Monitoring for MS SQL Server databases

Server Info

Screenshot 3 — Monitoring for MS SQL Server databases

Network Topology

Screenshot 4 — Monitoring for MS SQL Server databases

OS

This view offers a quick and easy overview of your physical server's or VM's performance, including details on processes, context switches, CPU usage, memory, and storage performance..

Screenshot 5 — Monitoring for MS SQL Server databases

CPU CORE Analyzer

This view offers a comprehensive overview of the CPU including details information about each individual CPU core.

Screenshot 6 — Monitoring for MS SQL Server databases

Processes

This view offers organized performance stats for the CPU, memory and running processes.

It includes historical snapshots of processes showing resource usage at various points in time. by default, Applicare takes a snapshot every 10 minutes but this interval can be adjusted according to your needs.

Screenshot 7 — Monitoring for MS SQL Server databases

Disk

This view provides the disk usage accessed by each and every process.

Screenshot 8 — Monitoring for MS SQL Server databases

Network Connections

This view provides the TCP, UDP, RAW, and UNIX connection Details.

Screenshot 9 — Monitoring for MS SQL Server databases

SQL Report

The SQL statements can be downloaded as a report by clicking the print icon from the Server Analyzer menu SQL Screen.

Screenshot 10 — Monitoring for MS SQL Server databases

Screenshot 11 — Monitoring for MS SQL Server databases

Screenshot 12 — Monitoring for MS SQL Server databases

MS SQL Server Always On Availability Groups Monitoring

MS SQl Server database configuration

Was this article helpful?

Votes and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.

Opens Zendesk · needs internet and sign-in

Still stuck? Contact support