We have 6 different divisions that operate independently in the corporation ranging from 10-60 users at each location. Our initial thoughts are to create separate storage groups for each division so that in the event of a restore we don't want to affect everyone. However I'm not sure which is best for performance, maybe have them all together in 1 database.
The question that comes to mind is related to LUN's. We need 1 LUN for each database and 1 LUN for each transaction log storage. Now our initial config is 2 36GB drives mirrored with 2 partitions. {A} being the system and {B} being transaction logs. We then have another 4 disks in a RAID10 for our data storage. If we implement 6 divisions through separate storage groups would they each need a separate LUN for the transaction logs? therefore we would need to create 6 different partitions for logs, 1 for system, and 1 for data?
Any help figuring out our best performance options would be great.
FROGGYJ
A+,N+,CST,CNCT,MCP
The question that comes to mind is related to LUN's. We need 1 LUN for each database and 1 LUN for each transaction log storage. Now our initial config is 2 36GB drives mirrored with 2 partitions. {A} being the system and {B} being transaction logs. We then have another 4 disks in a RAID10 for our data storage. If we implement 6 divisions through separate storage groups would they each need a separate LUN for the transaction logs? therefore we would need to create 6 different partitions for logs, 1 for system, and 1 for data?
Any help figuring out our best performance options would be great.
FROGGYJ
A+,N+,CST,CNCT,MCP