Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
netjam
Starting Member
37 Posts |
 Posted - 2008-03-06 : 21:37:37
|
| I was informed (by Microsoft) that for all SQL Servers prior 2008 recommended (or must) stripe size is 64kDoes anyone knows full set of settings that must be applied whensetting up raid 5 for sql server boxThanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 22:03:03
|
| That applys on raid for db data and log files, you can use bigger stripe size for os and binaries. |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-06 : 22:03:07
|
I recall that it kind of depends on the volume and size of the "traffic" that will be passed to the hardware in terms of KB size of reads/writes. I may just be tweaked from the coffee though. To be honest, I am not sure.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
netjam
Starting Member
37 Posts |
Posted - 2008-03-06 : 22:29:32
|
| The person who gave this tip is not just another Microsoft support guy. But one of the production managers of MS VS.There was no mention of size of the data or else... It was like a rule, in order to increase sql performance. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-06 : 22:40:36
|
I am not sure why you wouldn't trust Microsoft managers. After all, only one of them is part of the class action suit regarding Vista logos since he bought a 2,100 computer that was "Vista Capable" but really wasn't.As I said, i don't really know for sure on this one....just a recollection that "it depends"
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
Raid Controller - Stripe Size