BREAKING NEWS Pure Storage is named A Leader in the 2025 Gartner® Magic Quadrant™ for Enterprise Storage Platforms.
BREAKING NEWS Pure Storage is named a Leader in the 2025 Gartner® Magic Quadrant™ for Infrastructure Platform Consumption Services.
ANNOUNCEMENT Pure Storage introduces the Enterprise Data Cloud so customers can manage their data, not their storage
ANNOUNCEMENT Unify your on-premises and public cloud environments with a single, consistent experience.
Visit Pure.ai Sales 1-800-976-6494
Visit Pure.ai Sales 1-800-976-6494
The Pure Advantage Solutions Products Services & Support Resources Partners Company
CONTACT US
Sales 1-800-976-6494
Contact Us
Main Menu
The Pure Advantage
Solutions
Products
Services & Support
Resources
Partners
Company
Choose Your Region
Choose Your Region
  1. Video
  2. Webinars
  3. Why SQL Server Seems Locked Up
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 November 30, 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.
  • TechTalks
  • Microsoft SQL & Exchange Solutions
  • Modern Analytics
  • Data Analytics
  • Data Warehouse
  • Microsoft Solutions
  • Enterprise Applications

Brent Ozar

Founder/Owner, Brent Ozar Unlimited

Andy Yun

Consulting 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
Test drive SQL Server on Pure Storage

Test drive SQL Server on Pure Storage

Get hands-on with Pure Storage FlashArray and FlashBlade® with VMware, and explore SQL Server features, S3, snapshots, and data virtualization.

Try It Now

We Also Recommend...

Check Out Our Resource Center Check Out Our Resource Center
09/2025
Optimizing SQL Server Operations and Scale with Pure Storage
A Reference Architecture for Microsoft SQL Server with Pure Storage.
Reference Architecture
32 pages
09/2025
FlashArray ActiveCluster for Microsoft SQL Server
A solution for high availability, read scalability, and non-disruptive storage-level migration for Microsoft SQL Server databases.
White Paper
31 pages
02/2022
Embracing the Elephant in the Room: Ever-Shifting Expectations for Disaster Recovery & Business Continuity
Join Andrew Miller and Zane Allyn as they revisit an ageless topic from the first Coffee Break - All Things Data Protection (Disaster Recovery, Business Continuity, Backup & Recover) and how Pure can help..
Webinar
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.

safari
chrome
firefox
edge
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.