Database Performance Troubleshooting Queries
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-07-21 08:45 PM
------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-07-21 11:19 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-07-21 04:11 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-07-21 07:52 AM
------------------------------
PeterLacken
Ren Røros Intelligent Automation
Peter.Lacken@rria.no
http://www.rria.no
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-07-21 12:08 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-07-21 01:50 PM
------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------