Our SQL server is being battering by queries the are running frequently. They seem to be running one by one and just pull back that latest NCM backup for the node whose IP address is in the query.
Does anyone know what SolarWinds process would be doing this 24x7? No NCM jobs are currently running. We've rebooted all the SolarWinds pollers in case some NCM related was a bit stuck.
Below is an example of the query. All the queries are identical to this one, but with a different IP address each time.
SET DATEFIRST 7; SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
SELECT
--TOP (1)
[T1].[ID] AS C1,
[T1].[UserName] AS C2,
[T1].[ModuleName] AS C3,
[T1].[Type] AS C4,
[T1].[Action] AS C5,
[T1].[Details] AS C6,
[T1].[DateTime] AS C7,
[T1].[ApprovedBy] AS C8,
[T1].[RequestID] AS C9,
[T1].[RequestLink] AS C10 FROM dbo.NCM_Audit AS T1
WHERE (((SELECT [T2].[SettingValue] AS C11
FROM dbo.WebUserSettings AS T2
WHERE Lower([T2].[AccountID]) = Lower('REDACTED')
AND [T2].[SettingName] = 'NCM.NCMAccountRole'
AND [T2].[InstanceSiteId] = '0')) NOT IN ('None'))
AND ([T1].[Details] LIKE '%IP_REDACTED%')
ORDER BY [C7] DESC
