I have a SQL box that I want to decommission. Before doing so, I want to understand all the applications that may be relying on the machine, rather than just turning it off and hearing people scream.
What is the best way to do this?
I know I can run a SQL trace for a while to get login info etc - is there any other way?
I'd like to know as much about the caller including, IP address or machine name that the request is coming from, the app name, credentials. Mostly I want to somehow know if many apps might be running on a single box calling with similar credentials. I'd also like to be able to know that there are 2+ apps (for example) rather than them just look like one.
If SQL Server itself doesn't give me this, are there other tools at the server level that I can leverage?