Has anyone noticed significant performance issues with the response times from the SQL Probe since the latest upgrade of .net?
We applied the latest micrsoft patches to the PRTG server and noticed significant changes in both the SQL Probe Execution time and the Query Execution time. Gong from an average of 30ms to over 140ms. This happened to both SQL servers we were monitoring and there is no change in tcp/tcp reponse times. Only common thread appears to be the upgrade of .net
Article Comments
I believe the version running before was KB5016592
The current version with the degraded performance for .net execution time appears to be the lastest .net cumulative update KB5017500 and KB5017858 which i believe is .net 4.8.9037.0
Oct, 2022 - Permalink
Ali,
Would you be in a position to rollback the .NET upgrade, and see if that restores the sensor functionality?
Benjamin Day
[Paessler Support]
Oct, 2022 - Permalink
I tried to find any instructions on how to rollback the .net and wasn't able to find anything to do that. I looked for uninstall options for the windows update and it wasn't available either. If you are able to provide instructions, I would be happy to try it.
The client is running on windows 10 pro 21H2
Oct, 2022 - Permalink
Ali,
I would start by uninstalling the existing .NET updates, until you get to 3.5. I think that one is required by Windows in order to function. From there, you can install .NET 4.7.2 which is the version that PRTG needs to have installed.
Benjamin Day
[Paessler Support]
Oct, 2022 - Permalink
Windows 10 and later do not allow for uninstall of the latest .net librarries. If you have manual procedures on how to do this, it would be appreciated.
Oct, 2022 - Permalink
Ali,
I would try using this tool, .NET Uninstall Tool.
Let me know if this works.
Benjamin Day
[Paessler Support]
Oct, 2022 - Permalink
The tool you are recommending does not work on the .net version that ships or is installed with he OS.
"On Windows, the tool can only uninstall SDKs and runtimes that were installed using one of the following installers:
The .NET SDK and runtime installer. The Visual Studio installer in versions earlier than Visual Studio 2019 version 16.3."
If PRTG is that .net specific should it come with its own .net redistributable package and point to it instead of the default os installation. Right now the SQL probe is of little value until this is fixed. Not sure how many other people are using this sensor if I am the only one reporting it.
Oct, 2022 - Permalink
Ali,
I'm at a loss as to how why you cannot downgrade the .NET Framework here. While I understand that tool wouldn't work with the framework the OS shipped with, you've upgraded it numerous times. I was thinking the tool would roll back the upgrades. For PRTG 4.7.2 is the minimum required at this time. To my knowledge no one else has reported this.
Benjamin Day
[Paessler Support]
Oct, 2022 - Permalink
Giving up on this for now, someone at Paessler needs to test the MS SQL server monitoring agent using the latest version of .net and update this sensor to work correctly.
Nov, 2022 - Permalink
Ali,
I'll check with my devs to see if this has been tested. If it has not, I'll ask that it be looked into.
Benjamin Day
[Paessler Support]
Nov, 2022 - Permalink
Hello,
Can you verify for me which version of .NET you were running, and which version you upgraded to?
Benjamin Day
[Paessler Support]
Oct, 2022 - Permalink