April 16, 2009 at 9:58 am
How can I find out what is clientprocessid = 44. Thank you
April 16, 2009 at 12:33 pm
I believe it's the windows processid at the host. Sysinternals has a process viewer where you should be able pinpoint exactly what PID that is.
April 16, 2009 at 12:39 pm
Can you explain how I can get to it?Thank you
April 16, 2009 at 1:28 pm
In your profile trace you should have a hostname column. If not, you will need to add it and rerun your trace. Once you determine the host, you will need to get on that machine.
There are a suite of process tools here to help you....(some of which will work remotely.)
http://technet.microsoft.com/en-us/sysinternals/cb56073f-62a3-4ed8-9dd6-40c84cb9e2f5.aspx
April 17, 2009 at 11:32 am
A lot of filters you see online will
1. ignore DBID <= 4 (exclude system databases)
2. ignore SPID 50
AND @@spid
ORDER BY spid DESC
[/code]
I wouldn't worry too much about it
April 20, 2009 at 9:01 am
I have a light profiler running and all results go to the master db saved to the table. Is it safe to keep results at master db? also if the server goes down is the option to set up automatically? If I close profile is it still running?
April 20, 2009 at 9:12 am
This code is not working:AND @@spid(error on this), but that is ok I understand.Thank you
SELECT spid
FROM Master.dbo.sysprocesses
WHERE DBID NOT IN (1,2,3,4) -- Master, Tempdb, Model, MSDB
AND spid > 50
AND @@spid
ORDER BY spid DESC
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply