on 08-28-2014 1:42 PM
Hello All,
We are planning to perform database shrinking for both BW test and prod system.
The test system database size is around 50 GB and is sitting on 4 disk which is in total of 240 GB.
Same is the case with BW Prod system which is of size 170 GB sitting on 8 disk which is in total 720 GB.
Checked the database growth for
Test in last 5 months is on average 3 GB and for PROD it is around 4 GB per month.
So what would be the correct disk size we should leave for both the system after shrinking?
Regards,
Mohit
Hi Mohit
Kindly check the free space in database by using the transaction code ST04, then perform the shrink action during off peak time.
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mohit,
Why do want to shrink your database?
If you have enough free space on your system, your DBAs will not have to worry about lack of space.
If you system is running on database SQL Server, check the following website:
http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/
Regards,
Eduardo Rezende
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohit
In which version MS Sql server ? If you arr in MS Sql 2008 R2 you can compress the database.
Kindly refer the SAP Note 1488135 - Database compression for SQL Server
BR
SS
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.