March 5, 2015 at 7:06 pm
Hi Everyone.
New to the DBA world here. And i have been given the task of researching what the organisation has and how it is connected as far as MS SQL databases are concerned. I have found out what we have which is multiple servers (varied OS's) running different versions of SQL server. About 60 of them. What i am now struggling with is how they are connected together.
Example. We have server1 which is the DB server. I know that it has GUI interface for users which runs on a web server. I also know it has two reports servers which also run on seperate servers.
How do i find out or is there a tool or a script or a program which i can use run on server1 which will tell me what is reliant/connected to it?
I know there are many varying types of the examble above across my organisation.
And no it wasnt documented back at the start or the doco is now so old and out of date it is useless.
Thanks guys
Aaron
March 6, 2015 at 3:03 am
you can run "sp_who2" or "select * from sys.dm_exec_sessions" when connected to the server. This will show you the active connections. Column "hostname" shows the originating machinename.
The rows with SPID < 51 are system processes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply