Our software is an ERP with queries build in the program, so loads of ad-hoc queries...

The deadlock flag can be useful to catch future problems, and since they can be very tricky to catch, being the flag enabled, it's easy to get the deadlock detail...

If we notice performance problems due to the flag the i'll disabled it.

Thanks,

Pedro