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

+1

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

[Authorization].[OAuthSessionState]

+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]

Translate

Sign up