ACECORP
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER