While disabling LLMNR can speed up your SQL connection sometimes, ironically you may be slowed down by MS14-066 (KB2992611).
See this article –
“Microsoft does it again, botches KB 2992611 SChannel patch” – Infoworld
What do you do? The article above gives some advice and more advice comes from the link at the bottom of this blog posting.
Here’s a couple of fixes if you installed KB2992611 and your SQL server came to a crawl
Possible fixes if you’re already affected:
Go to computer configuration > administrative templates > Network > SSL Configuration Settings > SSL Cipher Suite Order
Set it to enabled
Reboot or gpupdate /refresh at an elevated command prompt
The policy populates the Windows registry with the legacy cipher suites less the 4 new cipher suites added by MS14-066 /2992611.
Source/Credit : http://blogs.msmvps.com/spywaresucks/2014/11/16/hold-off-installing-ms14-066-kb-2992611/
Note: ALWAYS backup your data before your try reversing a patch or modifying policies…
View original post 16 more words