cancel
Showing results for 
Search instead for 
Did you mean: 

Database Size

Former Member
0 Kudos

Dear All,

We are running ECC 5.0 with SQL server 2005, currently database size is 93GB, database sized increased 15GB in last month; please help me to how to check where itu2019s increased in which table

And please let me know how to defrag Data base.

Thanksu2019 & Regards,

Hiten Modi.

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

Please use transaction DB02 to check which tables are increasing.

Do you run the housekeeping jobs (button "Default Jobs") in SM36?

Markus

Former Member
0 Kudos

Hi Markus,

This all following Standard Jobs i m running in my server,please let me know if some thing is missing.

______________________________________________________________________________________

Component Background Job Name Status Job info Rept Name Period Job class

BC SAP_CCMS_MONI_BATCH_DP Compl. JOB FOR MONITORING RSAL_BATCH_TOOL_DISPATCHING Hourly C

BC SAP_COLLECTOR_FOR_JOBSTATISTIC Compl. COLLECT VALUES FOR STATISTICS RSBPCOLL Daily C

BC SAP_COLLECTOR_FOR_NONE_R3_STAT Released NONE-R/3-STATISTIC-KOLLEKTOR RSN3_STAT_COLLECTOR Hourly C

BC SAP_COLLECTOR_FOR_PERFMONITOR Released PERFORMANCE-COLLECTOR RSCOLL00 Hourly C

BC SAP_REORG_ABAPDUMPS Compl. DELETE ABAP DUMPS RSSNAPDL Daily C

BC SAP_REORG_BATCHINPUT Compl. DELETE OLD BATCH INPUT FILES RSBDCREO Daily C

BC SAP_REORG_JOBS Released DELETE OLD JOBS RSBTCDEL Daily C

BC SAP_REORG_JOBSTATISTIC Released DELETE OLD JOBSTATISTIC RSBPSTDE Monthly C

BC SAP_REORG_SPOOL Compl. DELETE OLD SPOOLFILES RSPO0041 Daily C

BC SAP_REORG_UPDATERECORDS Released DELETE OLD UPDATE REQUESTS RSM13002 Daily C

BC SAP_REORG_XMILOG Released DELETE XMI-LOG RSXMILOGREORG Weekly C

WP SAP_WP_CACHE_RELOAD_FULL Canceled WP_RUNTIME_CACHE_RELOAD RWP_RUNTIME_CACHE_RELOAD Daily C

______________________________________________________________________________________

Table name FAGLFLEXA is top growing

Reserved (KB) 11,282,552 Total rows 15,178,337

Data size (KB) 6,650,200 Minimum row size 91

Index size (KB) 4,629,384 Maximum row size 441

Unused (KB) 2,968 Row modification counter 1,641,949

Regards,

Hiten

Former Member
0 Kudos

HI Hiten

Please refer

SAP Note Number 16083 - Standard jobs, reorganization jobs

SAP Note Number 16513 File system is full - what do I do?

SAP Note Number 18307 Batch input logs and reorganization

Also Refer

Top 10 Best Practices for SQL Server Maintenance for SAP

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/sap-top-10.mspx

Hope this will help you ,,

cheers

dEE