• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

servers

S

sparks

2[H]4U
Joined
Jun 19, 2004
Messages
3,206
We asked for a big server to be added at work.

Questions they asked us.

what for....
we are doing a lot of computations that take 12+ hrs on our desktops.
data manipulation and analysis of sql databases that require tons of memory.

programs you will be using
to name a few that will be used on the projects....sas, R, sql

any multi processor specific
most state this but who knows if they flick multi core on the compiler or are really written to use multiple processors.

do the programs support or are capable of usage offload to gpu for numeric processing.
unknown


this is just a small idea of what the questions were.

these are the comments we got from IT
after talking to the vendors software and hardware 16 cores and 72 gigs of memory
they said get 2 smaller blades instead of one massive one.
one said gpu in a server is stupid.

is 1 or 2 better?
are there any gpu's in a server?

ps how do you set a program up to offload to a gpu anyway?

So after all this is one or two a better idea?
 
(2) Servers are probably better than one....as long as they are properly configured.

Number of cores, installed RAM, RAID configuration, Storage Capacity, network connectivity, and the software you expect to run are all things IT needs to know or figure out.

The SQL install alone has variables you need to sort out version, cal vs core purchase modeling....etc
 
Ask yourself (or the vendors) why specifically they want two boxes. These are the possible reasons I can think of:

High-availability - one server takes over if the first one fails
Load-balancing - distribute the processing load equally across the two servers
Splitting the SQL Server database from the application server that accesses the database

Which is it? Can you ask your vendors?
 
Thanks for the info

this was my first question to IT and my bosses
Load-balancing - distribute the processing load equally across the two servers
is this the os or the software that will control this.
I got a blank stare.

I said if 2 servers put the application software on one server and the sql server on the other.

Their reply, WHY?

I just thought F it...they don't know but want to blame someone so I am out.

again thanks to everyone for reading and replying.
 
I thought in the server world:

sql needs good throughput performance
calculations need good floating point performance (single or double precision?)

you can get both in one system?!
 
You must log in or register to reply here.
Back
Top