We are going to be moving into a brand new building built to our specifications in the first quarter next year. All the managers have been asked to list all capitol expenses related to the move, which of course translates to wish list. I am constantly being told EPDM is too slow so this would be a good time for me to look at improving the server hardware, switches, software and internal wiring between the server and workstations to increase the speed. I am an Engineer playing the role of I.T. GURU so this is not my area of expertise so I am turning to all you actual I.T. GURU'S that frequent this forum. If you could build the network from the ground up what would you do? What are some things I can change that will increase the access speed?
Thanks in advance for everyone's input!
Jeff
Jeff,
All the hardware that is used in your EPDM environment is important. But first of all is how you install the EPDM software servers (SQL, DataBase and Archive servers).
I think the best solution is to separate software servers on different virtual or real machines. If is possible separate SQL+Database from Archive server on separate machines. It is important because one is database server and the other one is a file server. The necessary hardware resources are different.
Also try to use the machine with SQL and DataBase server only for this don't install any unnecessary software.
The machine used for archive server can be used also as file server but is better if you can use it only for archive server.
As example we use this kind of installation on virtual servers
SQL+DataBase use 2cores and 8Gb RAM
Archive Server (that also is used as file server) 2 cores 4Gb RAM
Our EPDM archive is about 200Gb and the SQL vault database is about 4 Gb
13 users in 2 different locations with a replicated server