Page tree

Versions Compared

Key

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

This procedure guides you through the installation of the IDERA Dashboard and and SQL Workload Analysis.

Start your IDERA SQL Workload Analysis installation

...

  1. Log on with an administrator account to the computer on which you want to install SQL Workload Analysis.
  2. Run SetupRun Setup.exe in exe in the root of the installation kit.
  3. Click Next on the  on the Welcome window window of the setup program.

Image RemovedImage Added

       4. Review the license agreement. To accept this license agreement, click click I accept the terms and conditions of this License Agreement, and then click click Next.

Image RemovedImage Added

Select Products to install

By default both By default both products (IDERA Dashboard & SQL Workload Analysis) are selected to be installed. You can choose to install only the IDERA Dashboard or only SQL Workload Analysis. 

Image RemovedImage Added

Select a registration option to install your IDERA Dashboard

You can select to install or upgrade your IDERA Dashboard on your local machine or on a remote server. If you have previously installed the IDERA Dashboard, provide the URL and the administrator credentials, and click click Next.

Image RemovedImage Added

Select an installation location and type a display name for your instance

...

On the Display Name text box, type a unique name for your SQLWA instance, and click Next to Next to continue with the installation.

Tip
titleDisplay name

The display name helps you to distinguish different instances of the same product.

Image RemovedImage Added

Select a Windows user account to use for the service account

SQL Workload Analysis uses the service account to communicate with the with the monitored SQL Server. The IDERA Dashboard uses this account to connect, discover, and gather configuration information from SQL Servers in your environment.  The The installer grants the "Log on as a Service" right to the account that you specify, you can also choose to use different Windows credentials for each of the products.

...

  1. On the Service Account window, type appropriate credentials in the provided fields under which the services run.
  2. Click Click Next. SQL Workload Analysis verifies the connection before continuing.

Image RemovedImage Added

IDERA SQLWA Database and Message Queue configuration

To change the storage paths for the Database File and the Message Queue, first uncheck the Default Location, and enter the new storage paths.

Image RemovedImage Added

Service Ports

The SQL Workload Analyzer services uses the following ports:

  • IDERA Framework Service Port: 20700
  • IDERA PMDB Service Port: 20701
  • ActiveMq Message Queue Port: 20705

Image RemovedImage Added

Tip

Verify that the Firewall allows TCP (Transmission Control Protocol) traffic through your specified ports.

Purge Schedule Details

Configure the schedule to run the purge process in SQL Workload Analysis. The Purge Schedule Details is set at 2:00 AM, every 2 weeks, on Sunday, by default.

Image Added

Info

The purge process does not affect historical data that is visible to users. It is a cleanup utility to improve stability.

Complete the install

The setup will grant the provided accounts access to SQL Workload Analysis and the IDERA Dashboard. The user that installs the IDERA Dashboard has access to this application by default as a Dashboard Administrator. You can choose whether you want other users to have access to the IDERA Dashboard in the Administration view. Click Install to indicate that you are ready to complete your installation with the configurations you specified. If you want to review or change any of your settings, click Back.

Image RemovedImage Added

To complete the SQL Workload Analysis, click Finish to exit the IDERA Dashboard Setup Wizard.

Image RemovedImage Added

To access the IDERA Dashboard and the SQL Workload Analysis web console, see see Log in the IDERA Dashboard and web console.

...

Scroll PDF Exporter Ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|  
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|  
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...