Exam AWS Certified Database - Specialty topic 1 question 102 discussion

B is correct Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action. Performance Insights allows non-experts to detect performance problems with an easy-to-understand dashboard that visualizes database load. https://aws.amazon.com/rds/performance-insights/

ＭＡＹＢＥ Ａ

B. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem. "Performance Insights uses lightweight data collection methods that don’t impact the performance of your applications, and makes it easy to see which SQL statements are causing the load, and why. It requires no configuration or maintenance, and is currently available for Amazon Aurora (PostgreSQL- and MySQL-compatible editions), Amazon RDS for PostgreSQL, MySQL, MariaDB, SQL Server and Oracle." "Whether your database performance problem is due to database configuration or application design issues, you can quickly identify the bottleneck and see which SQL statements are contributing to it." https://aws.amazon.com/rds/performance-insights/

Performance Insights to analyze database performance by waits, SQL statements, hosts, or users. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Overview.ActiveSessions.html Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server allows you to monitor the health of the SQL server, general issues not related to a specific query. Metrics that are monitored for the SQL Server instance: - CPUUtilization - SQLServer:Buffer Manager cache hit ratio - SQLServer:Locks Number of Deadlocks/sec - VolumeQueueLength https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/appinsights-what-is.html

I think it can´t be A because it's an in-house web application, saying that going for B

i think it should be A: as an Application, insight can provide more details to SQL server

I think this should be A. The question no where states the slowness is due to query. it states response is slow to certain request for repoting. CloudWatch Application Insights is For common problems in .NET and SQL application stacks, such as application latency, SQL Server failed backups, memory leaks, large HTTP requests, and canceled I/O operations, it provides additional insights that point to a possible root cause and steps for resolution. Built-in integration with AWS SSM OpsCenter allows you to resolve issues by running the relevant Systems Manager Automation document. First we need to understand the reason of slow reponse. It could be application issue rather SQL issue where Performance Insight can be helpful

additional features to improve management reporting capabilities => new queries needing Performance Insights to check

New reports = new queries needing Performance Insights to check

A https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/cloudwatch-application-insights.html " For common problems in .NET and SQL application stacks, such as application latency, SQL Server failed backups, memory leaks, large HTTP requests, and canceled I/O operations, it provides additional insights that point to a possible root cause and steps for resolution"

New functionality added to update reporting capabilities. Reports from application are generated via queries. These queries need to be investigated via answer which is > B

B is the answer

sql server application issue. Does not say ueries. A is the answer.

BBBBBBBBB

B final answer

Option B

B. Answer