Solved

How to identify the Host in an SQL process

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 61
MS SQL Merging data from table into another table 1 33
SQL view 2 27
sqlserver get datetime field and create a string 5 18
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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 …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

770 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