Tablespace usage

[Former Member]

Dear experts,

Please check my quality server tablespace details below.

PSAPPRD tablespace used 98%, what step I have to follow.

Please suggest me.

Thanks & regard,

Amit

[Former Member]

Hi Amit,

From the screen shot I can see that PSAPPRD is 98% used.

Total size = 73GB GB out of which 1.3 GB is still free.

Total extents size = 130 GB out of which 57 GB is free.

As the data files are in auto extend mode system can grow up to another 57 GB. Post which your system can start having problems.

Suggestion

1) Check what is the daily and monthly growth of system to ensure how many days system can run without any problem with 57 GB.

2) Check space of storage where sapdata files are created. Do you have enough space to add new data files.

3) If storage has good amount to free space  and DB growth is higher please add up another 50 GB into PSAPPRD . This will bring down the usage to below 90%

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Dear sir,

1. As its quality server, there is minor growth in database i.e near about 1-2GB in past 4 months.

2. We have 180GB free out of 524GB on physical disk.

3. So does we need to add another new data file ? As AUTOEXTEND option is on so it will have no problem?

Thanks & regard,

Amit

[Former Member]

Hi Amit,

As the DB growth is not that hight, do not add any data file now.

Monitor the growth and take relevant action accordingly.

Regards,

Deepak Kori

[Former Member]

We have 180GB free out of 524GB on physical disk
AUTOEXTEND option is on

Cool..Check your Production from where you copied the data (as part of system refresh, if you did). Ensure you have enough space in Production as well.

Since it is QA system and you have enough partition (you hardly have TS growth), you may ignore this.

You may set an threshold for monitoring if you have option (As said by other techies).

Regards,

Nick Loy