Microsoft SQL slow after updates


TCAT Shelbyville - Technical Blog

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:

Open gpedit.msc

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

Thank for your comments

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s