• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Is there a quick way to determine which servers are connecting to and interacting with a sql 2005 database?

I have a sql server 2005 enterprise edition x64 cluster that contains numerous virtual instances. each virtual instance contains a sql instance, and the sql instance contains numerous databases.

there is one database that is "unknown" and i was wondering if there is a quick way to determine, by executing something up against the sql server or database itself, which servers are connecting to and accessing this database?

I am not interested in a solution where i need to look at switches, routers, or anything of that nature. i am only interested in uisng a method on the sql server itself, looking at the databse via a query server side mechanism to find out which servers may be connecting to the specific database.

i want to avoid having to run a network monitor and tracing out the tcp/ip packets. i am hoping for a quick and easy solution where i can just run something on the sql server that takes less than 60 seconds.

1 Solution
Paul MacDonaldDirector, Information SystemsCommented:
You can use the Profiler in the SQL Manager to do this.  You'll need to go to the Events Selection tab, check the "Show all columns" checkbox and check the "Hostname" checkboxes.

That said, can you not determine the purpose of the database by looking at its contents?
ACECORPAuthor Commented:
That worked. Problem solved. Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now