Versions Compared

Key

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

This section contains a brief walk through for Solutions enabler deployment, for the purpose of monitoring by SQL Workload Analysis. for the full procedure and options of Solutions Enabler deployment, see also the Solutions enabler Installation Guide document, which can be found in the document set on the EMC web site.

Info
titleNote

A user with the administrator role is needed to complete the following procedure.

...

  1. Install Solutions Enabler.
    1. Select the destination folder.
    2. Select he Setup Type (use: Complete)
    3. On the Service List, use the defaults and also check the SYMAPI daemon checkbox.
    4. Click Next.
    5. Click Install.
  2. If your SQL Server instance stores its data on CLARiiON or VNX storage arrays , the monitored server should be authorized using a SYMCLI command as follows:
    1. Make sure you have the array's Storage Processors (SP) hostname or IP address, and the array's administrator username and password.
    2. Open the command prompt.
    3. Navigate to the directory in which EMC Solutions Enabler is installed.
    4. Execute: SYMCLI\BIN\symcfg.exe authorization add -host {VNX-SP} -username {VNX Administrator} -password {VNX Administrator Password}
  3. If your SQL Server instance stores its data on Symmetrix (DMX or VMAX) storage arrays, gatekeeper devices must be installed.
    1. Gatekeeper device is a small device (less than 3 MB) used by Solutions Enabler to improve the communication with the storage array. The assistance of a storage administrator is required.
    2. To verify which storage units and devices are attached to a monitored server, execute: SYMCLI\BIN\syminq.exe
      The following table shows an example of the command's output.

      DeviceProductDevice
      NameTypeVendorIDRevSer NumCap (KB)
      \\.\PHYSICALDRIVE0
       

      SEAGATEST15150WHP12029942394194157
      \\.\PHYSICALDRIVE1
       

      EMCSYMMETRIX5265930523614224000
      \\.\PHYSICALDRIVE2
       

      EMCSYMMETRIX5265930524614224000
      \\.\PHYSICALDRIVE3
       

      EMCSYMMETRIX5265930525614224000
      \\.\PHYSICALDRIVE4GKEMCSYMMETRIX5265930501612880
      \\.\PHYSICALDRIVE5GKEMCSYMMETRIX5265930511612880
    3. Gatekeeper devices are marked with GK in the Type column. The two most left digits (93 in this example) are the suffix of unit ID.
    4. If gatekeeper devices are missing, ask the storage administrator to define them. To verify, execute SYMCLI\BIN\syminq.exe and check its output once again.
  4. If the monitored SQL Server instance runs on a VMware guest server, the monitored server should be authorized using a SYMCLI command as follows:
    1. Make sure you have the ESX server hostname or IP address, and the ESX server's administrator username and password.
    2. Open a command prompt.
    3. Navigate to the directory in which EMC Solutions Enabler is installed.
    4. Execute: SYMCLI\BIN\symcfg.exe authorization add -host {ESX server} -username {ESX server Administrator} -password {ESX server Administrator Password} -vmware
  5. If the monitored SQL Server instance runs on a Microsoft Hyper-V guest server, the monitored server should be authorized using a SYMCLI command as follows:

    Info
    titleNote

    Only pass-through devices are supported. Devices configured as VHD are not supported.

    1. Make sure you have the Hyper-V hostname or IP address, and Hyper-V's administrator username and password.
    2. Open a command prompt.
    3. Navigate to the directory in which EMC Solutions Enabler is installed.
    4. Execute: SYMCLI\BIN\symcli.exe authorization add -host {Hyper-V hostname} -username {Hyper-V Administrator} -password {Hyper-V Administrator Password} -hyperv
  6. Initialize Solutions Enabler (building the symapi\db\symapi_db.bin file}.
    1. Open a Windows command prompt.
    2. Change to the directory in which the EMC Solutions Enabler is installed.
    3. Execute the discover command:
      SYMCLI\BIN\symcfg.exe discover -all
      This time, "No devices were found" message should be considered an error. If no devices were found, retry carefully steps 1 to 6. If still not found, open a support case using the IDERA community portal.
    4. If your SQL Server instance stores its data on Symmetrix (DMX or VMAX) storage arrays, execute SYMCLI\BIN\symcfg.exe list
      Its output should list all attached Symmetrix storage units. Each of the units that are actually used to store SQL Server DB files should be marked as local in the Attachment column. See example:

      SymmetrixAttachmentModelVersion
      000190103692RemoteDMX3-245773
      000190765393LocalVMAX-15875
    5. If your SQL Server instance stores its data on VNX or CLARiiON storage arrays, execute SYMCLI\BIN\symcfg.exe list -clariion
      Its output should list all attached VNX and CLARiiON storage units.

...

  1. Select a database file that is stored on an EMC sorage array (file size must be > 0).
  2. Open a Windows command prompt.
  3. Navigate to the directory in which the EMC Solutions Enabler is installed.
  4. Execute: SYMCLI\BIN\symrslv.exe file <full path and name of the selected DB file>
  5. The output should contain a table with the following column titles:
    Size, Array, Dev, Offset, PPdevName, Offset, and Attr.
    Array and Dev should present EMC unit and EMC device. If "N/A" is presented instead, then EMC Solutions Enabler failed to map the file. In this case, open a support case using the IDERA community portal.

 

IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal

 

...



Scroll pdf 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


Save