Home

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 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.

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.

Database Connection Test

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.