XIA Configuration

SQL Server Documentation Tool

Automated documentation software to help you keep track of your SQL servers

  Download Free 30-Day Trial   View Example Documentation

Use our SQL server documentation tool XIA Configuration to automatically document SQL On-Premises and Azure SQL.

XIA Configuration has a non-intrusive architecture with agentless data collection.

Looking to document detailed information about Windows servers? View the Windows page.

SQL Server Documentation Example

View an example document generated by XIA Configuration of a SQL instance, with custom branding:

SQL server documentation example generated by XIA Configuration
SQL server documentation example generated by XIA Configuration
  Open Example Document

The document above provides a concise view of your SQL instance settings. View a zip file with all options included.

Find out more about how you can apply your own branding.

Settings documented by XIA Configuration

Find out more about the SQL settings documented by XIA Configuration below:

Screenshot of the summary of a SQL server in the XIA Configuration web interface
Screenshot of the summary of a SQL server in the XIA Configuration web interface

Always On High Availability

This section includes Always On High Availability settings.

Availability Groups

This section includes Availability Group settings.

Screenshot showing Availability Group settings in the XIA Configuration web interface
Screenshot showing Availability Group settings in the XIA Configuration web interface

Availability Replicas

This section includes Availability Replica settings.

Screenshot showing Availability Replica settings in the XIA Configuration web interface
Screenshot showing Availability Replica settings in the XIA Configuration web interface

Listeners

This section includes Availability Group Listener settings.

Screenshot showing Availability Group Listener settings in the XIA Configuration web interface
Screenshot showing Availability Group Listener settings in the XIA Configuration web interface

Databases

This section includes Database settings.

Screenshot showing Database settings in the XIA Configuration web interface
Screenshot showing Database settings in the XIA Configuration web interface

Assemblies

This section includes Assembly settings.

Screenshot showing Assembly settings in the XIA Configuration web interface
Screenshot showing Assembly settings in the XIA Configuration web interface

Options

This section includes information on Database Options.

Screenshot showing Database Options in the XIA Configuration web interface
Screenshot showing Database Options in the XIA Configuration web interface

Files

This section includes information on Database Files.

Screenshot showing Database Files in the XIA Configuration web interface
Screenshot showing Database Files in the XIA Configuration web interface

Creation Script

This section includes the Database Creation Script.

Screenshot showing the Database Creation Script in the XIA Configuration web interface
Screenshot showing the Database Creation Script in the XIA Configuration web interface

Stored Procedures

This section includes Stored Procedure settings.

Screenshot showing Stored Procedure settings in the XIA Configuration web interface
Screenshot showing Stored Procedure settings in the XIA Configuration web interface

Tables

This section includes Database Table settings.

Screenshot showing Database Table settings in the XIA Configuration web interface
Screenshot showing Database Table settings in the XIA Configuration web interface

Table Columns

This section includes Table Column settings.

Screenshot showing Table Column settings in the XIA Configuration web interface
Screenshot showing Table Column settings in the XIA Configuration web interface

User Defined Functions

This section includes User Defined Function settings.

Screenshot showing User Defined Function settings in the XIA Configuration web interface
Screenshot showing User Defined Function settings in the XIA Configuration web interface

Views

This section includes View settings.

Screenshot showing View settings in the XIA Configuration web interface
Screenshot showing View settings in the XIA Configuration web interface

Host

This section includes Host settings.

Screenshot showing Host settings in the XIA Configuration web interface
Screenshot showing Host settings in the XIA Configuration web interface

Management

This section includes Management settings.

Database Mail

This section includes Database Mail settings.

Screenshot showing Database Mail settings in the XIA Configuration web interface
Screenshot showing Database Mail settings in the XIA Configuration web interface

Maintenance Plans

This section includes Maintenance Plan settings.

Screenshot showing Maintenance Plan settings in the XIA Configuration web interface
Screenshot showing Maintenance Plan settings in the XIA Configuration web interface

Resource Governor

This section includes Resource Governor settings.

Resource Pools

This section includes Resource Pool settings.

Screenshot showing Resource Pool settings in the XIA Configuration web interface
Screenshot showing Resource Pool settings in the XIA Configuration web interface

Security

This section includes Security settings.

Credentials

This section includes Credential settings.

