Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I asked asked this question yesterday but it disappeared :(. Anyway, I have a sql server that I want to decomission and need to figure out who is relying on it. There could be a bunch of tools and users relying on it. Other than a sql trace to track log in information, what is the best way to find out as much as I can about the clients relying on the box? I want to know more than just the sql log in info, I want to know which client machines, the IPs, the credentials and details about the specific different applications. If there is one box with more than one application running (for example), I need to know these are two apps that may be passing the same credentials. Help?

share|improve this question
Duplicate of… – davr Feb 12 '10 at 19:15
show processlist;

will show you who is currently connected and all there connection details but it will only show you the connections at the time you run the command and not a history.

share|improve this answer
and to kill of a process just use kill {Id}; from that query – Urda Feb 12 '10 at 17:49
that's mysql not sql server – Nick Kavadias Feb 13 '10 at 13:52

It didn't get lost, it looks like you're using a different username to post these two questions

Also - since you added a new requirement in this question that wasn't in the first - I don't think you will be able to tell if a single client machine is using two different applications that connect using the same SQL login. You may see multiple connections, but you won't necessarily know if that's from a single application or multiple.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.