0

Below are the two queries and their outputs we ran in core database of our production enviroment and 98% of entries are from sitecore\virtualssuser. I think because of this, Sitecore client login becomes very slow and returning 500 error. When these entries will be created and how to have control on them?

  1. Select count(*) FROM [dbo].[Properties] WHERE [dbo].[Properties].[Key] like '%SC_TICKET%'

Output - 136119

  1. Select count(*) FROM [dbo].[Properties] WHERE [dbo].[Properties].[Key] like '%SC_TICKET%' AND [dbo].[Properties].[Value] like '%sitecore\virtualssuser%';

Output - 134312