sp_WhoIsActive: Advanced Logging To Tables скачать в хорошем качестве

sp_WhoIsActive: Advanced Logging To Tables

In this video, I delve into a set of custom scripts designed to help you monitor and manage your SQL Server instances effectively. I walk through the creation of views that aggregate data from daily tables generated by the 'sp_whoisactive' stored procedure, providing a comprehensive view of what's happening on your server at any given time. The script also includes an agent job for automated logging, retention management to keep things organized, and a blocking query view that offers detailed insights into performance bottlenecks. These tools are particularly useful for those who might not have access to more advanced monitoring solutions or prefer a lightweight approach. Whether you're a DBA looking to catch subtle issues or just curious about what's going on under the hood of your SQL Server, these scripts can provide valuable information and peace of mind. CHAPTERS 00:00:00 - Introduction 00:00:29 - Logging Setup and Views 00:01:57 - Daily Table Management 00:03:36 - Blocking Query View 00:04:52 - Logging Procedure 00:06:11 - Retention Management 00:08:11 - Agent Job Setup 00:10:30 - Results and Usage 00:12:22 - 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━