Implemented

The new DPA Find SQL feature allows you to search for a SQL statement based on the sql statement itself and then have that query analyzed.

Select Any Hash

Can the View Historical & Analyze Query drop downs in the trends view be changed to allow a user to enter a Hash/Name not shown in the list?. They default to the top 15 but there are situations when i want to view this information for a hash not shown that i'd like to type in (and i don't really want to include possibly 100's more in the view). This might also be usefull in the similar options in timeslice charts.

thanks

spaceman
  • in reply to spaceman

    I'm glad you found a workable solution for now.  I have voted this one up myself.  Nice suggestion spaceman.  And nice workaround gcp!

  • in reply to gcp

    Nice workaround.. doesn't work for named hash values directly (just need to translate bcak from the name to the hash) , but i can live with that!

  • Just as a workaround, select any random sql from the dropdown list, then look at the URL in the link. You'll see the SQL number in it (5434817476 in this case):

    DPAServer:8123/iwc/sqlDisplay.iwc?embedded=1&repo_id=1&db_id=14&cs=1&sql=5434817476&pm=P

    Edit the URL to use the SQL hash you are interested in (3511078771 here):

    DPAServer:8123/iwc/sqlDisplay.iwc?embedded=1&repo_id=1&db_id=14&cs=1&sql=3511078771&pm=P

    Enjoy the pretty graphs emoticons_happy.png (may not work for all hashes, but should be OK for anything in recent history)

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.