April 30, 2010 at 10:05 am
Does anyone have information on storage set up for DW/BI? We are brand new to DW/BI on SQL Server 2008. We are a mainframe shop with source data in DB2 Z/OS. We have read many conflicting articles on storage and whether to use RAID 1 or RAID 5 on local or SAN. We also heard in class that you should try to set up EQUAL DEVL and PROD environments as much as possible. Currently, our storage admins want to set us up with PROD on SAN RAID 5 but our DEVL on local RAID 1. It seems to me we would experience significant differences in our performance testing but we are being asked to prove it will be a problem. Anyone have any helpful information? And, if it causes a problem, how difficult is it to change later?
April 30, 2010 at 10:19 am
rbowers 18291 (4/30/2010)
Does anyone have information on storage set up for DW/BI? We are brand new to DW/BI on SQL Server 2008. We are a mainframe shop with source data in DB2 Z/OS. We have read many conflicting articles on storage and whether to use RAID 1 or RAID 5 on local or SAN. We also heard in class that you should try to set up EQUAL DEVL and PROD environments as much as possible. Currently, our storage admins want to set us up with PROD on SAN RAID 5 but our DEVL on local RAID 1. It seems to me we would experience significant differences in our performance testing but we are being asked to prove it will be a problem. Anyone have any helpful information? And, if it causes a problem, how difficult is it to change later?
It's really going to be very dependant on your individual work load and your budget. RAID 1+0 is usually the best for production. In development, usually RAID 5 or RAID 1. Don't worry about development. Your dev disks are local and therefore performance testing will not compare to the SAN. I would disagree with you class that development and prod should be identical. I would say that QA and prod should be the same. I can't ever really think of a dev environment that was a 1 for 1 match of production, it's a waste of resources
As for how to change later, that depends on you SAN Hardware vendor. In many cases you can be seemlessly moved from one array to another.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 10:40 am
I should have mentioned we do not have a QA environment. We use DEV for all testing before PROD.
April 30, 2010 at 10:48 am
Personally, I would still prefer to have more disks in production. Let's say you SAN team will give you 32 total disks. I'd rather have 24 in prod and 8 in dev, than 16 in both.
Really we can't help you here set up your environemnt, it's a matter of budget and knowing your expected workload.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply