Michael L.
Well Known Member
Hello List. I’m more a ‘400’ competency but now work as an employee in a SQL 2014 environment. We are 9.2, 9.2.1.1, SQL 2014.
Last Friday we had two Production issues.
• Issue # 1 was the TempDB drives ran close to out of capacity very suddenly due to three queries running concurrently each > 5 hours.
• Issue # 2 was we had 30+ wait type LCK_M_U
Keeping in mind we have only ONE proxy user (JDE) and using the examples above, might you share how we can connect the issue(s) from SQL server back to a specific JD Edwards user profile?
Thank in advance for any assistance,
Michael
Last Friday we had two Production issues.
• Issue # 1 was the TempDB drives ran close to out of capacity very suddenly due to three queries running concurrently each > 5 hours.
• Issue # 2 was we had 30+ wait type LCK_M_U
Keeping in mind we have only ONE proxy user (JDE) and using the examples above, might you share how we can connect the issue(s) from SQL server back to a specific JD Edwards user profile?
Thank in advance for any assistance,
Michael