Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Profile clientid Expand / Collapse
Author
Message
Posted Thursday, April 16, 2009 9:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
How can I find out what is clientprocessid = 44. Thank you
Post #698614
Posted Thursday, April 16, 2009 12:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 10:43 AM
Points: 16, Visits: 172
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.
Post #698764
Posted Thursday, April 16, 2009 12:39 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
Can you explain how I can get to it?Thank you
Post #698770
Posted Thursday, April 16, 2009 1:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 10:43 AM
Points: 16, Visits: 172
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

Post #698830
Posted Friday, April 17, 2009 11:32 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:55 AM
Points: 774, Visits: 1,195
A lot of filters you see online will
1. ignore DBID <= 4 (exclude system databases)
2. ignore SPID < 50 (exclude system processes)

for example
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

I wouldn't worry too much about it


SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
Post #699655
Posted Monday, April 20, 2009 9:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
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?
Post #700694
Posted Monday, April 20, 2009 9:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
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
Post #700704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse