TheSQLGuru (7/22/2013)
.... The other biggie, and I mean potentially non-functional application biggie, is deadlocks. I have had several clients that have started throwing a blizzard of deadlocks after moving to SSD storage, including one that had to roll back to rotating media to get their system reusable!!
Very interesting:blink:
So the increased IO latency is keeping the code from deadlocking itself!
Never thought of that - I would normally expect to see the bottleneck shifting towards latches of some sort.
Weird huh. :alien:
Cheers,
JohnA
MCM: SQL2008