AnsweredAssumed Answered

Transition State Slowness

Question asked by Nicole Phillips on Nov 7, 2011
Latest reply on Nov 7, 2011 by Nicole Phillips

We are currently running ePDM 2010 SP4 and the last couple weeks we have had huge slowness with transitioning states in our workflow.  Before the slowness on a busy time it may take at the most 30 seconds to transition a file, but now it's taking up to a minute and a half sometimes longer.  It doesn't seem to be related to a file type, it's the same for SW file or office files.  I think we have it pin pointed to our SQL database.  We share our database server with about 30 other SQL databases, we hit a cluster which points to a server.  We did failover to another server last week and that seemed to fix the problem for a couple days, but now we are back to slowness.  I am hoping by putting a discussion I could get some input on what to check to what could be making the file transitions go so slow.  And if anyone else has had this kind of issues and fixes they have used.  Thanks!!