RE: Strange transaction log activity

SSC Guru

Points: 90860

August 22, 2017 at 10:39 am

#1956206

Beatrix Kiddo - Tuesday, August 22, 2017 8:13 AM
Sue and Alan, I think we may be getting somewhere! I set up an Extended Events session and ran it for an hour. It captured a ton of primary key violation attempts happening every couple of seconds on a particular table, which the vendor has FINALLY admitted is a known issue caused by a configuration change last week, and that they have a hotfix for (honestly, app vendors are TERRIBLE). The timescale fits with when the problem started, so I need to wait for the hotfix to be applied and then see what's what. Thanks for forcing me to use XEvents 😀. I was convinced it was an application issue, but couldn't prove it for sure.

Wow....what an ugly ordeal. Glad it looks like things are narrowed down. And thanks for posting and keeping the thread apprised of everything - although I figured you would. Drives me nuts when people get replies and never post anything back.

It's kind of weird how nonchalant vendors are about hosing out peoples database systems. If we were to act the same, we'd be fired. Extended events aren't too bad and with having less overhead it's better and you can capture more than you can with traces. I am much more used to using server side traces though and tend to go to that first. I'm working on doing more with XEvents as well.

Sue