ASPStateTempApplications and ASPStateTempSessions tables are in the TempDB database and are created when you configure SQL Server to Store ASP.NET Session State by running the InstallSqlState.sql script.
ASPStateTempApplications and ASPStateTempSessions Tables are located under tempdb (under System Databases)
SqlSessionStateStore scopes data by application, so that multiple applications can store sessions in one session state database. To that end, the session state database contains an ASPStateTempApplications table that records application names and application IDs. Application names are not explicitly specified as they are for other providers; instead, SqlSessionStateStore uses the website’s IIS metabase path as the application name. Application IDs are hashes generated from application names by the stored procedure GetHashCode
SqlSessionStateStore stores session data in the ASPStateTempSessions table of the session state database. Each record in ASPStateTempSessions holds the serialized session state for one session, and the auxiliary data that accompanies that session.
You should get more information from Session State Providers
I use those tables in order to verify whether ASP.NET sessions are stored in SQL Server session state database.
SELECT * FROM [tempdb].dbo.ASPStateTempApplications SELECT * FROM [tempdb].dbo.ASPStateTempSessions