Go Back   Computer Forums > General Computing > Server Administration
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 04-02-2018, 02:24 PM   #1
Beta Member
 
Join Date: Apr 2018
Location: United States
Posts: 2
Default New server suggestions

I work for a flooring company with around 200 employees, around 50 at my location. The company currently has a MS Sql database running our main program, and a second online database through Quickbase, which we are duplicating the data to manage workflow and reports.

We are currently having lag issues at my location due to distance from main office and are thinking about adding a server at our location. The server would be used to run the main program, and possibly to create a second program that will utilize the main database, and only accessed by the people at my location (around 50 people).

Does anyone have any suggestions of what servers we would need?
__________________

__________________
apryls82 is offline   Reply With Quote
Old 04-03-2018, 09:12 AM   #2
In Runtime
 
Join Date: Dec 2012
Location: USA
Posts: 496
Default Re: New server suggestions

You probably won't like this answer, but it may be more cost effective to spend that money upgrading the internet link between the two locations. getting a fiber line, or 2nd fiber line to increase throughput and decrease latency.
__________________

__________________
CPU: Ryzen 1700 GPU: MSI R9 480 4GB
RAM: 16gb DDR4 Disk: 128SSD + 2x1TB
Power: 750w asus prime b350m-a uatx mobo
Cortb is offline   Reply With Quote
Old 04-10-2018, 02:13 AM   #3
In Runtime
 
Join Date: Jun 2015
Location: United States
Posts: 115
Default Re: New server suggestions

Unlikely latency would decrease any unless the pipe is full between the two locations... Even then, there's no guarantee that would help unless all connections between are working properly, which usually isn't the case.
__________________
C0RR0SIVETF is offline   Reply With Quote
Old 04-11-2018, 08:22 AM   #4
..m.0,0.m..
Site Team
 
iPwn's Avatar
 
Join Date: May 2010
Location: USA
Posts: 3,918
Default Re: New server suggestions

As an ex-DBA, there are about 50 billion questions here.... okay not that much, but it's not as simple as you think.

First, adding a second server at your location may help, but your database replication is going to cause the same issue you're running into now. If you mirror the databases, both servers have to acknowledge the transaction before the transaction is committed.. so if there's "lag" as you say, adding a server at your location and mirroring data will only make that worse. Plus, what happens when the connection drops and both location are inserting/deleting records? So the program itself needs to operate autonomously from the main DB and allow for transactions to be reconciled following an outage. SQL Server has all kinds of cool stuff to do this, but simply adding a server isn't de way.

In line with Cortb's response, it would be worth maxing the connection out and testing your throughput from A to B. Try to clear up, improve, etc that connection. If it's slow, and you add a secondary server... it will just compound the problem.
__________________
Me: You'd think as the dominant species we wouldn't be so effing stupid.
J: We're just intelligent enough to be completely effing stupid.
iPwn is offline   Reply With Quote
Old 04-11-2018, 11:03 AM   #5
In Runtime
 
Join Date: Dec 2012
Location: USA
Posts: 496
Default Re: New server suggestions

This might be something to look into as well if your main link is saturated:

https://itel.com/ltt-bonded/

It is capable of doubling or tripling the internet speed by bonding two links together.
__________________
CPU: Ryzen 1700 GPU: MSI R9 480 4GB
RAM: 16gb DDR4 Disk: 128SSD + 2x1TB
Power: 750w asus prime b350m-a uatx mobo
Cortb is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 11:01 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0