Subject | For those who think they have performance problems |
---|---|
Author | Alexey Kovyazin |
Post date | 2014-02-20T17:02:27Z |
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: EnabledRegards,
Alexey Kovyazin
www.IBSurgeon.com