Read sys.dm_exec_query_statistics_xml for live plans, compare profile counts with estimates, and interpret partial progress carefully.
Writing Agent Job Step Output to a Log File on Disk
Preserve job step output in a server-side file, configure Agent tokens and append flags, and verify write permissions and retention.
MYSQL Long Running Queries
The data that used to be available freely now starts to get locked, and queries sprinting are now turning into long running queries.
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.
Tracking Changes in MySQL Configuration
The next logical place to check what has changed is the configuration. Let us learn about Tracking Changes in MySQL Configuration.
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.
SQL SERVER – Script to List Database File Latency
Today, we will see a very interesting script to list database file latency. I use this script quite often in my Performance Health Check.