How i clean this table [Authorization].[OAuthSessionState]

  • 9 July 2021
  • 1 reply
  • 1 view

Badge +1

How i clean this table and for what this table need?

[Authorization].[OAuthSessionState]

 


1 reply

Userlevel 2
Badge +10

Hi BohdanMohylnyi,


 


It sounds like the table is getting too large. Out of curiosity, can you run the following SQL query?


 



SELECT count (*) FROM [Authorization].[OAuthSessionState]
WHERE DATEDIFF(s, [CreatedUtc], SYSUTCDATETIME()) > [ExpiresInSeconds]

Reply