Preserve job step output in a server-side file, configure Agent tokens and append flags, and verify write permissions and retention.
Long Running Queries in MySQL: Find Them in Two Ways
Find long running queries in MySQL with two built-in methods: the slow query log and the Performance Schema digest table. See the settings, a ready query and how to choose between them.
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – Script to List Database File Latency. Here is the video.
MySQL Configuration Changes: Track What Changed and When
MySQL configuration changes explain many sudden slowdowns. See how innodb_read_ahead_threshold works, what MySQL 8.0 records about a change and how to keep your own history.
Tagging Queries With SESSION_CONTEXT to Trace App Users
Tag SQL Server work with SESSION_CONTEXT, read tags in audit defaults and modules, and handle read-only values and pooled connections.
Database File Latency: Read and Write Stalls per IO
Database file latency is the stall time per read or write. This post divides the IO stall columns by the call counts for every file, explains the zero queued columns and says when a number is worth acting on.
Indexing for Delete – SQL in Sixty Seconds #197
Today, we will see another interesting topic where the index affects the delete statement. Let us start watching the video Indexing for Delete.