Hi guys,
I am currently looking for advice on the best way to improve old servers for a radiology center I recently joined ( software and hardware wise) . I must point out that I am not a professional IT guy but I have always been tech savy ( I do run a small server in my house).
Present configuration of the client ( Software and hardware) :
Software :
The client has 2 major software that he purchased in order to run his business. These are common type of software used in the healthcare industry. The first software is a radiology information system (RIS) which allows the client to record all data about the patients ( personnal information, billing and radiology reports). The software uses mainly an SQL database. The software itself is not very resource intensive but the sql database can suck quit a bit of ram ( I am not with familiar with how SQL works but I think it uses as much as you give it)
The second one is a PACS system, which centralize all the X-ray images from the differents machines ( CT, US, Ultrasound…). This software uses also an SQL database but also stores the images locally.
The stored images are in a very specific format called DICOM which splits the images into very small files ( 1 KB or 512 Kb).
The business uses windows server as it is a requirement for both software to work
Hardware :
The company uses two system : one for the RIS software and another one the pacs sotfware.
RIS hardware : The first one is an old Dell Server ( Poweredge T110) (CPU : E3-1220 V2, RAM : 16 GB DDR 3 ECC, Two 256 TB drives in raid 1 and A 4tb usb HDD for software backup). The whole database size does not exceed 150 GB ( 10 years) )
Pacs Hardware : Dell PowerEdge T340 ( CPU : E-2124 4 cores, RAM : 16 GB DDR4 ECC, HDD : Two 1 TB in raid Raid 1 for OS install and Four 4 TB drivers setup in raid 5, the raid configuration is managed by the dell controller percH330).
The business is fairly small as the first server is used roughly by 10 People and the second one is mainly used by the doctors ( 4 to 6 People at most)
Clients : Around 20 computers ( Some of them are really old runing windows XP but perform light tasks ( generally as a portal for a machine) and some of them fairly recent, dell precision with core I3 processors used for printing and word processing within the ris software.
The whole business runs on a 1GBS network connection.
Problems or annoyances with the current configuration :
-
I am an accountant and my work heavily requires the data from the ris software. When I try to extract data from the software over a long time frame, it takes way too long. However the users working on data that is recent, do not experience any hickup as i think it is stored in RAM.
-
Sometimes the transfer speed to the PACS server from the machines slows down if multiple machine are sending data at the same time and we had issues of images not being sent.
-
Recently, The PACS server reached its had full capacity and i tried to expand the raid array but it is still reconstructing after 1 day.
-
Both servers are painfully slow within windows server, the interface is laggy and takes 30 sec to 1 min to launch a software.
Other Information :
- The Pacs server receives around 6 to 9 GB worth of files everyday. As I previously mentioned, the individual file size ranges from 1KB all the way to 10 MB
-Recently, the client had some issues with its network cabling so we redid the whole thing in CAT 6. Some of the client were negociating at 100 Mb speeds. We also invested in some ubiquiti gear in order to improve the network.
I will be adding a 10 GBE connection to the PACS Server and one of the machines ( CT scans) which generate the heavier files ( Around 1 GB per exam).
-
Backup : The client uses USB drives for backup. However, the backup is managed by the RIS and PACS software and backups 6h after closing. It only backup images and SQL databases
-
The CPU load on both hover around 40 to 60% during heavy use and 2-10% during light use.
-
The RAM usage is around 12 to 13 GB.
Future configuration :
As I see it, I have two options, either change the current servers for a new one or keep the old ones ( Most likely as the owner just splurged on the T340 Poweredge in 2021 and does not want to invest anymore money). Either way, I want to migrate the storage to SSD at least for recent data and setup a proper backup server.
Questions :
Scenario in which we keep the old servers :
-
I was considering Virtualization with proxmox and run both software on the T340. Do you think It ll be able to handle the workload of both softwares with only 4 cores ?
-
Which bring to my next question, I want use ZFS but as I understand it is not natlvely supported by windows. I would either need a different server and setup a network share ( SMB or ISCSI) or virtualization. Do you have any information on how SQL behave with zfs over ISCSI in windows. I heard some things about mismatch sector configuration and asynchornous read and write.
-
In the event that I cannot use ZFS, I would have to stick with raid using the percH330 controller. During my research, I found out that dell servers are very picky about what type of SSD it uses. I was considering using standard consumer samsung EVO sata SSD. Do you have any experience with samsung SSD in dell servers ?
-
Backup : If I go virtualization, I can use proxmox built in VM backup and use R sync for the other data. But If keep windows server as the host OS, what do you guys advise me to do in order to create a full system backup that requires little downtime to restore as these two software are critical.
Would love to hear your thoughts.
Thank you in advance.