Browse through the questions and answers listed below or filter and sort to narrow down your results.
Calculating NetAmortisedCost via Cost and Usage Report
**Issue:** Unable to calculate netamortisedcost from Cost and Usage Report (CUR) data But AWS Cost Explorer still shows it. **Usecase:** we ingest Cost and Usage Reports (CSV files) internally into our BI system for cost management and also do few other things on top of it. We know that there are some columns in CUR which only comes when there is any savings plan or RIs applied for the corresponding aws account(s). If there are no savings plan / RIs applied, then AWS Cost explorer also should not show the netamortised cost calculation. Since it does, we want to understand how we can do the same using the data in cost and usage report. We use below SQL query to generate the netamortised cost. This has been working fine for us for some months. But for some other months this returns 0 netamortisedcost while AWS Cost explorer shows this metric. This query is for netamortisedcost calculation but is ported from wellarchitectedlabs.com for amortised cost calculation. ``` CASE WHEN (lineitemtype = 'SavingsPlanNegation') THEN 0 WHEN (lineitemtype = 'SavingsPlanUpfrontFee') THEN 0 WHEN (lineitemtype = 'SavingsPlanCoveredUsage') THEN NetSavingsPlanEffectiveCost WHEN (lineitemtype = 'SavingsPlanRecurringFee') THEN (TotalCommitmentToDate - UsedCommitment) WHEN (lineitemtype = 'DiscountedUsage') THEN NetEffectiveCost WHEN (lineitemtype = 'RIFee') THEN (NetUnusedAmortizedUpfrontFeeForBillingPeriod + NetUnusedRecurringFee) WHEN ((lineitemtype = 'Fee') AND (ReservationARN <> '')) THEN 0 ELSE NetUnblendedCost END netAmortisedCost ``` How AWS Cost Explorer is showing this cost metric even when there is no SP/RIs applied.
How to reduce Data Transfer Cost in AWS
Hello Everyone, Our AWS data transfer cost suddenly increases. I check my current billing and found Bandwidth consumption is too high due to that this cost was increased Is there any way, we can optimize this cost? ![current bandwidth utilization ](/media/postImages/original/IMIgxZhaTITGONtoxjdGfHUg)
documentation for deleting failed multipart uploads
I have a question. I've found articles about implementing lifecycle rules for failed multipart uploads and they always seem to suggest to put 7 days in for the lifecycle rules. Why wouldn't they put 1 day? Why would we need to pay for this storage that we can't access and won't use for more time than the minimum? Could someone at AWS please update the articles about this to use one day instead? Here are some of the articles I've seen about this: https://aws.amazon.com/blogs/aws/s3-lifecycle-management-update-support-for-multipart-uploads-and-delete-markers/ https://aws.amazon.com/blogs/aws-cloud-financial-management/discovering-and-deleting-incomplete-multipart-uploads-to-lower-amazon-s3-costs/
How to see the Egress Cost
Hi, My company is migrating to AWS from On-perm. I'm doing a POC to see what will be my egress cost when all the accounts move from On-perm to AWS. I have created the existing data model in AWS Redshift and accessing the data through Azure Power BI. I want to see cost while using the import model vs direct query. I have couple of reports in Power BI service pointing to AWS Redshift tables. I couldn't get any decent information from AWS team about how much data is being transferred from AWS to Public internet. I tried cost explorer, Bill sections and didn't find any useful information. I really appreciate if someone can show me where i can get either data transfer or egress information Thanks, Miky
How to create Chargeback on Multi-Tenant environment?
Hi team. How are you doing? Hope fine. I would like to share some situation that I'm exposed and till now i could no find any way to do it property by AWS tools. When we have an environment that i need to chargeback the cost internally to different business unit, its clear. But when we have a huge environment with a ton of different resources (kinesis, S3 bucket, Glue, Redshift, Containers, etc) accessed, used and shared by different tenant, there's a problem. I need to chargeback each tenant for each resourced used by them and each resource have a different way to count/measure and till now i just found the AWS Cost Profiler. This AWS Cost Profiler can only record how many time(in hours/mins) the tenant has been useing the resource, but for example, when we talk about database, we need to measure how many MB/GB/TB this specific tenant store. Have you been thought this any time? Do you use any other tool do to it? Thank you!
Cost Explorer widget doesn't show all tags
The cost explorer widget shown in the Systems Manager Application Manager doesn't show all the tags that are associated with the resource group used by my custom application. The tags are already activated in the Cost Allocation Tags panel. The tags associated with my resource group are: `sosafe:environment` and `sosafe:workload`. But cost explorer widget shows only `sosafe:environment`. The following image shows the cost explorer widget indicating just one tag. ![Cost explorer widget screenshot](/media/postImages/original/IMkp1i6OmPSMufMEDXtEmEvQ) The following image shows both the tags activated in the Cost Allocation Tags panel: ![Enter image description here](/media/postImages/original/IM4EeqY9vuSyaUWK5oaYq4_Q) The following image shows the tags associated to my resource group used as custom application in Applications Manager: ![Enter image description here](/media/postImages/original/IMln02DRu0QmWTxOWP_pP_2Q) Why the cost explorer doesn't show all activated tags?
AWS Cost Explorer Tags Not Showing All Values of ec2 instance tags
Cost Explorer is only showing some value of tags, not all, i have added tag key=id and value=instance_id and name tag to every instance and those values of tags are unique for every ec2 instance but in cost explorer some of values are listed not all. I added those tags after allocating in billing console even after 24 hour not all values are shown what am i missing. ![Enter image description here](/media/postImages/original/IM3wrc3yK8QT29r-5gLmj7Zw)
AWS and Multipart uploads to S3 (was being overcharged)
For those of you that use multipart uploads to S3 in AWS, here's an article that you should read. If you use this, then you know that sometimes multipart uploads fail. AWS stores those failed uploads in your S3 bucket and charges you for them every day, unless you have a Lifecyle policy set to to delete them. Here's an article on how to do that. You should also ask for a refund of those charges. https://aws.amazon.com/blogs/aws/s3-lifecycle-management-update-support-for-multipart-uploads-and-delete-markers/ AWS is going to issue a $340 refund for me since I use this quite a bit to back up my PC backups. Thanks AWS. #aws #s3 I've coded an application that uploads and does some other functions to my AWS account using Python and I found out that AWS was charging me for space I didn't know I was using, since it doesn't show up in my bucket.
Fargate cost allocation tags not showing up in cost explorer
I have two issues I'm running into with Fargate billing. 1. I have tagged my cluster, and my task definitions using the Tag Editor. Some of the tags have shown up in the Cost allocation tags view within billing, but some have not. Do I need to wait some time for them to show here to be able to activate them? 2. I've activated the tags that did show up, but when I look in cost explorer, there are no tags available for partitioning my costs. Just now I have tagged my ECS Fargate _service_ using my cloud formation template. This isn't possible through the tag editor, so I thought I'd try this and see if that makes a difference. I am aware I need to wait 24 hours for this to show in cost explorer though. Any ideas on getting these tags to show up in the cost allocation view or cost explorer?
AWS compute savings plan commitment calculation
I am trying to understand how the commitment per hour calculation has been done for AWS Savings plan recommendation for past 30 days. There is no document on how to calculate it, how is the calculation done for leaving the on-demand spend? As per the below usage of the services mentioned in below table, AWS cost explorer is recommending below commitment... "You could save an estimated $315 monthly by purchasing the recommended Compute Savings Plan. Based on your past 30 days of usage, we recommend purchasing 1 Savings Plan with a total commitment of $1.390/hour for a 1-year term. With this commitment, we project that you could save an average of $0.43/hour - representing a 17% savings compared to On-Demand. To account for variable usage patterns, this recommendation maximizes your savings by leaving an average $0.65/hour of On-Demand spend. Recommendations require up to 24 hours to update after a purchase." So we came to a conclusion that we should spend 0.65/hour of On-demand and 1.390/hour of commitment? Please suggest and share how we can calculate all this information if I need to do that with a different set of data. | Service| Intance family| instance type| No. of instances| Region | On-demand Spend ($) | On-demand Usage | On-demand rate | SP rate | SP Spend | % discount | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | EC2 | t2| micro | 1 | US East (N. Virginia) | 8.352| 720| 0.0116 | 0.0078 | 5.616 | 33% | | EC2 | t2| nano | 1 | EU (Ireland) | 4.536 | 720 | 0.0063 | 0.0048 | 3.456 | 24% | | EC2 | t2 | micro | 6 | EU (Ireland) | 53.837658 | 4,272.83 | 0.0126000000 | 0.0095 | 40.591885 | 25% | | EC2 | t2 | large | 1 | EU (Ireland) | 72.576 | 720 | 0.1008 | 0.0761 | 54.792 | 25% | | EC2 | c6a | large | 1 | EU (Ireland) | 38.4495552| 468.44 | 0.08208 | 0.05854 | 27.4224776 | 29% | | EC2 | c4 | 4xlarge | 1 | EU (Ireland) | 421.73| 466 | 0.905 | 0.667 | 310.822 | 26% | | Fargate | | GB-Hours | | EU (Ireland) | 224.9872755| 50615.81 | 0.0044450000 | 0.0034671 | 175.4900749 | 22% | | Fargate | | vCPU-Hours | | EU (Ireland) | 916.9323152 | 22651.49 | 0.0404800000 | 0.0315744 | 715.2072059 | 22% | | Lambda | | EU-Lambda-GB-Second (Second) | | EU (Ireland) | 28.250059 | 1695000.15 | 0.0000166667 | 0.0000138 | 23.39100207 | 17% | | Lambda | | EU-Request (Requests) | | EU (Ireland) | 0.94 | 4688540 | .20 | .20 | 0.94 | 0% | | **Total **| | | | | 1770.590863 | | 1.363321667 | 1.0587953 | 1357.728645 | |