During last SQL Server Bootcamp 2024 in Brno - our colleague Jan Repka presented a live query tuning session. The scripts used in DEMOs are available here: Live query tuning scripts (DOWNLOAD)
Michal Kovaľ is a member of Woodler Database Administrator Support Team. He often handles SQL Server troubleshooting challenges and Root Cause Analysis (RCA). As a secondary passion he is responsible also for visual representation of Woodler Company.
Today, we have prepared another release of SMT 1.11.0 for you. It is rather significant, and it should be since we haven’t had a big one since last summer. So take your time, sit down, and let’s go through the news in SMT.
Read moreRecently, we found an interesting pattern during exploring one of our SMT graphs while doing a health check of a SQL server. The following graph shows us the Load Factor attribute. The value came from system table sys.dm_os_schedulers, which the SMT tool
Read moreBackup device is a standard backup file. But this file is registered in management studio and often used to store more than one backups from database. There are also some pros and cons in usage compared to standard backups stored in folders and made by ma
Read more
