Subject For those who think they have performance problems
Author Alexey Kovyazin
Hi All,

Just got an amazing lock print.

This is real performance nightmare :)


LOCK_HEADER BLOCK

        Version: 145, Active owner: 63554144, Length: 210763776, Used: 209783832

        Flags: 0x0001

        Enqs: 21025066275, Converts: 82460471, Rejects: 64835339, Blocks: 594096759

        Deadlock scans:     61, Deadlocks:      0, Scan interval:  10

        Acquires: 25476138585, Acquire blocks: 34118657, Spin count:   0

        Mutex wait: 0.1%

        Hash slots: 1009, Hash lengths (min/avg/max):  358/ 403/ 445

        Remove node:      0, Insert queue:      0, Insert prior:      0

        Owners (728):   forward: 14876944, backward: 28924320

        Free owners (160):      forward: 186465696, backward: 25763912

        Free locks (78217):     forward: 5469536, backward: 1074360

        Free requests (386094): forward: 206130320, backward: 103961080

        Lock Ordering: Enabled

Regards,
Alexey Kovyazin
www.IBSurgeon.com