Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




19 posts

Geek


# 157582 5-Dec-2014 12:55
Send private message

Hello, I am not sure where to place this, sorry in advance if I have the wrong area of the forum

I am building a new PC that will be accessed by about 5-10 other client PCs for reading/writing

Research:
I have read many articles about this an cannot come to a conclusion on what to use, as I am a beginner embarassed in this field.
Many articles seem to over complicate the system/hardware for what my needs are

Security:
Security is not a big issue for me as all my PCs will have the same amount of access to files on the PC

Type of Reading/Writing:
MSWord, Access, Excel - simple programs which do not take a lot of space and can manage their own
Microsoft SQL Server Management is a requirement on this PC
Management to this PC can be done via Remote

Hardware:
1TB Hard Drive - More than enough storage for small MS office files
SSD - Windows 7 will be installed here, not sure if the SSD is even needed
8GB Ram - There will not be many applications/programs running in the background so this I think is already overkill
Processor - Not sure at this stage, probably going for whatever is cheap
Motherboard - Same as above
Graphics Card - Not sure if I need one, might just get a cheap one for basic things
Power Supply - Needs to be reliable and power efficient, as this PC will likely be on 24/7

What are you opinions on this setup?
Is it bad or wrong to use this PC like any other client PC?



Filter this topic showing only the reply marked as answer View this topic in a long page with up to 500 replies per page Create new topic
 1 | 2
3317 posts

Uber Geek

Trusted

  # 1189299 5-Dec-2014 13:03
One person supports this post
Send private message

I'm not clear what you're trying to achieve. Do you just want this PC to host the files and other PCs read\write files?  If so you would probably be better off looking at a NAS... 

1730 posts

Uber Geek


  # 1189303 5-Dec-2014 13:06
Send private message

It sounds like you want a NAS.  Why not just buy a NAS?

 
 
 
 


xpd

Chief Trash Bandit
10035 posts

Uber Geek

Mod Emeritus
Trusted
Lifetime subscriber

  # 1189318 5-Dec-2014 13:08
Send private message

As he said... if just pure file storage with nothing else, a 2+ bay NAS would be good option.
I was looking at a QNAP TS-453 Pro with 4x 1TB drives for under $2000 I think. 





XPD / Gavin / DemiseNZ

 

Server : i5-3470s @ 3.50GHz  16GB RAM  Win 10 Pro    Workstation : i5-3570K @ 3.40GHz  20GB RAM  RX580 4GB Win 10 Pro    Console : Xbox One

 

https://www.xpd.co.nz - Games, emulation, geekery, and my attempts at photography.     Now on BigPipe 100/100 and 2Talk

 

Emulation - The art of getting your $4000 PC to run an 80's system - and still fails.

 

Add me on Steam




19 posts

Geek


  # 1189319 5-Dec-2014 13:09
Send private message

I forgot to mention one of our software requirements is Microsoft SQL Server Management

Not sure if NAS will work

3317 posts

Uber Geek

Trusted

  # 1189323 5-Dec-2014 13:18
Send private message

ifix4u: I forgot to mention one of our software requirements is Microsoft SQL Server Management


Do you want to run SQL Server on this PC, or manage it from this PC? 



19 posts

Geek


  # 1189325 5-Dec-2014 13:21
Send private message

sidefx:
ifix4u: I forgot to mention one of our software requirements is Microsoft SQL Server Management


Do you want to run SQL Server on this PC, or manage it from this PC? 


Manage and run it from this PC, I will install some Remote Access software so if there are any issues I can manager it from anywhere

I guess what I really would like to know is, am I on the correct way of doing it?

15223 posts

Uber Geek

Trusted
Subscriber

  # 1189382 5-Dec-2014 14:44
Send private message

What kind of load are you talking about? What database size is it? What kind of SQL requests will hit it? Multiple clients constantly requesting files and hitting the database? Just an occasional use file server with the odd database hit?

More information is required to give you any real useful guidance.

 
 
 
 




19 posts

Geek


  # 1189396 5-Dec-2014 15:07
Send private message

timmmay: What kind of load are you talking about? What database size is it? What kind of SQL requests will hit it? Multiple clients constantly requesting files and hitting the database? Just an occasional use file server with the odd database hit?

More information is required to give you any real useful guidance.



SQL Requests: 1-3 clients, not heavy use, only about 5-10mins every hour
Access database: size is 13mb, 1 client
Everything else is probably under 500kb, with a few being 1mb+

I am currently looking at 

http://www.pbtech.co.nz/index.php?z=p&p=WKSPB1458
http://www.pbtech.co.nz/index.php?z=p&p=WKSPB1470A

ECC Ram is not crucial for my needs

15223 posts

Uber Geek

Trusted
Subscriber

  # 1189401 5-Dec-2014 15:20
