Page Comparison

...

Regardless of Operating System (Output)

This utility will run for ten minutes, and generate a JSON file called telemetry.json which is a machine and human-readable list of all of the output for the telemetry commands run against each of the listed DSN connection strings in the servers.csv file. For each connection string, it will capture the following information as accessible from within SQL Server AND the permissions allowed to the connection string account:

• Host

• SQLServerVersion

• SQLServerEdition

• OperatingSystem

• AvailabilityGroups

• Roles

• ClusterInfo

• Mirroring

• LogShipping

• Memory

• HostCores

• VisibleCores

• I/O Performance

• Enterprise Level Features Used

• Errors

In order to make this more resilient, any errors identified during the execution of this utility will be silently captured and stored in the Errors field. This allows for maximal telemetry gathering without having to repeatedly trial and error within a customer's site. It is important to note that the output will NOT have any sensitive credential information and can therefore be exported with minimal to no risk associated.

...

• Follow these steps in the Cloudamize Console to upload the SQL Telemetry output file:

  • When the above process completes, there will be a telemetry.json file in the Downloads folder

  • Log into the Cloudamize Console

  • Navigate to the Settings page
    

    

  • On the Settings Page > External Data option, you will see a tab called SQL Telemetry
    

    

  • Select SQL Telemetry and then click on the Upload SQL Telemetry Report option to upload the telemetry.json file.

• We will fill in the following data collected from the above process where the data was not collected by the agent or agentless data collector.

  • On-Prem Server Name (REQ'D)

  • On-Prem SQL Server Edition(REQ'D)

  • On-Prem SQL Server Version(RCM'D)

  • On-Prem Operating System(REQ'D)

  • SQL Cluster Name

  • Passive Instance Using Log Ship, DB Mirroring(Non-Cluster)

  • SQL Availability Group

  • SQL Availability Group Role

  • SQL Max Server Mem in MB

  • SQL DB Mirroring Present

  • SQL I/O Performance

  • SQL Enterprise Level Features Used

Note: When the agent is collecting the telemetry data, It will be stored inside a Cloudamize folder and will be in encrypted format which users cannot see.

I/O Performance data can be viewed by clicking the button in the “Other SQL Info” column:

...

Reporting

The full report can be access from the reports section of the new console:

...

The data is also available on the classic console, in the SQL Server and License Usage report (accessed via the Migration Planner):

...

Issues or Queries?

If you have any questions, concerns, or issues, please contact helpdesk@cloudamize.com.

This application is built using the Go Programming Language in order to allow for safe and reliable software that is cross-platform.

...