Digital Exchange

last person joined: 11 hours ago 

This community is a place to discuss Blue Prism DX assets and development.

Expand all | Collapse all

Database Performance Troubleshooting Queries

  • 1.  Database Performance Troubleshooting Queries

    Posted 07-12-2021 20:45
    This is the beginning of a chat for Database Performance Query Troubleshooting Guide.

    ------------------------------
    David Dinh
    Software Support Engineer
    Blue Prism
    America/Chicago
    ------------------------------


  • 2.  RE: Database Performance Troubleshooting Queries

    Posted 07-13-2021 11:19
    Hi David,
    Is there such a troubleshooting guide?  We continue to have problems with slow queries on Work Queues from the Control Room when searching on Item Key.  It takes upto 25 seconds to search for a single item key.  Contrast that with just a few seconds to return all the matches on a specific status or tag, and under a second to return all of the items with no filters set.  Our database team tell us that no queries are taking more than a few seconds on the database side pointing to something in the Blue Prism code itself that is filtering after the queries are executed.

    ------------------------------
    PeterLacken
    Ren Røros Intelligent Automation
    Peter.Lacken@rria.no
    http://www.rria.no
    ------------------------------



  • 3.  RE: Database Performance Troubleshooting Queries

    Posted 07-13-2021 16:11
      |   view attached
    Hi, this thread was created as I am putting together a general guide so users can offer feedback.  I'm not done yet, but it was not intended for this specific scenario.  However, what you have raised does interest me.  I would think the item key would be super fast.
    How often do you rebuild your index's?  I would check the last time this was rebuilt.  It should be part of regular maintenance.
    I'm uploading some files that my help.  Please see file #4 and #12.
    ​​

    ------------------------------
    David Dinh
    Software Support Engineer
    Blue Prism
    America/Chicago
    ------------------------------

    Attachment(s)

    zip
    SQLServerAnalysis.zip   148 KB 1 version


  • 4.  RE: Database Performance Troubleshooting Queries

    Posted 07-15-2021 07:52
    Many thanks for the input David, We rebuild indexes weekly in a sunday maintenance job rebuilds and reorganizes.  These scripts we have previously aquired from Blue Prism.  It looks like your material in the zip could give us some new things to check so I will share with our DBAs and post the results.  Summer holidays here so maybe Aug / Sept before we close the case :)

    ------------------------------
    PeterLacken
    Ren Røros Intelligent Automation
    Peter.Lacken@rria.no
    http://www.rria.no
    ------------------------------



  • 5.  RE: Database Performance Troubleshooting Queries

    Posted 07-28-2021 12:08

    Hi David,

    To complement the scripts we already use at Blue Prism I also use Glenn Alan Berry's SQL Server Diagnostic Queries. Glenn is one of the finest minds on the planet when it comes to SQL Server, in particular the hardware it is running on. He updates the scripts every month and they are pretty comprehensive, there are different scripts for each version of SQL Server including Azure SQL Database and SQL Managed Instance. Even better Glenn has some supporting YouTube videos to assist with the queries, which are great and he also has several courses on Pluralsight if people have a subscription.

    There is a lot of information in these scripts and as always the benefit is in understanding the results which can be far from easy.

    Regards



    ------------------------------
    Chris McGowan
    Senior Technical Consultant
    Blue Prism
    ------------------------------



  • 6.  RE: Database Performance Troubleshooting Queries

    Posted 07-28-2021 13:50
    Thanks @Chris McGowan!  I will definitely have a look at these.​

    ------------------------------
    David Dinh
    Software Support Engineer
    Blue Prism
    America/Chicago
    ------------------------------



Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support

FAQs

The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.