Most RecentMost ViewedMost LikesHow It Works: Sync IOs in nonpreemptive mode longer than 1000 ms How It Works: Sync IOs in nonpreemptive mode longer than 1000 ms Negative Blocking Session Ids (-5 = Latch ANY TASK RELEASOR) SQL Server may report a blocking session id as a negative integer value. SQL Server uses negative sessions ids to indicate special conditions. -5 Any task/session can release the latch. I/O latches are the most common user. How It Works: SQL Server DTC (MSDTC and XA Transactions) How It Works: SQL Server DTC (MSDTC and XA Transactions) SQL Server On Linux: Forced Unit Access (Fua) Internals SQL Server On Linux: Forced Unit Access (Fua) Internals SQL Mysteries: Why am I Still Seeing 17830 Errors? Why am I Still Seeing 17830 Errors? Using SQL Server’s SNITrace to Troubleshoot Networking Issues Using SQL Server’s SNITrace to Troubleshoot Networking Issues HOW IT WORKS: SQL Server Scheduler Affinity SQL Server affinity capabilities discussed. SQL Mysteries: Why is my SQL Server experiencing lots of 17830 (TCP 10054) errors? SQL Mysteries: Why is my SQL Server experiencing lots of 17830 (TCP 10054) errors? SQL Server Mysteries: The Case of the Suspended, Awaiting Command, and Blocked Session SQL Server Mysteries: The Case of the Suspended, Awaiting Command, and Blocked Session SQL 2016 – It Just Runs Faster: XEvent Linq Reader SQL 2016 – It Just Runs Faster: XEvent Linq Reader
