Is there a quick way to determine which servers are connecting to and interacting with a sql 2005 database?
Posted on 2011-10-28
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.