Windows SQL server about ice HOT 12 CLOSED

@ma78 do you know what this os is mapped to in your billing file? Can you grep for "RunInstances" in your billing file. Once we know the mapping in billing file, we can add it to Ice.

from ice.

Windows SQL Server Std

Thanks

from ice.

@ma78 I checked in the code to call describeReservedInstancesOfferings to get ri prices for all os. Can you pull the latest code and try again? You will need to clean your working bucket before you retry. Also make sure Ice has permission to call describeReservedInstancesOfferings in ec2.

from ice.

Fantastic that has done the trick! What a great tool this is shaping up to be.

from ice.

fangji.. i have found another issue.

on an account I have:

1. 10 x m1.medium RIs purchased in say us-west-2a for Linux/Unix (not VPC)
2. the account is running 10 x m1.medium VPC instances in us-west-2a (not EC2)
3. the account is not running 10 x m1.medium Linux/Unix EC2 instances
4. ice does not show any Unused RIs in us-west-2a
5. ice shows 10 x used m1.medium RIs in us-west-2a

perhaps you need to double the list of OSs to have classic and vpc?

ie.
VPC = Linux/UNIX (Amazon VPC)
EC2 = Linux/UNIX

these two are different and shouldn't overlap.

from ice.

@ma78 Ice needs to differentiate the regular RI and VPC RI usages in billing file. Can you please find the VPC RI line items in your billing file and post it here? You can do the following to find the line items:
First unzip the billing file, then run "grep m1.medium | grep us-west-2a"

from ice.

@fangji in the billing file there is no differentiation between EC2 and VPC instances :(

could ice perhaps use the ItemDescription and look for $0 instances? eg:

$0 per Linux/UNIX Standard Medium Instance (m1.medium) instance-hour

Note: the problem only occurs when an account has instances in both EC2 and VPC. If I have an account with all instances in VPC (nothing in EC2) and although the operating system says "Linux/UNIX (Amazon VPC)" all the graphs are correct because all of the instances are of the same type (VPC).

from ice.

@fangji ignore me. if you buy RIs in EC2 they can still be applied to VPC instances.just learnt that :)

the other one to look for are RDS RIs. i'll post the name of those shortly.

from ice.

@fangji the operating system is just "RDS" and the instance types can be found here:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html

thank you!

from ice.

also, is there any way to handle an account that has various combinations of light, medium, heavy and 1yr, 3yr RIs?

from ice.

@ma78 Ice needs to recognize the line items for those RDS instance usages in billing file. Can you please post some sample line items for those usages?

from ice.

I don't have any of those sorry!

from ice.