Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem matching SQL Instance to PID

Status
Not open for further replies.

gdblack

Technical User
Aug 18, 2003
4
AU
Hi all,

We have 3 instance running on 1 of our servers. We are having an issue with one of our SQL Server instances hogging most of the available CPU. I have looked in current activity / process info on all instances and cannot see anything that is doing a lot of work.
Does anybody know if there is any way of matching the PID ( from task manager) to a specific instance ??

Thanks,
Blackie
 
Problem solved

SELECT ServerProperty('ProcessID')
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top