sp_WhoIsActive: Filtering Results To See What You Want скачать в хорошем качестве

sp_WhoIsActive: Filtering Results To See What You Want

In this video, I dive into the versatile 'sp_whoisactive' stored procedure and explore how to filter its output effectively. Whether you're troubleshooting specific queries or managing a server with numerous databases, these filters can significantly streamline your analysis. I walk through filtering by session ID, program, database, login, and host, demonstrating practical examples like filtering out background tasks, focusing on particular databases, and even using the 'NOT' filter to exclude unwanted results. The video also touches on how these filtering capabilities inspired my creation of a similar tool for monitoring query plans over time, making it easier to manage complex environments with many concurrent activities. CHAPTERS 00:00:00 - Introduction 00:01:29 - Filtering Results 00:02:17 - Session ID Filter 00:03:13 - Database Filter 00:04:36 - Program Filter 00:05:36 - Not Filter and Wildcard 00:06:36 - SP Human Events Inspiration 00:08:25 - 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━