Avatar of wfcrr
wfcrr
Flag 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
Microsoft Server OSMicrosoft SQL Server 2008RAID

Avatar of undefined
Last Comment
David Johnson, CD

8/22/2022 - Mon
David Johnson, CD

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.
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.
David Johnson, CD

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?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
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.
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
David Johnson, CD

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.....
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
David Johnson, CD

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.