September 9, 2011 at 1:01 am
Hi All,
We have a hospital automation. There are many blocks in a day in our system. Anybody can not using the system when blocks occur. I use Activity Monitor to see where problem is. I see many blocks and I follow the blocks but no host name, no Application name. I see details and get query but this query doesn't exists in content of our app. How can I find the application that belong to this query. Is there any alternative of Activity monitor. Please help..
September 9, 2011 at 2:11 am
Yes, you could setup a SQL Profiler trace, or just have a look with sp_who2 (or the excellent 3rd party sp_whoisactive) while the blocking is occurring, however, if you can see it as a process in Activity Monitor, you should at least be able to see the hostname and loginname.
If it doesn't have an application name, then it's neither coming from the SQL Agent or a connected session with SSMS, so it's a case of tracking down based on the hostname, login and what it's doing.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply