Page Comparison

...

1. Download the latest version of the SQL Telemetry data collector using the link for your operating system above and save it to a directory on your system.

2. Create a servers.csv file with the SQL Server instances you want to collect data from (details below)

3. Run sqlserver-telemetry via the Terminal, Command Line, or Powershell (examples below)

4. Upload the telemetry.json file that is produced to the Cloudamize console

servers.csv (Input File)

In the directory where you downloaded the application, create a new file called servers.csv with the connection strings for all of the SQL Server instances you would like to collect data from. This file can be created with Notepad, Excel, or any text editor. Each One SQL Server instance should be on its own one per line, there is no limit to the number of SQL Servers. Each line should contain three comma-separated values:

• Server - IP address, URL, or DNS name optionally followed by \ and the Instance name or : and the port

• User ID - either SQL User ID or DOMAIN/USERID

• Password

Below is a sample file showing several examples

localhost,sa,b!7GS2rAMX
localhost\MSSQLSERVER,sa,b!7GS2rAMX
localhost:1433,sa,b!7GS2rAMX
localhost\TEST,sa,b!7GS2rAMX
localhost\SQLEXPRESS,sa,b!7GS2rAMX
44.223.64.79\TEST,sa,b!7GS2rAMX
44.223.64.79\TEST,EC2AMAZ-I317F7N\Administrator,i5tnno0!OsSsX0
ec2-44-223-64-79.compute-1.amazonaws.com\MSSQLSERVER,EC2AMAZ-I317F7N\Administrator,i5tnno0!OsSsX0Rdn;;%2=fReRBYaLk.

...

The recommended connection string format is:

sqlserver://<username>:<password>@<ip>:<port>?database=sqltelemetrydb,username,password

• <username>:<password>: leave this section unchanged

• <ip>:<port>: Replace this with the actual IP address and port number

• database=sqltelemetrydb: Replace sqltelemetrydb with the database name

• username,password: Replace these with the username and password

Run sqlserver-telemetry

Windows

...