I see lots of queries with the following query:
delete from dbo.ConnectionState where ExpirationDate < GETUTCDATE() or CreationDate < dateadd(day, -30, GETUTCDATE())
(@RepositoryID nvarchar(36))select ConnectionID, UserID, State, ExpirationDate, MachineName from dbo.ConnectionState where RepositoryID = @RepositoryID order by ID
Is there anyway to make sure the clients don't fetch this table and clear it out all the time.
Hello Oscar,
You can disable the connection state under Administration > System Settings - uncheck "Allow entry states (lock, running, checkout)".
Best regards,
Richard Boisvert
Thank you.
I have unchecked and will check the SQL logs.