Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
Reports fail to run intermittently. A resource fails to initialize. There are SQL errors in the logs, and event viewer.
Issue appears to be sql related.
Service was unable to open a new database connection when requested.
SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Connection string - Data Source=EPBYMINSA0080t5\Infrastructure;Initial Catalog=NetPerfMon;Persist Security Info=False;User ID=SolarwindsNPM;Password=*******;Connect Timeout=20;Load Balance Timeout=120;Packet Size=4096;Application Name=w3wp@/LM/W3SVC/2/ROOT-1-131055500019036793;Workstation ID=SolarWinds
There are a number of long running queries in the logs:
C:\Users\SDAsvc\AppData\Local\Temp\DiagnosticsAnalyzer\5d9501bb-eca6-435e-ab1b-4e02b8a27315\Diagnostics\LogFiles\InformationServiceV3\Orion.InformationService.log, Line 23116, Message: '2016-04-24 02:29:30,655  WARN SolarWinds.InformationService.Core.InformationService - (null) Support! -- LONG RUNNING QUERY: Session uuid:1e924326-f641-4606-abc9-ccaef27db18c;id=17 - Query took 19678.7153 ms: SELECT AlertObjectID FROM Orion.AlertObjects ao LEFT JOIN Orion.NPM.Interfaces no ON ao.EntityUri=no.Uri WHERE no.Uri IS NULL AND ao.EntityType = 'Orion.NPM.Interfaces' RETURN XML RAW'
These all point to an SQL performance/connection issue. See the following Microsoft articles for further information:
Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.