Login slowness due to a large number of "SC_TICKET" properties

Expand all | Collapse all

  • Description

    Collapse

    The "SC_TICKET" records corresponding to the expired sessions should be automatically deleted by Sitecore.Tasks.CleanupAuthenticationTicketsAgent from the Properties table of the Core database. However, the agent fails to clean them up, so the expired records remain in the Properties table. Large numbers of the "SC_TICKET" records may lead to performance degradation of the login process.

  • Solution

    Collapse
    • For Sitecore XP 8.2 rev. 171121 (Update-6) and Sitecore XP 8.2 rev. 180406 (Update-7), download and apply the following patch:
      https://sitecore.box.com/s/y03hxa83utsj0jj6espt4ogf4b6gs6ir
      See the readme.html file inside the archive for installation instructions.
    • For Sitecore XP 9.0 rev. 171002 (Initial Release):
      1. Download and apply the following patch:
        https://sitecore.box.com/s/y03hxa83utsj0jj6espt4ogf4b6gs6ir
        See the readme.html file inside the archive for installation instructions.
      2. To clean up Properties table of the Core database, use the following query which will remove all authentication tickets (side effect: all the active sessions will also become expired after this):
        USE {core_database_name};
          DELETE  FROM [dbo].[Properties]
          WHERE [dbo].[Properties].[Key] like '%SC_TICKET%'
    • For Sitecore CMS 9.0 rev. 171219 (Update-1) and Sitecore CMS 9.0 rev. 180604 (Update-2): download and apply the following patch:
      https://sitecore.box.com/s/q9ibufmmpnnph534gml7ii4wxtosuo7c
      See the readme.html file inside the archive for installation instructions.

Applies to:

CMS 8.2 Update-6+

August 16, 2019
January 29, 2020

Reference number:

223702