Solved

How to identify the Host in an SQL process

Posted on 2010-08-19
3
433 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 143

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

830 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