AWS Trusted Advisor optimization checks for Microsoft SQL Server on Amazon EC2

Question

Dear team.

I would like to understand how AWS Trusted Advisor optimization checks for Microsoft SQL Server on Amazon EC2 are collected from my EC2 instances.

As far as I understand Trusted Advisor is a agentless offering and I am not sure how it is possible to collect these metrics from my arbitrary SQL Server deployment on EC2.

Should I install an agent for this or it is done automatically by some routine on EC2 instance itself?

Thank you in advance.

Answer

You don't need to install an agent for Trusted Advisor SQL Server optimization checks. Trusted Advisor inspects your EC2 SQL Server license include instances configurations such as vCPUs/version/edition and then gives recommendations based on the best practice, the same way as other checks. Learn more from [technical documentation](https://docs.aws.amazon.com/awssupport/latest/user/trusted-advisor-check-reference.html).

Answer

This is about License Included license, defined on AMI level. So, when AWS provide the AMI with SQL Server for you, AWS knows every different type of AMI with different of SQL Server versions to distribute. And you can validate this checking Usage Operation code.

Look into this AWS Docs:

AMI billing information fields: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/billing-info-fields.html

Look into this AWS Docs:

**AMI billing information fields**:
https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/billing-info-fields.html

AWS Trusted Advisor optimization checks for Microsoft SQL Server on Amazon EC2

Relevant content