Rig Recommendation For Company

[lussypicker]

i'm building a Rig for Running Accounting Software (SQL) which will be the main PC running up to 10 users.

Intel i7-7700
Asus Z270F
GSkill RipjawsV 2 x 4GB
Asus GTX 1050 Pheonix
Samsung 850 Evo 250GB
WD 1TB
PSU i'm not sure

is this rig overkill?

 

[Ark Law]

Building for company why DIY? Should get via commercial means from vendor

 

[evildoctor]

Get a Server?

i'm building a Rig for Running Accounting Software (SQL) which will be the main PC running up to 10 users.

Intel i7-7700
Asus Z270F
GSkill RipjawsV 2 x 4GB
Asus GTX 1050 Pheonix
Samsung 850 Evo 250GB
WD 1TB
PSU i'm not sure

is this rig overkill?

 

[lussypicker]

Building for company why DIY? Should get via commercial means from vendor

you mean buying from Dell or Acer those kind? i'm currently using Acer but it's running really badly. any reasons why?

 

[lussypicker]

Get a Server?

too expensive we're just a small startup company.

 

[86technie]

you mean buying from Dell or Acer those kind? i'm currently using Acer but it's running really badly. any reasons why?

Specs plz.
Consumer grade desktop from Acer that is using Intel I series
SQL performance is quite sluggish.
Not to mention I suppose this desktop is using i3/i5 with
little ram?

If SME or startup, two ways:
IMDA got funding for SME to tap on ICT funding but that
one you have to check.

Second SQL server proper one usually will not be cheap.
The only way if you want to consider a vendor to host
it instead of you hosting it.

Despite it maybe cheaper but the control and data is at
the vendor discretion also.
You save cost on manpower since it is vendor handing the server.

How much will it cost, best to call up web hosting vendors and check.
Doubt here anyone can advice or disclose pricing since it varies.
Hope this helps.

 

[lussypicker]

Specs plz.
Consumer grade desktop from Acer that is using Intel I series
SQL performance is quite sluggish.
Not to mention I suppose this desktop is using i3/i5 with
little ram?

If SME or startup, two ways:
IMDA got funding for SME to tap on ICT funding but that
one you have to check.

Second SQL server proper one usually will not be cheap.
The only way if you want to consider a vendor to host
it instead of you hosting it.

Despite it maybe cheaper but the control and data is at
the vendor discretion also.
You save cost on manpower since it is vendor handing the server.

How much will it cost, best to call up web hosting vendors and check.
Doubt here anyone can advice or disclose pricing since it varies.
Hope this helps.

best option is to find a hosting vendors? because we have been using our own computer as a server, therefore we thought this would be the best option. how long does it take for IMDA to process through?

 

[86technie]

best option is to find a hosting vendors? because we have been using our own computer as a server, therefore we thought this would be the best option. how long does it take for IMDA to process through?

If you want cost effective, yes get a vendor to do the hosting
since they have their own team managing the server.
Thus you will save on labor cost to manage the SQL server
as well as hardware.

SQL unlike excel program is a rather intensive program,
typically not run on consumer desktop but workstation/server
with Intel Xeon processors.
How long it takes to apply to IMDA that I can't advice.
You will have to check with them on the ICT funding for startup.
Hope this helps, cheers.

 

[lussypicker]

If you want cost effective, yes get a vendor to do the hosting
since they have their own team managing the server.
Thus you will save on labor cost to manage the SQL server
as well as hardware.

SQL unlike excel program is a rather intensive program,
typically not run on consumer desktop but workstation/server
with Intel Xeon processors.
How long it takes to apply to IMDA that I can't advice.
You will have to check with them on the ICT funding for startup.
Hope this helps, cheers.

oh bro! i think you misunderstood me, my SQL is an accounting software. it's not the SQL website programming thingy.
https://www.sqlsmesoftsg.com/

 

[86technie]

oh bro! i think you misunderstood me, my SQL is an accounting software. it's not the SQL website programming thingy.
https://www.sqlsmesoftsg.com/

Even the vendor have PIC schemes that I think you can call them to check
and also about the software sluggish issue.

https://www.sqlsmesoftsg.com/copy-of-support

 

[lussypicker]

Even the vendor have PIC schemes that I think you can call them to check
and also about the software sluggish issue.

https://www.sqlsmesoftsg.com/copy-of-support

will do bro. btw, why buy Consumer grade desktop instead of diy? we did it at first cause of convenience. spoil liao just bring back and repairs. but the specs are so bad with i5 and minimal rams.

 

[86technie]

will do bro. btw, why buy Consumer grade desktop instead of diy? we did it at first cause of convenience. spoil liao just bring back and repairs. but the specs are so bad with i5 and minimal rams.

Mainly of the "After sales support"

DIY - Individual parts support from various distri and you need to
bring the parts that is deem spoilt to the distri for RMA.

Branded - Onsite support for business models desktop/notebook along with three years
warranty. Anything just lodge a call they will come down.
This will minimize disruption to your business especially time off
just to take the PC down to service.

Certain consumer model have onsite support but that you have to check with vendors regarding it.

Of cuz if you wonder about pricing, DIY will definitely be cheaper than
branded since there is no "After sales support." agreement.
i5 is consumer grade/gaming grade CPU not really intended for SQL/
database server.

