Sitecore create a ticket for each user when login onto the CMS. This ticket entry is stored in the Properties table of the Core database.
Login into the CMS may become slow with time and also based on the number of users accessing the CMS. This is because of the large number of ticket records being stored in the Properties table. There is currently an agent which performs the cleanup.
However, the agent is not so efficient. We had this issue on our Content Management Environment whereby the login was taking about more than 5 mins to get into the CMS. For some users, they received a timeout message.
In order to fix this issue, we have raised a Sitecore Support ticket at the Sitecore Portal and they provide us with a patch. The patch number is 435315. This patch contains a config file and an assembly.
The Config File
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/"> <sitecore> <scheduling> <agent type="Sitecore.Tasks.CleanupAuthenticationTicketsAgent"> <patch:attribute name="type">Sitecore.Support.Tasks.CleanupAuthenticationTicketsAgent</patch:attribute> </agent> </scheduling> </sitecore> </configuration>
The config file should be placed in the following path: App_Config\Include
The assembly should be placed in the \bin folder. This was provided by Sitecore and has been tested on the Sitecore 6.x to Sitecore 7.x versions.
Note: If required, you can contact Sitecore by creating a support ticket so that they may provide you a more updated patch or a patch which is specific to your needs.
You may download the files from my GitHub Repository: https://github.com/hishaamn/Sitecore