Performance on a Windows 2012 Server with SqlDependency.Start() error in Event Viewer
Symptoms
Environment is incredibly slow and is throwing intermittent SQL and Ajax errors. Reports from multiple locations as well as testing performance outside of the office. It takes anywhere from 20 seconds to 1 minute to render a page or even part of the frame.
In the user interface and on the server event viewer the following message is generated:
Error/warning messages
When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.
Reason
Configuration using .NET Framework 4.5 for Windows 2012 OS.
Windows 2012 comes with .NET Framework 4.5 and 4 preinstalled. On the base image when Webserver tries to establish sqldependency connection for some unknown reason it fails and then it keep reinitiating the connection every minute. After doing some research, installation of different components and comparing working and non working environments I found that .NET Framework 4.5.1 update includes update for Framework 4.0 as well and this updated files for Framework 4.0 fixes the SQL Dependency initialization issue
Resolution
Recommendation:
1. If any customer reports this issue again, first verify .NET Framework version
2. Upgrade .NET Framework from 4.5.0 --">" 4.5.1
3. Apply General patch to support IE 11 for framework 4.5.1
4. Monitor this issue.
Additional Notes
Steps to find the .NET Framework versions by viewing the registry (.NET Framework 4.5 and later)
1. On the Start menu, choose Run.
2. In the Open box, enter regedit.exe.
You must have administrative credentials to run regedit.exe.
3. In the Registry Editor, open the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
Note
If the Full subkey is not present, then you do not have a the .NET Framework 4.5 or later installed.