Screenshot showing Credential settings in the XIA Configuration web interface
Screenshot showing Credential settings in the XIA Configuration web interface

Cryptographic Providers

This section includes Cryptographic Provider settings.

Screenshot showing Cryptographic Provider settings in the XIA Configuration web interface
Screenshot showing Cryptographic Provider settings in the XIA Configuration web interface

Logins

This section includes Login settings.

Screenshot showing Login settings in the XIA Configuration web interface
Screenshot showing Login settings in the XIA Configuration web interface

Server Roles

This section includes Server Role settings.

Screenshot showing Server Role settings in the XIA Configuration web interface
Screenshot showing Server Role settings in the XIA Configuration web interface

Server Objects

This section includes Server Object settings.

Backup Devices

This section includes Backup Device settings.

Screenshot showing Backup Device settings in the XIA Configuration web interface
Screenshot showing Backup Device settings in the XIA Configuration web interface

Endpoints

This section includes Endpoint settings.

Screenshot showing Endpoint settings in the XIA Configuration web interface
Screenshot showing Endpoint settings in the XIA Configuration web interface

Server Properties

This section includes Server Properties.

Screenshot showing Server Properties in the XIA Configuration web interface
Screenshot showing Server Properties in the XIA Configuration web interface

Advanced

This section includes Advanced properties.

Screenshot showing Advanced Server Properties in the XIA Configuration web interface
Screenshot showing Advanced Server Properties in the XIA Configuration web interface

Connections

This section includes Connection settings.

Screenshot showing Connection settings in the XIA Configuration web interface
Screenshot showing Connection settings in the XIA Configuration web interface

Database Settings

This section includes Database settings.

Screenshot showing Database settings in the XIA Configuration web interface
Screenshot showing Database settings in the XIA Configuration web interface

Memory

This section includes information on Memory.

Screenshot showing Memory information in the XIA Configuration web interface
Screenshot showing Memory information in the XIA Configuration web interface

Permissions

This section includes information on Permissions.

Screenshot showing Permissions in the XIA Configuration web interface
Screenshot showing Permissions in the XIA Configuration web interface

Processors

This section includes information on Processors.

Screenshot showing Processor information in the XIA Configuration web interface
Screenshot showing Processor information in the XIA Configuration web interface

Security

This section includes Security settings.

Screenshot showing Security settings in the XIA Configuration web interface
Screenshot showing Security settings in the XIA Configuration web interface

SQL Server Agent

This section includes SQL Server Agent settings.

Screenshot showing SQL Server Agent settings in the XIA Configuration web interface
Screenshot showing SQL Server Agent settings in the XIA Configuration web interface

Alerts

This section includes Alerts settings.

Screenshot showing Alert settings in the XIA Configuration web interface
Screenshot showing Alert settings in the XIA Configuration web interface

Jobs

This section includes Job settings.

Screenshot showing Job settings in the XIA Configuration web interface
Screenshot showing Job settings in the XIA Configuration web interface

Operators

This section includes Operator settings.

Screenshot showing Operator settings in the XIA Configuration web interface
Screenshot showing Operator settings in the XIA Configuration web interface

Proxies

This section includes Proxy settings.

Screenshot showing Proxy settings in the XIA Configuration web interface
Screenshot showing Proxy settings in the XIA Configuration web interface

Inventory

Create an inventory by automatically detecting and scanning Windows machines that are members of an Active Directory domain.

When scanning Windows machines. server roles such as SQL are automatically detected and scanned.

Learn more
Screenshot of Active Directory search and detection settings in the XIA Configuration Client
Screenshot of Active Directory search and detection settings in the XIA Configuration Client

Relationship Map

XIA Configuration generates a map showing relationships between customers, databases, Windows servers and other items:

Screenshot showing SQL server relationships in the XIA Configuration web interface
Screenshot showing SQL server relationships in the XIA Configuration web interface

Supported Versions

The following versions of SQL are supported by XIA Configuration:

  • Azure SQL
  • SQL 2019
  • SQL 2017
  • SQL 2016
  • SQL 2014
  • SQL 2012
  • SQL 2008 and 2008 R2

Note: All editions of each SQL Server version are supported.

For more information about documenting SQL, please view the administrator's guide.

Try our SQL server documentation tool for free