If you have updated to GP 10.0 SP 5 or GP 2010 SP1 you might already notice the slow performance during login, this is mainly related to the newly added “Dynamics Online Services” dictionary that adds records in the menu table with removing old ones as detailed in this article for David Musgrave and this article for Vaidy Mohan , the temporary solution for this is deleting the records in the menu table that's related to this dictionary. To avoid the manual deletion of the records in this table, you will need to create an SQL job that automatically deletes unwanted records from this table, follow steps below to start: 1. Open SQL Server, navigate to SQL Server Agent > > Jobs, right click and select “New Job”: 2
Continue reading →