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
Julio, thanks for the feedback. We'll look at whether this is feasible for a future release.