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
+1 received by user: 1


Topic # 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
3194 posts

Uber Geek
+1 received by user: 911

Trusted

  Reply # 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... 

1507 posts

Uber Geek
+1 received by user: 782


  Reply # 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
8982 posts

Uber Geek
+1 received by user: 1382

Mod Emeritus
Trusted
Lifetime subscriber

  Reply # 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

 

For Free Games, Geekiness and Reviews, visit :

 

Home Of The Overrated Raccoons

 

Battlenet : XPD#11535    Origin/Steam/Epic/Uplay : xpdnz




19 posts

Geek
+1 received by user: 1


  Reply # 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

3194 posts

Uber Geek
+1 received by user: 911

Trusted

  Reply # 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
+1 received by user: 1


  Reply # 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?

14140 posts

Uber Geek
+1 received by user: 2546

Trusted
Subscriber

  Reply # 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.




AWS Certified Solution Architect Professional, Sysop Administrator Associate, and Developer Associate
TOGAF certified enterprise architect
Professional photographer




19 posts

Geek
+1 received by user: 1


  Reply # 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

14140 posts

Uber Geek
+1 received by user: 2546

Trusted
Subscriber

  Reply # 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.




AWS Certified Solution Architect Professional, Sysop Administrator Associate, and Developer Associate
TOGAF certified enterprise architect
Professional photographer




19 posts

Geek
+1 received by user: 1


  Reply # 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

738 posts

Ultimate Geek
+1 received by user: 236


  Reply # 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.


100 posts

Master Geek
+1 received by user: 9


  Reply # 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)




4247 posts

Uber Geek
+1 received by user: 2489

Lifetime subscriber

  Reply # 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


453 posts

Ultimate Geek
+1 received by user: 82


  Reply # 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.

1888 posts

Uber Geek
+1 received by user: 316


  Reply # 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 »

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:



Geekzone Live »

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



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.