Overview

This article explains how one can verify the License utilization of an AAA Server.

Information

The formula to calculate utilization is: 

[(concurrentusers - stalesession) / sessioncapacity] * 100% = utilization

• To get the concurrent users count(concurrentusers) run the following SQL Query on AAA DB:

select count(1) from tblmconcurrentusers;

• To get the stale sessions count(stalesession) run the following SQL Query on AAA DB. Here the customer has configured 72 hours to remove Stale Sessions(Where no INTERIM-UPDATE received from BNG Node:

select count(1) from tblmconcurrentusers where last_updated_time < systimestamp - interval '72' hour;

• When the license breaches the License Capacity only existing Sessions will be allowed. All new sessions will be rejected which can lead to customers complaining that they are unable to browse.
  
  
• In addition, by default, an Auto Session Removal Script is running every day for removing 72 hrs of stale sessions, which means an Interim-Update request is not received from BNG for an active session for more than 72 hours, The script will query for such sessions and cleared from AAA DB. This DB procedure for Auto session closure is already implemented in the system and runs daily and clears the session that has not been updated for 72 hours
  
  
  
• The customer can also choose to reduce the count of concurrent sessions in the system, we can reduce the interval of closing stale sessions (not active sessions) from 72 hrs to 36 hrs in the Auto Session Removal Script. This means if an Interim-Update request is not received from BNG for an active session for more than 36 hours, such a session will be picked and cleared from the AAA DB.
  
  
• If the utilization is nearing 100% it is advisable to plan for a Capacity increase by asking for a new License through a new Support Ticket.