CPO Performance

[Vadim Truksha]

Can be deleted.

[Vadim Truksha]

Is any easy way to find this "bad" processes? Maybe CPO logs or MSSQL monitoring? All this problem can exist if we dont have any running processes?

[Shaun Roberts]

Are you using an "all in one" or are they separate CPO and DB instances?

Is this a shared DB or just using for CPO?

How much memory is SQL using?

When you start CPO you can check out the performance counters to see how much is "going on".

Start->Run "perfmon"

Then add counters and look for "EnterpriseOrchestrator" and look for the ones for active processes and activities and such.

I mean you can run a count on the dbo.ProcessInstance and dbo.ActivityInstance tables as well.

Have you opened a TAC case as well?

If you DB needs to be cleaned or worked on, that's the way to get to it.

[Vadim Truksha]

Can be deleted.