Solved

How to identify the Host in an SQL process

Posted on 2010-08-19
3
410 Views
Last Modified: 2012-05-10
Hi
SQL server 2000. In enterprize manager I can see a process, the host name for this is not a machine in my network. I cant ping to this name. Not sure if this is a machine outside the network but connected through VPN, or this is some automated job. I have stopped all the scheduled jobs on server still the process is appearing. Even if the process is killed, it starts again in few minutes. Is there anyway to identify the source of this process? I have the host name - this is the name of a PC used long time back in our network but the PC doesnt exist in the network anymore. Network library is shown as LPC. Any ideas?

Thanks,
0
Comment
Question by:bijualex
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 33482527
LPC means it's using the (local) shared memory, so it's a process on the box itself.
0
 

Author Comment

by:bijualex
ID: 33490669
Hi angelIII

Thanks for this information. Is there anyway to identify the actual application which triggers this process? I have disabled all sql server scheduled jobs, I have nothing in windows scheduled tasks. No user defined services also enabled. Any other place to check?

Thanks
0
 

Assisted Solution

by:shrimantpatel
shrimantpatel earned 250 total points
ID: 33494156
It can very well be a service that would be constantly retrieving data from the SQL server, Try looking for the same process id in the regular windows task manager and the Event logs too
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now