Verified that the strip-size is 64k.

I think for the next few days I am going to try running it as a RAID 5, then move things around, redo the array...

8KB random read and write - 90% read, 10% write ratio

TOT IO/sec: 2245.5

Total MB/sec: 17.6

Average IO Response Time: 7.22

MAX IO Response 153.3

CPU: 30.9

64KB sequential read and write - 90% read,...

You've mentioned this before...

Again as mentioned above this storage array will only be used for data and index files (NO log or tempdb files)

Sorry, I did mean SQLIO - but for these tests I am only using IOMeter.

Results below for RAID 5

MAX IOPS - uses 4KB transfer request size, 100% reads, 100% sequential...

Well this depends...Can you use a linked server? If so, it's quite simple

EXECUTE [YOURSERVER].msdb.dbo.sp_start_job 'TESTJOB'

Running some tests using IOMeter (preferred the GUI to this one over SQLIOsim) and using some of the predefined options here's the results:

ON a 12-disk, RAID 5, 1 hot-swappable spare,...

Yes, this is the option I am going with first (lumping all disks into a single RAID 5 array). I believe keeping one as a hot spare leaves me...

Another quick note on what Charles has offered:

Depending on how many rows these "mini" queries will yield and if you have a beefy server with ample RAM, consider using parameter...

Please supply the execution plan for this exact query

"I know this is a bad query but I don't know why"

Press Ctrl-"M" before running the query, then when it completes you...

I spoke with our Tech Services guy and he said there'd be no issue using a RAID5 with 12 disks, it would give us ample space and yield 11 available...

That should work.

Was thinking to place the 12-disks into one large RAID 5 (so that should leave me with 11 spindles) - I will place Data files and Index files...

90% reads, 10% writes...

Reading a couple of chapters from the link you posted pretty much narrows things down to a RAID5 or 10 (which is pretty much were I got...

Just out of curiosity, how much data is being replicated? Please describe your architecture...for instance, how many articles are in the publication? When you created your publication, what options did...

I've seen this issue when attempting to obtain and execution plan from a procedure that had a cursor/loop in it and it have to process a set of statements several...