I dont care about ConnectionState

I dont care about ConnectionState

avatar

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.

All Comments (2)

avatar

Hello Oscar,

You can disable the connection state under Administration > System Settings - uncheck "Allow entry states (lock, running, checkout)".

forum image

Best regards,

Richard Boisvert

avatar

Thank you.

I have unchecked and will check the SQL logs.