sp_WhoIsActive: Getting Memory Grant Details скачать в хорошем качестве

sp_WhoIsActive: Getting Memory Grant Details

In this video, I delve into using SPWhoIsActive to gain deeper insights into query memory grants on SQL Server. I demonstrate how to leverage the new '@GetMemoryInfo' parameter to extract valuable information and highlight why its output can sometimes appear a bit peculiar. I walk through a demo where I run SPWhoIsActive and explain the nuances of the memory grant data, particularly focusing on the 'used memory', 'max used', 'requested', and 'granted memory' columns, as well as the XML-based 'memory info' column. By understanding these details, you can better diagnose issues related to query memory grants and optimize your SQL Server environment for improved performance. CHAPTERS 00:00:00 - Introduction 00:00:29 - SPWhoIsActive Demo Setup 00:01:29 - Update SPWhoIsActive 00:01:54 - New Parameter at Get Memory Info 00:03:14 - Weird Results Explanation 00:04:05 - Used Memory Column Discussion 00:04:41 - Memory Info Column Details 00:06:05 - Query Wait Order Information 00:07:01 - Get Memory Info Column Usage 00:08:02 - Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-... SQL Server Performance Engineering Course https://training.erikdarling.com/sql-... Learn T-SQL with Erik https://training.erikdarling.com/lear... Everything Bundle: https://training.erikdarling.com/?cou... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlc... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member    / @erikdarlingdata   ━━━━━━━━━━━━━━━━━━━━━━━━━━