If your DB is truly being maintained and is in good health, and you have a good high speed connection from the front end to the back end, there should be no issues with ePO pulling the data and displaying it into your front end query dashboard.
Which then goes to the next question, what queries are you trying to display in the dashboard? The queries themself might be the problem if you are trying to pull tons of information from tables all over the DB. I would start by running the queries 1 by 1 outside of the dashboard to see if there might be a single query that is taking forever to gather the data from the DB. Then to go into it further, you could have your DB admin take the SQL from each query and try running it on the backend to analyze and see what specific data retrieval is taking a long time. Put a check-mark in the query, choose Actions > View SQL.
Attached is a DB guide I put together a while ago specifically for the ePO DB. Have your DB admin go through it and see if there is anything of value for him in there to optimize the ePO DB.
ePO DB Performance v1.1.docx 146.5 K
thanks a lot for providing information. As I wrote that Access/runtime issues appear sometimes for about 1-4 hours. All views and operation in EPO console are very slow in that case. It takes also some seconds more to run a single report or query.
I’m not so familiar with any kind of database administration. But we use an external provider for that services. I’ll forward your documentation to them so that they can check the current maintenance plan. May be they will update some points. And of course I delete all not needed log entries that are older than 3 month regularly.
I hope this hints will solve the problem.
Thanks a lot.
Best regards from Germany
It sounds like there is definitely an issue with a one of the queries. If I were you, I would take a look at each query from whatever dashboard is taking hours to load and edit them to see what data the query is trying to pull and start shrinking that by more specific data or date ranges.
What ePO version are you using? If you export the dashboard that is taking hours to load, upload it to here and I can see about taking a look at the queries within it.
we are using EPO version 5.1.1. But as I wrote all queries are slower if that dashboard issue appear. And on my dashboard are 16 queries configured. So it seems that the dashboard delay multiplys with 16 regarding every single delay. Currently all is OK for now.