I've had some issues in the past with the "Dynamically Determine Port" option on ODBC Drivers slowing down connections. The solution for me was to uncheck the box, and hard-code 1433 or whatever port into that area.
I'm looking to see if anyone knows of a whitepaper, or how this functionality works under the hood, so that I can prove or disprove that this option is still necessary for performance gains.
Thanks,
JB Trexler
check out sql browser in bookonline.
MDAC, SNAC and sqlclient driver cache the resolved connection string, so the perform hit normally only happens on first connection, or if you have large pool of servers where the cache lookup take long.
No comments:
Post a Comment