| Author |
Topic |
|
qwertyjjj
Posting Yak Master
131 Posts |
 Posted - 2008-02-26 : 07:55:06
|
| I have a process on the server that I cannot kill off.Even a restart doesn't get rid of it so any ideas on what this is/caused by?samasterrunnableopen transactions = 2SELECT INTOMSSQLEMwait time 0not waiting |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-26 : 08:05:35
|
| Is it sp_who2 by any chance?run dbcc inputbuffer(spid) to find out. |
 |
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-02-26 : 08:18:42
|
| Language Event 0 set noexec off set parseonly off |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-26 : 08:55:50
|
| It's your own process from EM, close EM and then do an sp_who2 in QA and see if it disappears. |
|
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-02-26 : 08:59:09
|
| Yep, disapperas.What is it then? |
|
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-02-26 : 09:07:13
|
| Sorry, it's still there:56 RUNNABLE sa L20235 . master SELECT INTO 220 43 02/26 14:03:43 SQL Query Analyzer 56 |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-26 : 09:28:48
|
| When you run sp_who2, if that is the only SELECT INTO you see, then it is your own process. If it isn't the only process, do you have AV running on your data directory? If so, then it will be this process. It is not recommended practice as it will slow your SQL queries down and as the .mdf and .ldf files are always open, there is no need for AV to be running. |
|
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-02-26 : 09:30:39
|
| That is the only SELECT INTO but I have no idea what the process could be or where it is running from on my system?What is AV? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-26 : 10:03:47
|
| Anti Virus software. |
|
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-02-26 : 10:47:46
|
| So, no way of knowing what this is then as it is the only process and seems to be coming from my computer? |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-02-28 : 17:11:09
|
quote:
Originally posted by RickD
When you run sp_who2, if that is the only SELECT INTO you see, then it is your own process.
|
|
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-02-28 : 17:42:24
|
but i am not running any select into statements????? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-28 : 17:46:04
|
| Don't worry about it. Its by default. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-28 : 18:23:44
|
quote:
Originally posted by qwertyjjj
but i am not running any select into statements?????
Yes you are, you just don't realize it. You must realize that when you click around in Enterprise Manager that it is running commands. And SELECT INTO is one of them.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-02-29 : 06:44:11
|
| but constantly?even when I close EM it's still there |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-29 : 15:58:29
|
| Then some other connection that you have is running it. Why do you even care to kill it? What problem is it causing? I already know the answer, so this is more of a rhetorical question.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
open transactions 2 select into