Link to home
Start Free TrialLog in
Avatar of wfcrr
wfcrrFlag for United States of America

asked on

Server RAID card with NAND or no?

LSI LSI00350 (8100-4i) PCI-Express 3.0 x8 Low Profile Ready SATA / SAS Controller Card
LSI Nytro MegaRAID LSI00351 (8110-4i) PCI-Express 3.0 x8 Low Profile Ready SATA / SAS Controller Card - Single

Those cards have 100-200GB NAND

So, what if I build an E5-2600 dual CPU server with one of those LSI Raid cards where the controller has 100-200GB NAND?  Would the one server, if I use Hyper V and then put SQL server in a VM, Web server in another VM, Exchange in another VM, would that be fast?  And, would that be essentially safe from malicious threats, ie, the Web server gets knocked out, but, being virtual, it doesn't take out the whole machine?  And, if I am barking up the right tree, wonder where stuff gets stored, cause I dont' think it gets stored on the LSI....I am still figuring out what I want to do, so, mostly just checking with you guys to be sure I am on the right track.

Or, do I just get 4 SSD's and put them in RAID 10 and not go to the expense of the LSI RAID with teh 200GB NAND?

Or, is there merit to going with a card like this?

LSI MegaRAID 8-Port SAS RAID Controller LSI Logic LSI00202 9260-8i
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Would the one server, if I use Hyper V and then put SQL server in a VM, Web server in another VM, Exchange in another VM, would that be fast? Compared to what and with what load requirements?  

The raid cards are a definite step up from the $2 fake raid controller that comes with the motherboard. The cards mentioned can have 32-128 drives attached to them and have cache memory that keeps the data in case of a power outage. Everything has a limit, disk iops, memory available and throughput, cpu operations per second, network speed and latency.
The new question is where are you going to put these drives and how are you going to power them?

The more VM's on a machine then you are sharing everything on that machine and the more 'computers' you have to manage, patch and maintain. Their just in one box. A power supply failure will take the entire house of cards down.

Everything has its own merits and downfalls. Normally when a website gets hacked the operating system is untouched. The databases attached to the website may be trashed, the web pages defaced.  But the O/S just keeps trudging along.
Avatar of wfcrr

ASKER

Main app is custom app in asp.net and C# and the server drives that code out to client machines.  Server also runs SQL server and the current setup is xeon 3210 with 8GB ram on a RAID5, so pokey. I am figuring out what I want to build to take it's place and the more I look, the more it keeps opening up.  Latest thought is to have SQL server VM'd and have Web server VM'd, if no other reason, simply to keep the attacks on Web server somewhat separated from SQL server and database.

Users are 5 internal lots of reads and some writes, and up to 100 external where those are very light on and off quickly with light read/write.  I think one server can handle that?

I get unclear, though it seems to be getting clearer, how the drives are configured. I am coming to the conclusion I would probably use RAID 10 or maybe RAID 0+1, but that is still fuzzy.

It does seem the NAND on that LSI MegaRAID takes alot of the load off the harddrives, if the vid's I've been watching are leading me the right way.
It does seem the NAND on that LSI MegaRAID takes alot of the load off the harddrives, if the vid's I've been watching are leading me the right way. Caching always does if the information is in the cache.

Latest thought is to have SQL server VM'd and have Web server VM'd, if no other reason, simply to keep the attacks on Web server somewhat separated from SQL server and database.
 Most websites are database driven and therefor you thinking is flawed in this sense, as the database that is connected to the web site can also be hacked using a vulnerability in the website. Other databases on the sql server will in most likelihood remain untouched.

Server also runs SQL server and the current setup is xeon 3210 with 8GB ram on a RAID5, so pokey.  So where is the bottleneck? What makes it so slow? Could it be inefficient code?
Avatar of wfcrr

ASKER

Not sure, there is a ton of code, I counted 77 pages of code to run one "page" on our client machine.  The problem or the lag comes in when there are more than 50 lines that appear on that page....the lines are calculation intensive.  

I have tried putting the database on an SSD, just to see what would happen. Not much difference.

The OS and SQL server and Exchange and really everything are installed on the C partition which is a RAID 5.  Bottleneck has to be that RAID and/or the 8GB of ram.  Ram is always showing as maxed out.  Board only accepts 8GB, so has me in server replace mode.  

Is there something else I should look at for the bottleneck?  How do people go about figuring out where the bottleneck is and how to approach solving problem?

Re-writing the code while that may seem like the thing to do, took 2 years to create this, so, my first hunch is put some new hardware in place with better hard drive setup and more ram and see what happens.  If reconfiguring doesn't help much, then will have to invest mucho denero to rework the custom app.
Avatar of wfcrr

ASKER

Here is a pic and I have a bit of text in the pic with commentary....
2013-03-30-1748.png
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wfcrr

ASKER

Server side, but, you asked the million dollar question, there, buddy.  I don't know why not on the client side. I will ask the developers...

I do know this, in our recent headache, we installed Visual Studio on one client machine and placed all the code on  that machine, testing some stuff, and I notice the app doesn't really run much faster.

I am going to give those guys access to this question and see what they say.....
A data table isn't that much read intensive at least as far as the sql server is concerned. The drawing on the client (being a web page that is delivered to the client can be pokey.. lots of lines of data to be written to the page and then sent to the client.