...
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.
Create a
servers.csvfile with the SQL Server instances you want to collect data from (details below)Run
sqlserver-telemetryvia the Terminal, Command Line, or Powershell (examples below)Upload the
telemetry.jsonfile 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 required details 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 SQL Server instance should be on have its own line, and 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
| 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. |
...
The recommended csv format for each instance is:
| Code Block |
|---|
ipOrDNS,portOrInstanceName,username,password,database |
Field | Description | Example Values |
|---|---|---|
ipOrDNS | Host address (IP or DNS name) for SQL Server |
|
portOrInstanceName | Port number or instance name (depends on validity) |
|
username | SQL Server username for authentication |
|
password | Password for the SQL Server username |
|
database | Name of the database to connect to |
|
The tool will use this information to build connection strings to retrieve the necessary data.
Run sqlserver-telemetry
Windows
...