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

  • The "SC_TICKET" records corresponding to expired sessions are automatically deleted by Sitecore.Tasks.CleanupAuthenticationTicketsAgent from the Properties table of a database. However, if the agent fails to clean them up, the expired records remain in the Properties table. Large numbers of "SC_TICKET" records can lead to performance degradation of the login process.

    • 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 the Properties table of a database, proceed as follows:
        1. Open showconfig.aspx and double-check the required database by searching for "PropertyStoreProvider", for example:
          <PropertyStoreProvider role:require="ContentManagement or ContentDelivery">
            <patch:attribute name="defaultStore">web</patch:attribute>
          </PropertyStoreProvider>
          By default, it is the Web database for scaled instance, and the Core database for a Standalone instance.
        2. Use a query similar to the following, which removes all authentication tickets (a side effect is that all the active sessions also become expired after this):
          USE {your_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 - 9.3 Initial Release

CMS 10.0 Initial Release

August 16, 2019
November 03, 2020

Reference number:

223702, 320452