Hi Guys, I realize there have already been a few threads regarding this, but our situation might be a bit more scaled than others. We are implementing PDM Pro in several locations (5 sites, 1 in the US, 2 in the EU, and 2 in Asia) and about 100,000 files (30,000 SW) and about 150 users. Does anyone have any suggestions regarding the server hardware required for the archive servers and SQL server. Currently, our IT wants to run the SQL on an instance of a VM that has a lot of other SQL databases running on it, and I am concerned how that may detrimentally affect performance.
SolidworksAdministration
Yes indeed. VMs work for both as long as they are dedicated for it.
We are using Azure VM in our +20 site environment without a problem.
Another vault is using Local VM and no problems either.
Also all archive servers and TASK servers are VMs in our environment now.
Yes, it certainly does. I need to provide IT with some documented/measurable reasons to adhere to that. They do not think that the server is overtaxed.
VM for SQL is fine, but make sure it is dedicated, only instance, and a lot of memory - and a good CPU
Thanks Jim, that should help my IT guys verify the performance of the SQL box.
From SOLIDWORKS | Hardware & System Requirements | SOLIDWORKS
Which reads as ruling out VMs to me.
See S-077012 in the knowledge base for some guidance.