March 10, 2009 at 7:22 am
Recently i observed a weired thing on my activity monitor. there was a spid running under my login but when i cheked on the host server there was nothing running but still i see that in the activity monitor and when tried killing i cudnt do for my own spid then i had to disconnect all conenctions for that database. But after an hour again the same repeated with the same database.
How can i troubleshoot this.
March 10, 2009 at 8:37 am
It would be better if you run profiler against your login and see from where that spid is gettng called up and which process is invoking such request.
MJ
March 10, 2009 at 10:09 am
How are you checking the host server? Activity Monitor just queries the servers for activity. note that this query is "activity" and will show up.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply