on 11-24-2008 10:48 AM
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.
Please use transaction DB02 to check which tables are increasing.
Do you run the housekeeping jobs (button "Default Jobs") in SM36?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.