The cheapest desktop is a workstation with Intel Xeon E3 processor.
Like Dell 3620 (Costing around $2-$3k depending on configuration).

http://www.dell.com/sg/business/p/precision-t3x20-series-workstation/pd?~ck=anav

Beyond this model, the mid range can easily cost near $5k.
Business have three years onsite warranty, anything just log a call.
Hope this helps.
Cheers.

 

[ronnie_gogs]

DIY for running a SQL server can be quite risky.

For running any SQL servers I would always recommend something which can handle ECC ram. Normal consumer Kaby lake cant handle ECC ram. Xeons can and this is why they are industry standard. The new Ryzen does support ECC RAM but they are definitely not stable for me to recommend.

For budget
https://www.asus.com/sg/Motherboards/P10S-M-WS/specifications/
https://www.asus.com/sg/Motherboards/P10S-M-WS/specifications/

Should have something called Asus server care.
https://www.asus.com/sg/support/FAQ/1008384/

And Xeon E3-1230 v5
http://ark.intel.com/products/88182/Intel-Xeon-Processor-E3-1230-v5-8M-Cache-3_40-GHz

No need of graphics card. Integrated is perfectly fine for running a SQL server.

Any good PSU should be fine but buy a UPS so that data is not lost in case of any power issues.

RAM depends on number of users. 8 Gb maybe a bit too less for 10 users.
But only ECC is my recommendation.

Saw this combo in cybermind Sim Lim but can look for better prices.
http://www.cybermind.com.sg/pdf-upload/pricelists/cybermind.pdf

 

[darkarn]

Wondering about all these too; why would an i5 not suited for such applications unlike the Xeons (assuming same clock speed, threads e.t.c.)?

What instructions are the i5 missing that the Xeons don't?

 

[86technie]

Wondering about all these too; why would an i5 not suited for such applications unlike the Xeons (assuming same clock speed, threads e.t.c.)?

What instructions are the i5 missing that the Xeons don't?

Architecture difference,
Xeon E3 have 4/8 unlike some i5 is 4/4, xeon intended for 24/7
and etc.

 

[Ark Law]

Consumer barang barang you pay more for product features and speed

Commercial barang barang you pay more for product features and speed of service delivery

 

[ronnie_gogs]

Wondering about all these too; why would an i5 not suited for such applications unlike the Xeons (assuming same clock speed, threads e.t.c.)?

What instructions are the i5 missing that the Xeons don't?

Its can run fine its not about the processing power its about the right tool for the job. Consumer grade parts at home spoilt like motherboard, ram, gfx card I will lose a few games and photos and if data corruption happens no big deal. Walk to service centre RMA it and install back.

If SQL accounting data corruption happens which can do a lot more damage and where you cant afford to wait around. Say you are small company but with revenue more than 5 million then you have to get accounts audited. What if the data was corrupted causing you serious issues even legally. Multiple scenarios can be there which is why companies spend so much on IT.

My suggestions although still DIY is still cheaper than original post

 

[darkarn]

Architecture difference,
Xeon E3 have 4/8 unlike some i5 is 4/4, xeon intended for 24/7
and etc.

I see, so maybe a more fair comparison is i7 against the Xeons, but still, thanks for pointing out that Xeons are for 24/7 (I know many people who still leave their i5/i7 computers 24/7 though )

Its can run fine its not about the processing power its about the right tool for the job. Consumer grade parts at home spoilt like motherboard, ram, gfx card I will lose a few games and photos and if data corruption happens no big deal. Walk to service centre RMA it and install back.

If SQL accounting data corruption happens which can do a lot more damage and where you cant afford to wait around. Say you are small company but with revenue more than 5 million then you have to get accounts audited. What if the data was corrupted causing you serious issues even legally. Multiple scenarios can be there which is why companies spend so much on IT.

My suggestions although still DIY is still cheaper than original post

Good points there. wasn't that aware about corporate IT before, thanks!

 

[shsh91]

I will recommend

Form factor 1U Server
Xeon E3-1230 V5
Supermicro SYS-5019S-MR
8GB DDR4-2133 ECC DIMM
2x Intel S3520 150GB SSD (Raid 1) <-- shortage may need to use 240GB PM863a SSD.

This setup has RAID 1 for redundancy and also Redundant PSU.

 

[davidktw]

I see, so maybe a more fair comparison is i7 against the Xeons, but still, thanks for pointing out that Xeons are for 24/7 (I know many people who still leave their i5/i7 computers 24/7 though )

That would have been a superficial comparison between the consume grade i5/7 core chipset versus the xeon chipsets.

The major difference between Xeon chipset and the rest is the capability to have multi sockets within the same motherboard. Another is that only Xeon chipset support ECC memory which are necessary for mission critical systems. Xeon also have longer longevity compared to i7. When it comes to in-chipset cache, xeon chips are designed with more.

I guess other than those obvious differences, when it comes to durability, one can only find out if putting 2 systems one i7 and one Xeon side by side in a data centre for testing. Unfortunately I think they would be hard since we uses rack form factor in data centres and these enclosures are design rather differently from the pedestal form factor, and so for durability, everything from airflow and vibrations and so forth comes into play, but I have not really come across 1U rack server boards that will accommodate i5/i7 chipsets.