Home icon

Capture and diagnose I/O bottlenecks on Amazon RDS for SQL Server

Database Blog

This article discusses how to capture, diagnose, and resolve I/O bottlenecks on Amazon RDS for SQL Server instances.

Specifically, the article covers:

  • Identifying I/O bottlenecks using Amazon CloudWatch, Enhanced Monitoring, and Performance Insights metrics like disk queue depth, latency, IOPS, and throughput
  • Analyzing I/O bottlenecks by looking at storage configuration (e.g. EBS volume type) and wait types like PAGEIOLATCH_SH
  • Resolving I/O bottlenecks by modifying storage to higher performance type (e.g. gp3), using instances with local NVMe storage for tempdb, and optimizing database design (partitioning, compression, fill factor)
  • Conclusion highlighting the benefits of using AWS services to monitor and optimize performance
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jul 28
2026
Troubleshooting SQL Server query performance on Amazon RDS
Apr 24
2024
Monitor query performance with Performance Insights on Amazon RDS for SQL Server
Feb 11
2026
Essential tools for monitoring and optimizing Amazon RDS for SQL Server
Jun 20
2024
Amazon RDS for SQL Server supports up to 64TiB and 256,000 IOPS with io2 Block Express volumes

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.