All Forums Database
shimpeko 8 posts Joined 04/10
18 Jul 2013
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.

shimpeko 8 posts Joined 04/10
18 Jul 2013

I mean "estimate", not measure.

You must sign in to leave a comment.