Maybe I should go check what they’re doing… That looks like something I would write, wait as second… What makes this report ‘enhanced’ is that it has a context menu available that allows me to start a trace, or execute a ‘kill.’ Inactive? Someone is just begging to be ‘let go.’
There is a report version of this under the Database Administration and Sessions category. How can you see what the hold-up is?Īnd more importantly, how can we figure out who or what is causing the delay so we can go KILL them (their session, cough!) Tools -> Monitor Sessions You are being BLOCKED because what you want is LOCKED. Sometimes you’re left there waiting because a resource you’re attempting to access is already being used by someone else. Getting the Windows ‘busy’ hourglass cursor is sure to raise anyone’s blood pressure.
0 kommentar(er)
