This post continues the series about from AWS ALB Price Planning w/ IIS : New Connections. Here are a couple things to note about the query to grab Active Connections:
- This query is largely based on the same query used in AWS ALB Price Planning w/ IIS : New Connections [link needed].
- It’s slightly modified by getting the number of connections per minute rather than per second. But, all the same problems that were outlined in the last post are still true.
- AWS does their pricing based on average usage per hour. So, the sql will aggregate the data into hour increments in order to return results.
Active Connections SQL Script
Graphing the output from the script shows:
- # of Active Connections per Minute by Hour (for a month)
- The jump in the average number of new connections in the beginning of the month corresponds to a return of students to campus. During the beginning of the month, school was not in session and then the students returned.
- The dip at the end of the month has to do with a mistake I made loading some data. There is one day of IIS logs that I forgot to import, but I don’t really want to go back and correct the data. It will disappear from the database in about a month.
- # of Active Connections per Second by Hour Frequency
- This doesn’t help visualize it as well as I would have hoped. But, it does demonstrate that usually the number of active connections per minutes will be less than 3000; so it will be less than 1 LCU (1 LCU = 3000 active connections per minute).
0 comments:
Post a Comment