We have dozens of very complex workflows, hundreds of variables and around a hundred users in our Enterprise PDM system. We have started to see slow performance in database actions (transitions, data card updates, right click responsiveness, saving workflows, etc.). Our database size is around 17GB (i know its big) and unfortunately it will continue to grow. My question for you all is what hardware upgrades should I look to invest in to help with the slow database performance. We have very stringent maintenance, backups, reorders and indexing in place and the DB is not fragmented in the least. We just have overly complex workflows with hundreds of automatic transitions, tasks, etc. that is leading to a large DB. I do have a case open with our VAR and they are looking over our logs and coming back with a course of action but I am just curious what some of the larger users of EPDM do with larger DB sizes.
Current Hardware we have on our SQL Server
Intel Xenon CPU E5-2640 v3 @ 2.60GHZ
32 GB RAM