February 14, 2024 at 7:38 pm
Hi,
Can someone let me know if we need to setup any additional monitoring on RDS Sql Server Instance. Enhanced monitoring is already enabled on this instance.
Thanks,
February 15, 2024 at 3:54 pm
This is very much an opinion question, so please take this answer as such.
Yeah, you need additional monitoring.
The basics are there, sure. The AWS console will tell you if the server is online or off. It'll tell you CPU & I/O. You'll even get listings of poorly performing queries. What you don't get is two things. First, correlation. Most of the metrics available through the monitoring are there in isolation from the others, so it's hard to say, oh, we've got waits on X, and they are caused by these queries. Or, conversely, these queries are experiencing these waits. Second, drill down. Yeah, there's data, there, but it is largely superficial. More detail is generally needed to troubleshoot the harder problems within SQL Server.
Happily, the tools are the same. You can use DMVs, Extended Events, Query Store, to get information from your databases. You can even plug in 3rd party monitoring tools to get more correlation, support, guidance, and a longer history.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply