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

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.

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

Description

Solution