When I check the activity monitor on the SQL server, under processes, all the hostnames are resolved to the connecting server's hostname. I'm interested to know if the SQL server is resolving the IP address of each connecting server to its hostname, since that could be causing a delay in processing the response.
Is this what is happening, or is the connecting server providing its hostname in the request?
If the server is in fact resolving IP addresses to hostnames, how can I disable this behavior?
Thanks