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.
Recently, 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 moreI would like to say thank you for attending my presentations on this year ShowIT.
Read moreThis is one of our tuning successes, particularly for the nightly process of loading data into a report server from the main database.
Read more
