SQLBits 2018

"But It Worked in Development!" 3 Hard Performance Problems

You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
Warning: this is not an introductory session. These are going to be tough problems.

You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they're very hard to detect in a development environment.

In a very fast-paced session, I'll show these three performance problems pop up under load. I won't be able to teach you how to fix them for good - not inside the span of 75 minutes - but at least you'll be able to recognize the symptoms when they strike, and I'll show you where to go to learn more.