Server Size Need Help !!!!

[Former Member]

Hi Experts,

Our current BW database structure is like below:

DB Size - 180,803 MB

Size Used - 180,627 MB

Free - 176 MB

Logical Files used by SQL server are,

DATA1 - Size (66,417) - Used (66,256) - Free Disk (15,014)

DATA2 - Size (55,289) - Used (55,288) - Free Disk (15,014)

DATA3 - Size (59,096) - Used (59,080) - Free Disk (15,014)

Questions:

1. How safe is the current structure? What is the next solution to reduce the risk?

2. We have an existing above BW system , Now we are implementing few more BW projects, for those different projects we will need to load huge data into this BW system. Is it best to have BW on one single server or is it best to have several smaller servers and spread the work across them? How to decide about the new Hardware sizing?

Thanks in Advance,

Sai.

[Former Member · Accepted solution]

Hi,

Increase number of logical files.. DATA1.... DATA9

split table spaces across logical files...

for ODS and CUBES define tablesspaces... and assign those tablespaces while creating cube or ODS

Regards

Ben

[Former Member]

Hi, Sai:

What is your DB, MS SQL or Oracle?

In case huge data will be loaded into BW, you can distribute DB and CI into separate hosts. The DB server is supposed to have enough disks.

If the single CI is not enough to handle the workload, additional DI can be added.