How to Check out the Size of a Client??

[Former Member]

Hi Guyuz

I hope you guyz doin great

Please let me know how to check the Size of a Client a short process??

Thanx a lot

Regards

Javed

[Former Member]

Hi,

Run client copy in test run

Regards

Umesh k

[yuezhi_zhao]

Hello Javed,

I think the easiest woul be implement the note 118823 in your system and run the report RSSPACECHECK. The note 118823 is valid till basis 640.

Regards,

Joe

[Former Member]

Hi Joe,

I'm using Ecc6 and i tried this dint got the out put

Regards

Jawed

[yuezhi_zhao]

Hello,

Have you tried the report RSTABLESIZE and enter all tables as stated in note 118823?

Regards,

Joe

[Former Member]

Hi Joe,

Yes I tried but its showing only Transparent tables (USR02)

when i tried T000, TSTC, TACT no output

Thanx for your help

Regards

Jawed

[yuezhi_zhao]

Hello Jawed,

You should enter '*' in the table name to display all the tables in one client. Note 118823 also stated that. Please be advised that thsi might take a while though to give the final result.

Regards,

Joe

[Former Member]

Sure Joe will try this on Sandbox

Regards

Jawed

[yuezhi_zhao]

Hello Jawed,

If you enter '*' in the report, it will show requires space in KB and the number of the tables. As for eh question regarding the non-transparent tables, please find the corresponding part in note 118823:

'The reports have a problem in principle with tables that are not stored

transparently, but as POOL or CLUSTER tables. This data is heavily

compressed, and the results of the reports are clearly too high as a

result. The tables in question are mostly found in areas of the database

that have corresponding names, such as PSAPCLUD or PSAPPOOLD and so on.

Examples are: POOL table ATAB, CLUSTER tables RFBLG and AABLG.'

Regards,

Joe

[Former Member]

Hey Joe

That was the good info

got stuck with some other thing one of our Client is Planning for Ms-sql2000 to Sql2005 Upgrade it's on 32 bit they have ecc5. if you have any documents(not Intguides) from market place some thing else like screen-shots please do let me know

thanx for your time and help

regards

Jawed

[yuezhi_zhao]

Hello Jawed,

Sorry I know almost nothing in SQL server area. Maybe you can try the SAP on SQL SERVER forum.

Regards,

Joe