Microsoft SQL slow after updates

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 or the registry.

Microsoft should fix this soon…

Here’s how to improve performance – LLMNR -

http://ttcshelbyville.wordpress.com/2009/11/30/slow-sql-connection-to-windows-7/

Don’t forget to run cleanup on Windows 10 Technical Preview once you upgrade

Make sure that if you download the latest Technical Preview update on the first Windows 10 Technical Preview, run cleanup to get rid of the older installation.
Cleanup

Second Release of Windows 10 Technical Preview Available

The second Windows 10 Technical Preview is available…open the Charms bar by hitting Windows + C on your current preview build . Click on Settings , Change PC Settings, Update and Recovery, Preview Builds and Download Now

One  Twofour

upgradeGet ReadyappyingFew more thingssetting upappsUpdatedSlow

Do NOT install this on a production computer.  As you can see above, we installed this on a VM to test the Technical Preview.   You should always select slow on upgrading your previews.   Windows 10 Technical Preview so far has been excellent!

Don’t forget to clean up!

Make sure that if you download the latest Technical Preview update on the first Windows 10 Technical Preview, run cleanup to get rid of the older installation.
Cleanup

Windows 10 Tech Preview

I’ve been working on computers for a long long time.  It does seem that Microsoft gets it right, wrong and then right when they release operating systems.

When Windows 8 came out, we did find it was a good operating system but hard to navigate.   Users eventually became use to it and they eventually found hidden items..   Consumers of traditional Windows XP and Windows 7 will have no problem navigating Windows 10 if Microsoft keeps this release.  

The download for the preview  of Windows 10 can be found here.  It’s around 4 Gb and goes on smooth.  We’ll find out over the upcoming weeks if users begin having problems and what problems are being reported.  Now before you download it, be sure to read the rules about what to install it on and Microsoft’s recommendations.  It truly is for people who know the following - http://windows.microsoft.com/en-us/windows/preview-faq#faq=tab0

If you are going to participate in the Technical Preview, go over and look in the forum.  Hopefully Microsoft will assign a committee to stay in the forum, listen and communicate to engineers.  The forum is located here:

http://answers.microsoft.com/en-us/windows/forum/windows_tp?auth=1

I do want to note that I am already seeing people loading their computers with this OS.  You have to remember it will be polished up, improved and tweaked over the upcoming months.  Because there are thousands of programs and applications on ever type, model and make of computer with every type of hardware imaginable, there will be tons of updates coming.   There will be errors.   Consumers and technicians will report back and Microsoft will require this feedback.

Can you imagine writing an operating system for almost every piece of hardware on the market with every type of configuration?   With thousands and thousands of applications?

Loading Windows 10 Technical Preview

I of course loaded it in a  virtual computer and later on an older computer.  Both installations went smooth and was fast.  The setup is almost like Windows 8, 8.1 or 8.1 Update.   It really did appear to be smooth and was truly error free.

The setup on VMWare Player was like any other iso installation. (www.vmware.com)

Note:  Don’t download this to a production or home computer just yet, it is being reviewed.  

Upon signing in, the menu was back and enhanced with the Microsoft Store Apps.   The menu is now how it should have been.  Navigation was the same through windows, menus were the same in explorer and there was no more worrying about corners or apps that were running or the mysterious Charms Bar.  

While we will find hidden options and features later, one of the best features is multiple desktops for productive people who like multi-tasking.   I have to note that Linux has had this feature for many years and Microsoft has put this feature in.

Note: There will be those who pick it apart along with those who will find security holes in this operating system.    Of course today with viruses and vulnerabilities found in everything, we have entered a time that the business that patches their system quickly and thoroughly will win over the IT personnel in the world.   Also companies that make the easiest to use interface that works for home users that is affordable and has tons of freeware will also win out the consumer. 

Initial setup of VMware Player with 2GB of RAM, 2 Processors and only 30 GB of HDD space.

1 VMWare 1aVMWare

The initial boot up showed a familiar setup screen along with a minimum number of screens requiring any input.2loading 3main 4 agreement 5 disk space 6 installing 7 restart 8 Settings 9 internet

I did click setup a new account and on the next screen I elected to login locally.  10 account 11 apps

The ever familiar desktop found in Windows 8 loaded after signing in.  What I noticed first was the logo in the lower left corner produced a menu that should have always been there and no charms bar if I moved my mouse to the right side of the screen.12 Desktop 13 Finally a menu

Working with networks and group policies in the enterprise, I tested the network for speed and accuracy and dove into the group policy editor.   The network was very quick and responsive and it appears very little has changed in group policies.

14 Faster Than before  17 Computer info 17 Control Panel 16 Work Folder18 File manager

Searches for files or computers using a UNC path were exceptionally fast.19 unc path

Clicking the task view on the taskbar produced an Add a desktop option for anyone wanting to multitask.20 Task View Add a desktop

Clicking the Task View icon again (below) showed the active desktops.21 Extra Desktop

