SQL Server hardware configuration

Take a look here: http://www.mibuso.com/forum/viewtopic.p ... light=raid

Regards

fileformat pptx #-o
why not pdf :?:

tzzzzzzz

If you have more than 2 drives, RAID1 won't cut it, so the logical choice for 4 or more would be RAID10 (unless you split up the log file across multiple drives). I don't know if you can say "RAID10 is always better than RAID1 though, that seems like too much of a generalization.

Well for starters, what does 'better' mean? Better for the environment? Better for performance? Better for budget reasons? Better for what?

Then it depends on the situation whether RAID1 or RAID10 is more suitable. If you have a limited number of spindles at your disposals you might want to choose more disks for the data files, or maybe there are other reasons.

My point is that you first need to analyze the situation before making a statement about what is 'always better'.

Seriously without knowing your system NO ONE not any expert can make hardware recommendations. If you have decided on a $1,000,000 budget for the server, then YES RAID 10 is better. But if (like 99.99999%) of companies in the world, the client is working to some budget, then its necessary to look at every aspect of the system, and balance it out. For example if they have a RAID1 with 2 drives, and a RAID 10 with 8 drives, then you would put the DB on the RAID 10 and the LOG on the RAID1. So in this case clearly RAID1 is FAR worse for the log file.

Also how much RAM do they have? What TempDB do they have? How many CPUs? Imagine that you had to choose between 4 drives in RAID10 Log file and 2 Gig ram, or 2 Drives in RAID1 Log and 16 Gig of RAM. Which is better?

Please let us know the full story, because ANY expert that gives expert advise without knowing your needs, is not an expert.

Also, in my very humble opinion, the single best value for money investment you can make in your SQL server, is getting a NAV SQL performance expert to come in and tune the database. That money will ALWAYS give you the best ROI. And there are a ton of them on this forum that can help.

(Sorry about this post :oops: I know its a little bit angry, but please people, every system is different, and what works for one system may not apply to any other.)

davmac1 wrote:

What is interesting about all the posts is noone picked up on the hardware portion - according to Dell, you cannot implement a single hardware RAID volume on two ports.

I am pretty sure that most of us have delt with IBM, HP nad Dell. My gernearl experinece with them when asking for a complex Hardware configuration is:

IBM "You just let us work out the hardware...that's our job"
HP "You want what?... hmmm now that sounds expensive..."
Dell "Say what? No way ... that's impossible"

My experience with Dell is that you need to talk to three or four reps before you find one that can give you the correct answer. Of course it may well be impossible, but you do need to ask a lot of people before you can be sure.


Oh by the way, I have a client with a rather large database, because of the way their NSC advised them, they have their LOG file split over 8 drive arrays. & of the arrays are for decoration, and one of them does all the work. In the mean time they have another 8 arrays for the DB that area all at 100% capacity. In their case, the better configuration would have been 15 arrays for the DB, and one for the LOG file. This is one example why more drives for the LOG file is not faster.

Hm, that's strange... .

I got the same problem. Actually, it's a pptx file, but it's downloaded as a .zip.

renaming the file from .zip to .pptx does the trick.

What's the cause? I don't know ...

I thought you would say ... iFacto, here I come

Waldo wrote:

I thought you would say ... iFacto, here I come

vanrofi wrote:

never say never again.
Problem is that Love and Business is a dangerous cocktail :-s

Too much information guys