2 people support this post
Send private message

Your needs are so modest either of those machines will do. That database is so small it will be completely in memory, you could probably run 1000 clients so long as you had appropriate indexes.

Check out the licensing situation, you may need a windows server version if you have many clients access it. I don't know much about that area.



19 posts

Geek


  # 1189404 5-Dec-2014 15:23
Send private message

timmmay: Your needs are so modest either of those machines will do. That database is so small it will be completely in memory, you could probably run 1000 clients so long as you had appropriate indexes.

Check out the licensing situation, you may need a windows server version if you have many clients access it. I don't know much about that area.


This was exactly what I was thinking!

Thank you so much for your opinion ^^ greatly appreciated, these links I am looking at are overkill

JWR

779 posts

Ultimate Geek


  # 1189410 5-Dec-2014 15:37


It is still unclear to me if you are running Microsoft SQL Server 2008 or not.

If you are, then you must run a Microsoft operating system on your server. Windows 7 would suffice.

Microsoft SQL server 2008 would be a very high end solution so few users!

If Microsoft Access is the only database you are running, then you could share that from a NAS or any other system that supports Microsoft file sharing.

I would say that anything from an Intel core i3 upwards would be more than powerful enough to handle the load.

Btw, don't buy a separate graphics card. Just get a CPU that has a built in Graphics Processor.


102 posts

Master Geek


  # 1189416 5-Dec-2014 15:51
One person supports this post
Send private message

Sounds like HP Micro Server territory (http://www8.hp.com/nz/en/products/proliant-servers/product-detail.html?oid=6280789)

You can get it with Windows Server  as part of the bundle (http://www.microsoft.com/en-us/server-cloud/products/windows-server-2012-r2-essentials/) Up to 25 users / 50 devices.

For a small database you can use SQL Express which is free. (http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx)




5400 posts

Uber Geek

Trusted
Lifetime subscriber

  # 1189438 5-Dec-2014 16:00
One person supports this post
Send private message

JWR:
... Microsoft SQL server 2008 would be a very high end solution so few users! ...


Overkill!
You probably need a simple NAS rather than a server.




Sideface


701 posts

Ultimate Geek


  # 1189520 5-Dec-2014 17:19
2 people support this post
Send private message

Re the SQL component...

For that size and usage of database I would seriously consider SQL Azure.  Let someone else manage your backups et al.

The file stuff you could keep local.  If you want to build it yourself there are a few open source solutions.  FreeNas and OpenFiler spring to mind.

1892 posts

Uber Geek


  # 1189717 6-Dec-2014 00:47
One person supports this post
Send private message

nzkc:

The file stuff you could keep local.  If you want to build it yourself there are a few open source solutions.  FreeNas and OpenFiler spring to mind.


FreeNAS is great.  I would not recommend it to anyone on a budget that wants to keep their files however.  You need a proper ECC compatible processor, ECC memory and of course, the board to sit it all with moderate Linux experience before it can be deployed in any small business or enterprise capacity.

Believe me when I say...Budget hardware does NOT play nice with FreeNAS.  It will run, but it will grenade itself eventually.





Sometimes what you don't get is a blessing in disguise!

 1 | 2
Filter this topic showing only the reply marked as answer View this topic in a long page with up to 500 replies per page Create new topic



Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Logitech introduces new Made for Google keyboard and mouse devices
Posted 16-Oct-2019 13:36


MATTR launches to accelerate decentralised identity
Posted 16-Oct-2019 10:28


Vodafone X-Squad powers up for customers
Posted 16-Oct-2019 08:15


D Link ANZ launches EXO Smart Mesh Wi Fi Routers with McAfee protection
Posted 15-Oct-2019 11:31


Major Japanese retailer partners with smart New Zealand technology IMAGR
Posted 14-Oct-2019 10:29


Ola pioneers one-time passcode feature to fight rideshare fraud
Posted 14-Oct-2019 10:24


Spark Sport new home of NZC matches from 2020
Posted 10-Oct-2019 09:59


Meet Nola, Noel Leeming's new digital employee
Posted 4-Oct-2019 08:07


Registrations for Sprout Accelerator open for 2020 season
Posted 4-Oct-2019 08:02


Teletrac Navman welcomes AI tech leader Jens Meggers as new President
Posted 4-Oct-2019 07:41


Vodafone makes voice of 4G (VoLTE) official
Posted 4-Oct-2019 07:36


2degrees Reaches Milestone of 100,000 Broadband Customers
Posted 1-Oct-2019 09:17


Nokia 1 Plus available in New Zealand from 2nd October
Posted 30-Sep-2019 17:46


Ola integrates Apple Pay as payment method in New Zealand
Posted 25-Sep-2019 09:51


Facebook Portal to land in New Zealand
Posted 19-Sep-2019 18:35



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.