Experiencing Slowness issue when user logging into Sitecore CM (10.2)

 We are encountering performance issues when user login to the Sitecore CM. It takes several minutes to redirect to the dashboard.

Solution:

Please consider reviewing the 'Properties' table in Core database.

It's possible there is a large amount of "SC_TICKET" records in this table.

These authentication records can be removed from the table, however it will remove any active sessions for user and force them to relogin. Please consider performing this in off hours to avoid disrupting users.

SQL query to find out the SC_TICKET:

Please find the KB article reference link below:

 https://support.sitecore.com/kb?id=kb_article_view&sysparm_article=KB0615926

                                                    Happy learning!