Instructions to run a collection for Workloads SQL Server in Limited Preview Mode (02/07/20)

Live Optics Agent

 

Overview

Live Optics now supports data analysis to help you understand your databases, the first one being the SQL Server. 

Using the Live Optics collector, configuration data is captured, analyzed and compiled into a Project and viewed from the online viewer. Performance collection and output ability will be in a later release. 

This document outlines the process on how to run an SQL Server Collection for Workloads in Limited Preview Mode from the Live Optics Collector.

 

Quick-Start Directions

  1. Download the Live Optics Collector (Windows .NET version)
  2. Launch Live Optics Collector
  3. Click Get Started
  4. Click “Yes, I agree” to accept the End User License Agreement (prompted only on first execution)
  5. Click “Yes, this is me” after verifying your identity is correct (prompted only on first execution)
  6. Select Workloads from the left menu
  7. Select SQL Server
  8. Select the authentication type; SQL Server Authorization or Windows Authorization
  9. Enter the username and password (if applicable)
  10. Click NEXT to select the Upload Option, either upload automatically (recommended) or upload later
  11. Click Next
  12. If upload automatically was selected, enter the project name to be created, click Next
  13. If upload later was selected, enter the file name and directory to save the .SIOKIT file
  14. When you have finished naming the project or entering the file name, click NEXT. You will be presented with a progress bar indicating how long it will take to run the collection.
  15. After the files are processed and if upload automatically was selected, the data will be sent to the Live Optics portal with NO action needed from the user
  16. An option to create a .SIOKIT for backup is provided, this can be skipped or the file can be created at this time
  17. If upload later was selected, the .SIOKIT will need to be manually uploaded to the Live Optics portal.
  18. Click Quit to exit the application

 

 Detailed Instructions

Download the Live Optics Windows Collector Software

  • From the Live Optics portal, Download Collectors can be selected from the left menu or from the radio button on the main screen

 

mceclip0.png

 

  • To download the Windows collector
  • Click the Download button to start the download. A file named LiveOptics.zip will be downloaded
  • Once the file download completes, extract the contents of the zip file to the host where the software will run. The Live Optics collector does not install like a typical Windows application.  Extracting the zip file is all that is needed to run the collector 

 

Run the Live Optics Collector Software

  • Navigate to the directory where the Live Optics collector software is downloaded
  • Run LiveOpticsDotNet4_5

 

mceclip4.png

  • Click the “Yes, I agree” button to accept the End User License Agreement

NOTE:  This question only appears the first time the collector software is run

 

mceclip5.png

 

  • Confirm the name and company is correct and click “Yes, this is me”
  • If the invitation to run Live Optics was from the Dell Systems Consultant, their information will also be listed

NOTE:  This question appears the first time the collector software is run

 

Start Profile Selection Process

  • Select Workloads from the list of Profile Types

mceclip6.png

 

  • Select SQL Server from the list of asset types

 

mceclip7.png

 

Identify the Array to Gather the Data

  • Enter the SQL Server Name, username, and password or choose Windows Authentication.  In order to successfully run a SQL Server config collection, the user must have VIEW SERVER STATE permission on the SQL Instance.
  • There is a choice to Collect Config Data only. Collection of Performance data and config data is coming soon and is not yet available.
  • Once entered, click Next

 

mceclip8.png

 

Start the Configuration Collection

  • The collector will connect to the SQL Server and confirm that the user has the correct permissions to collect from this specific database.

 

mceclip9.png

 

NOTE: In order to successfully run a SQL Server config collection, the user must have VIEW SERVER STATE permission

 

Select the Method to Upload to the Live Optics Portal for Processing

  • Selecting the default, “Upload my collection data to the Live Optics web portal automatically” this is the recommended method. Once the collection is complete, the data is automatically upload to the Live Optics portal. Internet connection is required for this option.
  • There is an option to upload later. This will save the configuration and performance data to an encrypted file. You will be prompted to give your file a name and select a location to save the file.
  • Once selected, click Next.

 

mceclip10.png

 

  • Enter the name of the project that will be created in the Live Optics portal
  • Click Next

 

mceclip11.png

 

Upload the data to the Live Optics portal

  • Once the collection has ended the files are processed and automatically uploaded to the web portal
  • During the upload, a status bar indicates the progress.  As can be quite large, the upload may take some time to complete depending on the speed of the Internet connection

 

mceclip12.png

 

  • The collector will indicate when the upload has completed

 

Create a backup file of the data

  • A choice will be provided to back up the project via a .SIOKIT. There is a choice to skip this option or create the backup file.
  • Identify the file name and save location of this file

 

mceclip13.png

 

Process has completed successfully!

  • Once the upload has completed. Click Quit to close the collector

 

mceclip14.png

 

  • An email from Live Optics will be sent when the project is ready for viewing on the web portal

 

 Uploading the .SIOKIT (applies only if the “upload later” was selected)

  • The Live Optics collector software is used to upload the SIOKIT files using the Windows collector

Start the collector. From the top menu bar, select Upload SIOKIT

 

mceclip15.png

 

  • Click Browse for File and select the .SIOKIT file previously saved.
  • Enter the name of the project that will be created in the Live Optics portal
  • Click Upload

 

mceclip16.png

 

  • The files are uploaded to the web portal. During the upload, a status bar indicates the progress.  As can be quite large, the upload may take some time to complete depending on the speed of the Internet connection

 

 

 

  • The collector will indicate when the upload has completed
  • Click Quit to close the collector
  • An email from Live Optics will be sent when the project is ready for viewing on the web portal

View Project Results

  • Log in to the Live Optics web portal (https://www.liveoptics.com)
  • Recent projects are listed on the dashboard
  • Select the project

 

mceclip18.png

 

  • Click on the project name to view the configuration online viewer.

 

mceclip19.png

 

mceclip20.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Please sign in to leave a comment.