I believe this topic has been discussed before but I couldn't find it
What are pro/con to have both on the same or different servers?
I believe this topic has been discussed before but I couldn't find it
What are pro/con to have both on the same or different servers?
Hi Jake,
The database server typically is paired with the SQL Server installation.
SQL likes fast CPU and memory. Therefore, if feasible, it should be hosted on a server with suitable specs.
The archive server is always moving files across the network (LAN or WAN).
This server benefits from robust I/O and storage (due to the physical file versions being stored here).
Regards,
Joy
Joy Garon wrote:
Hi Jake,
The database server typically is paired with the SQL Server installation.
SQL likes fast CPU and memory. Therefore, if feasible, it should be hosted on a server with suitable specs.
The archive server is always moving files across the network (LAN or WAN).
This server benefits from robust I/O and storage (due to the physical file versions being stored here).
Regards,
Joy
Thank you, Joy
Hi Joy,
Is there any issue to put both on the same server?
Hi Jake,
No - just make sure the server is robust enough to handle the needs of both.
Regards,
Joy
Thank you, Joy
JB
Hi Jake,
The database server typically is paired with the SQL Server installation.
SQL likes fast CPU and memory. Therefore, if feasible, it should be hosted on a server with suitable specs.
The archive server is always moving files across the network (LAN or WAN).
This server benefits from robust I/O and storage (due to the physical file versions being stored here).
Regards,
Joy