Using SQL Server’s SNITrace to Troubleshoot Networking Issues

Moved from:


SNITrace, formally BIDTrace, is an deeper level of tracing for the Microsoft SQL Server TDS consumers and providers.


Terms and Brief History

Before I dive into the details here is a brief history and related terminology.



Built-In Diagnostics (BID) is the former name replaced with SNI.  The original tracing was added as BIDTrace and since then many of the functions and macros were renamed to SNITrace* as improvements were made and features added.


Server Network Interface (SNI) is centralized code, shared among the SQL