Performance consideration in Enabling LockLogger

Database
Teradata Employee

Performance consideration in Enabling LockLogger

Hi,

Is there any way to measure performance impact on existing queries with enabling LockLogger?

I'm planning to enable LockLogger in continuous mode to debug deadlock queries.

But I'm not sure the side-effect on perfomance of existing queries. Will is use CPU a alot? Many Disk I/O?

I suppose specific values are depend on the workload, but I'd like to know if there are any way to measure impact on perfomance, before enabling it.

Thank you.

1 REPLY
Teradata Employee

Re: Performance consideration in Enabling LockLogger

I mean "estimate", not measure.