Version 1

    A way to troubleshoot:

    1. Edit web.config in C:\inetpub\SolarWinds and change to True

    <add key="HubbleActive" value="False" />

     

    When Hubble is active, it calculates and counts a number of performance related statistics on every page load.

    The first value lists how long in milliseconds it took to load this page.

    The second value lists how many SWIS queries had to run in order to load the page.

    The third value shows the number of business layer calls took place.

    The warnings typically indicates duplicated queries, or long running queries.

    The last figure is the viewstate size - the larger the viewstate, the more will be stored in memory both client and server side, and the slower the page will load.

     

    Click on the "Details" link to drill down and view more statistics about this page load.

    This page will explain in full detail how to read and interpret the detailed statistics: Hubble

     

    Edit web.config in C:\inetpub\SolarWinds and change to False

    <add key="HubbleActive" value="True" />

     

    Help you slow SQL:

    2. Edit SWNetPerfMon.DB to aid slow DB connectibity in C:\Program Files (x86)\SolarWinds\Orion and change (save the file)

    ! Connection timeout in seconds

    Timeout=40

    ! Database Command timeout in seconds

    CommandTimeout=250

    ! SqlCommand.CommandTimeout in seconds

    SqlCommandTimeout=30

     

    3. Disabled unused NICs and unused system services

     

     

    Recommendations:

    Please exclude the following from AntiVirus software:

    “C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto” folder.

    “C:\ProgramData\Microsoft\Crypto” folder.

    "C:\Windows\Temp\SolarWinds"

    “C:\ProgramData\SolarWinds"

     

    SQL database

    Please see the link below for SQL File Segregation

    Separating the data files from the log files in storage can boost performance significantly. The SolarWinds Orion database consists of data files with .mdf or .ndf file extensions, and log files with an .ldf extension. These files exist for the main database and for the temporary (temp) database SQL uses for moving data

    File Segregation --> http://www.solarwinds.com/documentation/Orion/docs/OriondbBestPractices.pdf

     

    ++ Basically we would like to see your SQL database on a RAID 1 for better IO performance ++

    The better your SQL performs the better the overall Orion products will do.

     

    Other Resources:

    How-to Measure Database File I/O Performance and Configure Cloud DB Monitoring

    https://thwack.solarwinds.com/docs/DOC-175542

     

    Database Performance Analyzer Guided Tour

    https://thwack.solarwinds.com/docs/DOC-175527