What could be causing slow Dynamics GP Performance?
Have you ever wondered why Microsoft Dynamics GP is taking a long time to log in, or it takes forever for a particular window to come up, or your posting process appears to “hang”?
Well, there is a way that you can potentially find the answer through Microsoft SQL Server.
1. Log into Microsoft SQL Server Management Studio.
2. Select either the Company Database or the Dynamics Database (you may need to check both).
3. Select New Query.
4. Type SP_WHO2 and run the query.
5. Look for anything in the BlkBy column. If you find a row that has something in this column, that is potentially where the problem lies.
6. Note the Number that is in the BlkBy column, and look in the SPID column for that specific number you found in Step 5. For instance, if the BlkBy column only has one row with something in it, and it is the number “20″, find “20″ in the SPID column.
7. Review the row of data that you found in step 6. This is the process that could be causing the problem.
8. For further assistance in resolving these issues contact your Microsoft Dynamics Partner!