Blog

Poor Performing DB Job

Over night we had a job that overran and caused deadlocks when the morning OLTP operations started. Unlike poor performing code, it can be harder to look into a job as it can often spawn multiple queries while it runs. There are a couple of methods you can use to assist.

Run Job Manually

The simplest method if you can do it, is to run the job manually as a code block with tracing turned on: