High Utilization is relative so it is hard to give you an exact answer. Are
you talking about 100 trans a sec or 10,000 a sec? Will it be large
transactions or small ones? If all you can have is 8 drives then you are
limited in what you can support. You can usually get by with a Raid 1 for
the OS and potentially place the transaction logs (including Tempdb) on
there as well, just no data files. You can then have a 6 disk Raid 10 for
the user and tempdb data files. Another choice is to have a 4 disk Raid 10
for the user data and a Raid 1 for tempdb data files. But it all depend son
your app and how you use the data. You should test each way to see what
works best under your actual load.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"weaverbeaver"
discussions.microsoft.com> wrote in message
news:BB0D775C-07F1-4115-930D-26EB2B309B2F@microsoft.com...
