Tracking the Optimizer with gdb
Tracing a low-level Oracle C function for getting insights into the optimizer decision making Continue Reading
Author: Nenad Noveljic
Enriching Trace with Call Stacks
A DTrace script for capturing the call stack when a line gets written into the trace file. It’s useful, for example, for finding out the functions participating in a particular query transformation. Continue Reading
Suboptimal Execution Plan with Join Predicate Push-Down Transformation
JPPD is performed where it shouldn’t. Use the CBO trace parser for detecting the problem. Continue Reading
Dissecting Cost Based OR-Expansion
Analyzing the CBO trace for getting insight into the cost based OR-expansion Continue Reading
Breakpointing SQL Execution with WinDbg
Debugging SQL Server with WinDbg Continue Reading
SQLNet Tracing’s Blind Spot
SQLNet client trace is missing. Continue Reading
Which Cipher Suite is being used for TDS Encryption?
Tracing TCP to find out the cipher suite which is being used for TDS encryption Continue Reading
TCP Storm in SQL Server
Beware of TCP storms in SQL Server, especially in SQL Server 2014 where they can cause a serious performance problem. Continue Reading
Excessive Context Switching due to TDS Encryption
TDS encryption can have a dramatic performance impact in SQL Server 2014 because of excessive context switching. The implementation was significantly improved in SQL Server 2016 and 2017. Continue Reading
SQL Server Extended Events Trace Overhead
Measuring Extended Events Trace overhead and correctly interpreting the trace information. Continue Reading