פרק 127 - SQL Server Error Logs and Deadlocked Schedulers
Oct 04, 2020•43 min•Ep. 127
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more
Episode description
גיא גלנצר ואיתן בלומין מעבירים כמה פניני חוכמה אודות קבצי הלוג של SQLServer, איך מתמודדים עם Deadlocked Schedulers, ועוד נושאים מעניינים.
קישורים רלוונטיים:
- Eitan Blumin - Microsoft Data Platform MVP
- SQL Server Error Log Management | Guy Glantser
- Recycle Full-Text Catalog Log Files | Jonathan Kehayias
- SQL Server Trace Flag 3226 | Glenn Berry
- The Tao of a Deadlocked Scheduler
- Tasks, Workers, Threads, Scheduler, Sessions, Connections, Requests; what does it all mean?
- Links of various CSS SQL Support Tools (SQLDiag, PSSDiag, RML Utilities, SqlNexus)
- sp_server_diagnostics | Microsoft Docs
- How to troubleshoot THREADPOOL waits and Deadlocked Schedulers | Eitan Blumin
- SQL Server 2019 Intelligent Performance - Worker Migration
- Everything You Need to Know about Head Blockers | Guy Glantser
- Microsoft MVP Days Israel 2020
For the best experience, listen in Metacast app for iOS or Android