Opeing Apps on the menu gave an option to close them or minimize them using standard controls (below).  The right side of the App listed more options to control the app.22 App Controls

While I have had this installed for only an hour or so, I’m sure I’ll find some hidden features that will benefit users.  Now if Microsoft will keep the code trim, secure and keep controls where users can easily find them, they’ll have a hit.   There will also be a question if Microsoft will give the OS free to end users who own Windows 8 or 8.1 and if they will listen to end users from this point forward.

Windows 9 to join Linux in Multiple Virtual Desktops?

Moving metro inside of the desktop, getting rid of the Charms Bar and multiple virtual desktops…Will Windows 9 be the OS of choice just like Windows 7 after Vista?

More -

http://www.extremetech.com/tag/windows-9

http://gizmodo.com/this-could-be-a-first-glimpse-of-windows-9-1633405933

http://www.trustedreviews.com/news/windows-9-release-date-beta-preview-start-menu-screenshots

Reset and Fix Windows Updates

The following commands help to reset Windows Update History along with resetting and re-registering components.  Open an elevated command prompt and type (or copy and paste) the following-

(References below –  double check before running)

net stop bits
net stop wuauserv
net stop appidsvc
net stop cryptsvc
rmdir %windir%\softwaredistribution /s /q
Del “%ALLUSERSPROFILE%\Application Data\Microsoft\Network\Downloader\qmgr*.dat”
sc.exe sdset bits D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)(A;;CCLCSWLOCRRC;;;AU)(A;;CCLCSWRPWPDTLOCRRC;;;PU)
sc.exe sdset wuauserv D:(A;;CCLCSWRPWPDTLOCRRC;;;SY)(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)(A;;CCLCSWLOCRRC;;;AU)(A;;CCLCSWRPWPDTLOCRRC;;;PU)
cd /d %windir%\system32
regsvr32 /s wups.dll
regsvr32 /s wups2.dll
regsvr32 /s wucltui.dll
regsvr32.exe /s msxml.dll
regsvr32.exe /s msxml3.dll
regsvr32.exe /s msxml6.dll
regsvr32.exe /s actxprxy.dll
regsvr32.exe /s softpub.dll
regsvr32.exe /s atl.dll
regsvr32.exe /s urlmon.dll
regsvr32.exe /s mshtml.dll
regsvr32.exe /s shdocvw.dll
regsvr32.exe /s browseui.dll
regsvr32.exe /s jscript.dll
regsvr32.exe /s vbscript.dll
regsvr32.exe /s scrrun.dll
regsvr32.exe /s wintrust.dll
regsvr32.exe /s dssenh.dll
regsvr32.exe /s rsaenh.dll
regsvr32.exe /s gpkcsp.dll
regsvr32.exe /s sccbase.dll
regsvr32.exe /s slbcsp.dll
regsvr32.exe /s cryptdlg.dll
regsvr32.exe /s oleaut32.dll
regsvr32.exe /s ole32.dll
regsvr32.exe /s shell32.dll
regsvr32.exe /s initpki.dll
regsvr32.exe /s wuapi.dll
regsvr32.exe /s wuaueng1.dll
regsvr32.exe /s wuweb.dll
regsvr32.exe /s qmgr.dll
regsvr32.exe /s qmgrprxy.dll
regsvr32.exe /s wucltux.dll
regsvr32.exe /s muweb.dll
regsvr32.exe /s wuwebv.dll
regsvr32 /s wudriver.dll
net start bits
net start wuauserv
net start appidsvc
net start cryptsvc
bitsadmin.exe /reset /allusers
ipconfig /flushdns
netsh winsock reset catalog

References:

http://support.microsoft.com/kb/914392
http://support.microsoft.com/kb/299357
http://support.microsoft.com/kb/971058

Wi-fi takes a long time to find network after computer sleeps

After your computer goes to sleep, do you notice it takes a long time to connect to your wireless router?
slow
There can be several reasons for this.

Here are some tips~

  • Power management on the adapter is enabled
    • Disable in the Device Manager
  • Advanced Power Management
    • Disable under Power Options (Advanced)
  • Bluetooth Interference
    • Disable under the advanced tab on the wireless network card properties
  • Outdated Driver
    • Updated the driver from the manufacturer of the wirelesss chip and not from the computer’s support site
  • Disable the Virtual Wi-fi under the device manager if you don’t use Adhoc

Advanced Power options – Set to Max Performance

advanced wifi

Disable Bluetooth settings

 

Bluetooth

Disable Power Management

 

network power device manager

 

Use the following freeware to see if you have channel interference and to analyze the power in each room of your home or business:

Vistumbler
NetSurveyor
Xirrus

 

Ultimately, reset your network by going to a command prompt as an administrator and type the following:

netsh int ip reset reset.log
netsh int ipv6 reset reset.log
netsh winsock reset catalog
nbtstat -r
nbtstat -RR
ipconfig /flushdns

Restart your computer