Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

This is not your problem.

If you'd like to disable DNS lookups from the SQL server anyway, the quickest way would be to blank out the DNS server entries in your network configuration.

share|improve this answer
    
Well that's the thing...there are no entries in the DNS for these hosts. Somehow, the SQL server is resolving the IP addresses into hostnames all on its own. Unless the hosts are providing their hostname inside their request. Could you please elaborate why this wouldn't cause any delay while it resolves the IP address? –  blizz Jan 9 '13 at 23:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.