Versions Compared

Old Version 15

changes.mady.by.user Dave Laing

Saved on

compared with

New Version 16

changes.mady.by.user Todd Erickson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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

Note: The SQL Telemetry data collector will collect data over a 10-minute period for each instance. The data collection status of each instance will be displayed in the terminal.

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. One Each SQL Server instance should be one per on its own line, there is no limit to the number of SQL Servers.

The recommended connection string format is:

Code Block
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

...

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

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

Note: The first three examples functionally equivalent. They all collect data from the default instance using the sa user on the machine the SQL Telemetry data collector is running on.

Run sqlserver-telemetry

Windows

...