I have a client that is using temporal tables for data auditing and session contexts to secure data from different systems from one another.
To access any data you first have to set the context variable like so.
exec sp_set_session_context @key = 'SystemID', @value='A65T'
13 of the most used tables have temporal versioning so they can audit data.
The server has 2 cores with 8 GB memory.
My issue is that the server is not used very heavily but the CPU and IO are always high. My thought is that it could be from the things I mentioned above but can't find articles to confirm or deny this.
Has anyone used these features and if so, what kind of overhead did it cause?