Why SQL Server Seems Locked Up

Your server's CPU isn't 100%, but SQL Server isn't responding to requests, and it feels like it's locked up. You restart it, and the problem goes away. What's going on?

You'll learn the 2 most common causes: running out of worker threads, and running out of query workspace memory. Brent Ozar will demonstrate both of them happening live, and show you how to react when it happens. And we'll show you how, on Pure Storage, you can rapidly and repeatedly test your fixes against clones of production.

Join us for the webinar and you will:

• Learn how to fix poison waits
• Discover the role that data services and storage play in testing fixes and speeding up development cycles
• Hear more about lesser known features and modern approaches

Be one of the first 200 to register and attend, we will send you a $10 gift card for lunch of your choice.

Participants who attend and participate in the Event will be entered into a random drawing that will be conducted during or after the Event. The winner of the random drawing will receive one (1) JBL Clip Speaker (approx. value $100). The winning Participant will be identified during the Event or within a reasonable amount of time after the Event. Terms and Conditions.