Is there a way to acquire metadata about an Amazon RDS database instance using only SQL?
I don't have a SQL Server on AWS to check, but you could see if it's in xp_msver, or figure it out from ProcessorCount, ProcessorType and PhysicalMemory in that sproc.