sqlserver probe is creating blocking on databases

book

Article ID: 130523

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction



Some queries in our profile take a substantive amount of time to run. This can create issues with blocking. Can we split these into multiple connections?

Environment

Release:
Component: UIMSQS

Resolution

Yes. It is possible to create two connections in the probe configuration (using the same user), and then two profiles (each using one of the connections) splitting up the long running queries from the quick running queries.