database space problem during EHP4 installation

[Former Member]

hi every body

actually i am upgrading my sap to EHP4 on DEV,

my space assigned for MS SQL database is 125 GB(60gb free) on Windows 2003 ,

but at the preprocessing stage in EHPi it shows error that system needs 108GB of free space on database but i have only 60 .

can any one tell me how is it possible to do this i am stuck here .

[former_member204746 · Accepted solution]

simple.

add a new disk then add a datafile on it.

[Former Member · Accepted solution]

Eric,

I've a doubt here. I've come across a SAP note saying that for better performance in SQL database, we should atleast have 1:1 CPU count as that of the datafile count.

If this is the case, we cannot go on adding new datafiles (if we have limited CPU count, say 4) but we should extend the existing datafile or the drive/FS size.

Please correct me if I'm wrong.

Regards,

Varadharajan M

[markus_doehr2 · Accepted solution]

> I've a doubt here. I've come across a SAP note saying that for better performance in SQL database, we should atleast have 1:1 CPU count as that of the datafile count.

This is a rule of thumb and not a requirement, you can safely add a new file.

Markus

[Former Member]

thank u all

[markus_doehr2]

The space estimation is done on a calculation of your source system. The shadow instance will be built out of a number of tables from your source instance.

You have to provide that space, otherwise you can't proceed.

Markus