There are a couple ways to handle the locking aspect of this question:
Deadlocks will occur as soon as the database engine sees the issue, so there is often little time associated with a deadlock. If there is something I am missing about deadlocks, please reply.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.