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. Name this Job and click on “Steps”:
3. On steps click on “New”, select your company and paste the following command then click on OK:
DELETE FROM DYNAMICS.dbo.SY07110 WHERE CmdParentDictID = 6499
4. On the new job screen click on schedules and schedule the task to run daily:
5. That’s it, you are ready to go, right click the job and select “Start Job”
Make sure that the job was successfully executed:
Enjoy!
Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com
No comments:
Post a Comment