47:47 Webinar

Why SQL Server Seems Locked Up

Watch this Webinar to learn the 2 most common causes: running out of worker threads, and running out of query workspace memory.

This webinar first aired on 30 November 2023

The first 5 minute(s) of our recorded Webinars are open; however, if you are enjoying them, we’ll ask for a little information to finish watching.

Microsoft SQL & Exchange Solutions
Modern Analytics
Data Analytics
Data Warehouse
Tech Talks
Microsoft Solutions
Enterprise Applications

Brent Ozar

Founder/Owner, Brent Ozar Unlimited

Andy Yun

Field Solutions Architect, Pure Storage

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.

Watch 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

Continue Watching

We hope you found this preview valuable. To continue watching this video please provide your information below.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Your Browser Is No Longer Supported!

Older browsers often represent security risks. In order to deliver the best possible experience when using our site, please update to any of these latest browsers.