The select command send by orion NPM and NCM to SQL Server is without with(nolock) clause, and is rong, because the SQL Server stay very slow.
Use with(no Lock) clause on your select clause.
att,
Julio Velloso
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.