?
Solved

How to identify the Host in an SQL process

Posted on 2010-08-19
3
Medium Priority
?
469 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 1000 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 1000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

594 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