SAP Database Size
I know this question has been asked before, but I still cannot find a solution. We've used SAP B1 for 10 months only and our db size is over 6.2GB! I've read SAP's documentation and I tried shrinking the database, but nothing happens. Here's what I do step by step:
in SQL 2005 Management Studio, I right click on the database, select "Tasks-Shrink Files" (or Shrink Database.. I've tried both). Then I choose either file type as "data" or "log files", leave "RElease Unused Space" and click OK. After few seconds the dialog box disappears and nothing changes.. Same size. I've also tried changing the shrink action to "Reorganize pages before releasing unused space", but the smallest amount I can shrink it to is the current size.
So at this point I need some advice as to what to do. SAP is getting slower and slower each day. Thank you for your help
Former Employee replied
Unfortunately currently there are no archival options to reduce the
Database size in SAP Business One, as a lot of records contain legal
information and therefore cannot be removed/archived.
Below please find 2 possible workarounds
1- Shrinking the database and log file.
Kindly note that usually the log file is bigger that the database. For
more information regarding shrinking, please see SQL Server Enterprise
Manager. Help 'Keyword' - Shrink Database. For more information please,
refer to SAP Note number 548772 and 1002099.
2- Create a new Database and only copy the relevant data from the old
one.
In Terms of large DB (MDF's), in order to verify that the Database does
not hold "Unused space" and holds it in the MDF, you can run maintenance
plan on the database and choose the option to remove unused space from
the database.
If the MDF file is the same size after running the wizard then in terms
of System there isn't much left to do.
In terms of maintenance - it's very important to keep daily\weekly
maintenance jobs (SP_updatestats, maintenance jobs) on Databases,
especially when running large DB size. Note 783183.
In terms of performance - we usually stick to Microsoft's tips on
running and maintaining SQL Server (Using Raid, splitting MDF and LDF
between two physical Hard disks...)
Regards
Vikas
Edited by: Vikas Rastogi on Oct 10, 2008 10:37 PM
Edited by: Vikas Rastogi on Oct 10, 2008 10:38 PM