Share
Report
282I have been profiling sql server because a customer is having lockup issues. I noticed the strangest thing. Before the lockups, I notice a blocked query in sql. Many times it is a select from the dynamics ecconect error description table as head blocker, with the next query being blocked is a DDL create of a stored procedure. I thought when GP was set up, all the procedures in the Dynamics database were created, and when a company is created, all the procedures were created. But it seems like something is recreating these procedures over and over.
Does any of this ring a bell relating to a problem you've experienced? Are those stored procedures supposed to be created over and over?
I have been working with GP a long time and never seen this before.
Thanks,
Scott Emick
*This post is locked for comments
All responses (
Answers (
