Slow load time, not responding, large database?
I have a VM running Server 2008r2 and I am having some very slow load times in PDQ Deploy Pro.
When I first open the program, it can take 30 seconds to a minute to open, and if I click anywhere, the splash screen will white out and say "Not Responding". Any selection on the left side can take 5-10 seconds to load, and the window will say "Not Responding" frequently in between transitions from one page to another.
At first I thought I just wasn't allocating enough resources, but I have now given 4 cores, and 12GB of RAM to this VM, and I am still having these problems.
I read on another post that it could be because of a large database. The people on that thread said their database was 300KB, but I just checked mine and it is 300MB! What do I need to do to clean up this config and speed things up?
Thanks in advance for help!
Comments
*** Note ***
Worked with the customer on a support ticket for this issue and it looks like this might have been related to the amount of deployment history that was being saved and caused the database file to grow much larger than normal. Awaiting customer feedback to make sure this was resolved by reducing the cleanup setting in preferences.
I also have issues with GUI being very little responsive. It have been like this for ages. My PDQ deploy DB is only 4MB! (have many deployments, little history)
It just feels very sluggish to work with.
It also seems to get a little worse over time. Just restarting the application helps a bit for a while.
But both Deploy and Inventory are extremely slow compared to all other software we are running.
They are also running in a VM (ESXi 6 now).
Currently win 2012R2 was just the same with win 2008R2.
Have also tried to give a lot of CPU, memory and Video ram without it helping any.
This is a dedicated VM that just runs AA. Every other program seems responsive (IE, device manager and so on).
I suspect Deploy and Inventory somehow is graphics intensive....?...
Running Deploy and Inventory on a MS SQL server and creating a proper service serverside and separate consoles for the clients would probably help?...
@Espen
Have you performed a database optimization? Preferences --> Database --> Optimize Database.
Multiple times Colby.
It does not matter. It just runs slow when it runs in a virtual environment. Always has.
I suspect it has to do with graphics/drawing.
So I have really been looking forward to the release of a client/server console.
Installed version 13 Beta 4 today, and voila, it works perfect now. Suggesting the database never was the problem.
(The server runs on the same machine as always). Just installed the client on my local workstation. This is now a dream to work with compared to before.
This was maybe not the point with the client/server feature, but it really helped me. So if you read this Jason Knellinger, I suggest you try the beta, or wait for the final release, and set up client/server.
Point is to run the client on a decent computer that can handle some graphics.
Thanx guys!.