SQL Network Analyzer UI (SQLNAUI)

SQL Network Analyzer UI is the GUI interface for SQL Network Analyzer. It builds the command line and executes SQL Network Analyzer.

The application consists of two forms, the main GUI and a Preferences form for setting longer term preferences.

Main Form

In this form:

• Select File | Preferences to set your preferences. These are remembered across sessions.
• Select File | Open to open a network file to parse. If you have chained traces, just select the first file. You can add a wildcard after the dialog closes. Make sure the wildcard does not terminate the string, otherwise, SQL Network Analyzer will try to read your log files, too. If there is no file extension, terminate with a period ( . ). Files do not have to end in .CAP, .PCAP, or .PCAPNG, SQL Network Analyzer will recognize their format automatically. NETSH trace files must end in .ETL, as there is no "magic number" to identify the file type.
• If you want the output file to be located other than in the trace folder, you can specify a path and file name.
• SQL Network Analyzer recognizes SQL Server traffic by specific packet types. If there are too few packets in the trace, e.g. it is mainly open, idle connections, SQL Network Analyzer may not recognize the traffic. You can force this by adding one or more hints in the format 10.10.10.10,1433 separated by spaces.

As you type, the command-line will be built in the lower area of the form. Press the Parse button to launch SQL Network Analyzer with the command-line.

Note: If the path is too long for the textbox, just drag the window wider and the controls will resize.

Preferences Form

In this form:

• Set whether you want the optional "Successful Conversations" report displayed. This can be rather lengthy for long traces and is off by default.
• Choose your IP Address and Port # display format. Default results in each being displayed in its own column. Select NETMON Filter String if you use that tool to view network traces. Select WireShark Filter String if you use that tool to display network traces. This will cause a filter string to be generated for easy filtering. Auto chooses between the NETMON and WireShark filter formats depending on the trace type you choose to process.

Preferences are stored in HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Network Analyzer

Installation

Copy SQL Network Analyzer (SQLNA.EXE) and the UI (SQLNAUI.EXE) into the same folder. In general, copy the files to the desktop for easy access, or locate in a "Tools" folder. You do not have to copy the files into the network capture folder. Launch by double-clicking on SQLNAUI.EXE in Windows Explorer or on the desktop.

The applications are written in C# and target the full .NET 4.x Framework on Windows.
Download from the SQL Network Analyzer page.