SQL Server Performance Monitor
No proactive alerts about bottlenecks related to CPU, memory, paging, disk performance, or virtual machine resource contention.
Performance issues related to database status and capacity, active user connections, and SQL Server errors.
The application is slow and the software vendor tells you to add more memory. You think it might be the code, but can't prove it.
A comprehensive view of server and database performance management
-
Maintain resource capacity and server health
Monitor capacity constraints, the database, and the performance and health of the server hardware.
-
Identify blocked SQL queries
Drill down to blocked SQL Server queries to discover why the database server blocked them.
-
Get notified when DB or log file size cause issues
Monitor the overall size of all data and log files, and be prepared when storage capacity runs out.
-
Learn how other infrastructure affects SQL Server
View every aspect of your IT infrastructure and see which components affect database performance.
Maintain resource capacity and server health
Maintain resource capacity and server health
When a performance issue occurs, you are proactively alerted about capacity constraints with SQL Server, from overall CPU and memory usage for the physical server and virtual machine to database and volume usage.
To help maintain SQL Server health, you should monitor server health and performance. In addition to alerts for server hardware failures, you can set alerts from baseline data on CPU, memory, and other SQL server performance monitoring metrics.
Learn More Read the BlogIdentify blocked SQL queries
Identify blocked SQL queries
One bad query from an application using the SQL database affects the performance of the whole database server itself—not just the individual database belonging to that application. Monitoring for long average lock wait times and expensive queries alerts you to possible issues before the SQL Server itself is brought down by a single query.
Monitoring expensive queries lets you see poorly written queries, queries that take too long to respond, queries affected by CPU time, efficient queries that are delayed by slower queries, etc
Learn More Read MoreGet notified when DB or log file size cause issues
Get notified when DB or log file size cause issues
Databases grow bigger and bigger every day. Log files increase their size all the time because every transaction in the database is logged there. This is useful during recovery in the event of data loss, but it could be a real bottleneck for your database performance. To help you avoid fragmentation or running out of free space, get all the details about your storage capacity and how SQL databases consume it. Learn MoreLearn how other resources affect SQL Server
Learn how other resources affect SQL Server
The application stack management dashboard gives you a view of your environment’s overall performance. This view shows how infrastructure performance affects the application, allowing you to instantly pinpoint the root cause of an issue. For example, if the SQL Server is having a problem, such as high average read latency, it could be due to a storage performance issue. The dashboard view quickly guides you to the related LUN to determine the performance impact on the SQL Server. Learn More Watch the VideoMonitor and manage SQL Server performance and more
Server & Application Monitor
-
One dashboard to view all important SQL Server performance metrics
-
Automatic discovery and agentless monitoring of SQL servers and databases
-
Asset inventory, hardware, operating system, virtualization, application, and SQL Server monitoring from one tool
We're Geekbuilt™.
Developed by network and systems engineers who know what it takes to manage today's dynamic IT environments, SolarWinds has a deep connection to the IT community.
The result? IT management products that are effective, accessible, and easy to use.
