Skip to product information
1 of 1
One-Stop Shop

One-Stop Shop

Quality Solutions

Quality Solutions

Dedicated Support

Dedicated Support

Fast Shipping

Fast Shipping

SOLARWINDS

Upgrade SolarWinds Database Performance Analyzer per SQL Server, MySQL, Oracle SE, or PostgreSQL instance (30 to 49 instances) to Database Insights for SQL Server (30 to 49 instances) - License Upgrade

Upgrade SolarWinds Database Performance Analyzer per SQL Server, MySQL, Oracle SE, or PostgreSQL instance (30 to 49 instances) to Database Insights for SQL Server (30 to 49 instances) - License Upgrade

SKU: SKU:71340

Regular price $1,302.08 USD
Regular price Sale price $1,302.08 USD
Sale Sold out
Taxes included. Shipping calculated at checkout.
View full details

Database engines like SQL Server or Azure SQL Database are very heavily instrumented pieces of software. SQL Server tracks a multitude of internal and operating system metrics, down to the level of tracking which each thread is waiting on and aggregating the data. Starting in recent versions of SQL Server, query execution and performance are tracked in stored in a feature called the Query Store. Many advanced DBAs have a toolkit of scripts they use to help them glean insights from the large amounts of performance data in SQL Server, however, newer or accidental DBAs may need some help making heads or tails of this data. In this post, you’ll learn about a methodology for troubleshooting performance on a server, and where and what to look for.

    Features:

    Speaking more broadly in terms of database performance, there are several metrics you should capture both within and outside of the database. When you break down the metrics of resource utilization, you see a few different areas:
    •  CPU utilization (server)
    •  Memory utilization
    •  Disk utilization and latency
    • Networking
    • Blocking/locking activity (database)

    Datasheet: