Microsoft SQL Server performance

Deeply understand your Microsoft SQL Server performance

Try for free Contact us

Data-driven Microsoft SQL Server performance

A simple Microsoft SQL Server performance tuning can speed your application significantly. Before tuning, however, you need actionable data about your database’s current performance.

Before tuning your MSSQL server make sure you go through the following database performance checklist:

MSSQL metrics overview

Verify your hosts’ health with server data

By checking CPU, memory, and disk space metrics you make sure your Microsoft SQL Server processes have sufficient resources available.

MSSQL CPU metrics MSSQL memory metrics MSSQL disk metrics

Know which commands affect database performance

Knowing which services access your MSSQL server is vital for finding database performance bottlenecks. If there is a single service that’s suffering from bad database response times, dig deeper into that service’s metrics to find out what’s causing the problem.

Take a deeper look into the service’s communication with the database and find out which commands affect the database performance the most.

Services accessing MSSQL MSSQL service backtrace

Verify your app’s database connection

Even if the way you query your database is perfectly fine, you may still experience inferior database performance. Make sure if your application’s database connection is correctly sized.

MSSQL connections

Keep an eye on network metrics

If a database performance issue suddenly appears, process level visibility comes in handy in identifying a failing component.

MSSQL process metrics

Optimize your MSSQL performance with Dynatrace

Dynatrace monitors and analyzes the activity of your Microsoft SQL servers across all platforms, providing visibility down to individual database statements.

Key benefits:

Your first 1,000 hours of MSSQL monitoring are on us

Try for free Contact us