Welcome to the CSS_SQL_Networking_Tools wiki!

As part of the larger Microsoft push into Open Source and of making some of our internal troubleshooting tools and processes available publicly, the Microsoft SQL Server Connectivity / Networking team has set up this repository to publish some of our tools.

Troubleshooting Workflows

0000 Troubleshooting Workflows

Cookbook

Cookbook - How Do I
Cookbook Scripts

Network Patterns

Network Patterns

Case Studies

Case Studies

Tools

SQL Network Analyzer (SQLNA)

This is a command-line C# tool that reads one or more network traces and produces a report detailing potential problems.

SQL Network Analyzer UI (SQLNAUI)

This is a GUI tool that builds the command-lines for SQL Network Analyzer.

SQL Connectivity Check (SQLCHECK)

This is a command-line C# tool that can be run on SQL Server machines and clients and reports on any settings that may affect connectivity.

SQL Trace (SQLTRACE)

This is a command-line PowerShell script that can be run on SQL Server machines and clients and collects Network traces, BID Traces, and Auth traces that may reveal the underlying cause for connectivity issues.

Database Connection Test (DBTEST)

This is a command-line C# tool that can be run on a client to test connections to SQL Server and other ODBC or OLE DB data sources. It will record how long it takes to connect and how long to execute a command and retrieve the results. It can optionally display some or all rows in the console window, and can be set to repeat the connection/command at set intervals as a reliability test.

SQL Driver Security API Trace (SSPICLIENT)

This is an MFC Windows C++ Tool that can be run on client machines having SSPI or Kerberos errors and will log a detailed trace for analysis.

SQL Benchmark Tool (SQLBENCH)

This is a command-line C# tool that can be run on different machines and different databases and display timings for comparative analysis.