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
Month: September 2018
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