January 26, 2011 at 1:26 pm
Hi guys,
I could use some assistance...
I was noticing some sluggishness on mt SQL 2k5 server - when I looked at the activity monitor, I noticed an active process (runnable, not a system process) When I opened the provess, here is the result:
create table #tmpDBCCinputbuffer ([Event Type] nvarchar(512), [Parameters] int, [Event Info] nvarchar(512))
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(84)')
select [Event Info] from #tmpDBCCinputbuffer
When i try to kill the process I get a message that I cannot kill my own processes.
I logged into SQL Mgmt Studio as a different user, and when i tried to kill the process I got the same message. The runnable process ID takes on whatever identity I log in as?!?
Also, when I try to kill the process via query analyzer, it just comes right back.
What is this demon???? :crazy:
January 26, 2011 at 2:43 pm
tina_tysinger (1/26/2011)
What is this demon???? :crazy:
It's the query that activity monitor runs to get the current server activity.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply