I'm encountering a slowdown when retrieving results from a stored procedure using SQLExpress hosted on AWS RDS. I'm using a db.t3.medium instance with 2 vCPUs, 4 GB of RAM, 3000 Provisioned IOPS, and a storage throughput of 125 MiBps. The SSMS Activity Monitor shows ASYNC_NETWORK_IO and it takes over 12 seconds to load results into my app or the SSMS results grid. I estimate the dataset size is about 2.5MB. When I run the stored procedure with sqlcmd, it takes around 13 seconds to display all results, but the STATISTICS TIME shows CPU time at 47 ms and elapsed time at 45 ms, indicating that the query execution itself isn't the issue. Given that the baseline network bandwidth for the t3.medium instance is supposed to be 256Mbps, which seems adequate, I'm looking for guidance on what metrics to check or settings to adjust to resolve this issue.
2 Answers
It sounds like your stored procedure runs quickly, which is a good sign. The bottleneck you're experiencing is likely in the network delivery. Have you looked into your security group settings or network ACLs that might be impacting data transfer? Also, try measuring latency with tools to pinpoint the issue more precisely.
You're probably dealing with the limitations of burstable instances. Those can have performance issues when they exceed their baseline capacity. Instead, consider moving to a more robust instance type if you need consistent performance. You could also check for network throttling or any misconfigurations in your settings for optimal throughput.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically