How can I tell if my Amazon Windows instance was an SQL Server AMI?

Aligma asked:

I want to purchase some reserved instances, because I have several instances already created and running 24 hours a day. When I go to purchase a Windows instance, I can see 3 options,

  • Windows
  • Windows with SQL Server Standard
  • Windows with SQL server Web

I don’t know which of these was used to create the original instance. Is there a way I can find out?

My assumptions: the instance type is is important because as far as I understand, the way to purchase a reserved instance is to first have a running instance, and then purchase a matching reserved instance. The reserved instance is not itself a new machine, but a kind of contract between you and Amazon to pay for an instance for 1 or 3 years, at a discounted rate. The contracted, reserved instance will “offset” one matching running instance where they have the same size and platform. Please feel free to correct me if these assumptions are incorrect.

My answer:


I just look for the AMI ID (it’s in your list of instances) and Google it. It always returns a result in the Amazon marketplace.


View the full question and answer on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.