on 2013 Oct 10 6:16 AM
Hello Experts
We are running SQL Server 2008 Version 10.00.5828.
There is some data which is loaded into particular tables for our cockpit use, due to which the database is growing at 6GB per day.
Than we ran some deletion programs to remove the old data from our tables, though the records/rows are removed the size of the database is not reducing.
Though the row count is decreasing, still the table size is growing normally.
Can you please advice how to handle this situation ? Do I need do DB Shrink to release the space from DB or any other suggestions to fix this issue ?
Regards
Sri
Hi Srikar
1. Check the program takes DB growth? If it is know the program you can enable the trace to find the rout case (using the T code ST12)
2. Every day you have to do the MS Sql Transaction truncate log backup. In MS Sql DB
3. During the off-peak time you can run the DBCC check by using the SAP Note 142731 - DBCC checks of SQL server
4. Carry out the DB compression as mention in the below SAP Note
1488135 - Database compression for SQL Server
5. Kindly refer the SAP
1660220 - Microsoft SQL Server: Common misconceptions
1744217 - MSSQL: Improving the database performance
Thanks
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All
Thanks for the inputs, we are using particular tables for our solution in ERP/SCM system. Wanted to know how to housekeep the particular large space consuming tables. Is there any procedure to do that ?
Regards
Sri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It depends on what tables they are. If they are BASIS tables then read this SAP note
Note 706478 - Preventing Basis tables from increasing considerably
Regards
RB
Hi,
This note is not necessarily specific to your scenario, but it's got a very useful attachment.
https://service.sap.com/sap/support/notes/1422822
Regards,
Darryl
Hello
Deleting the contents of a table will not reduce the size of the database.
You probably need to read this before doing something.
http://www.straightpathsql.com/archives/2009/01/dont-touch-that-shrink-button/
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srikar,
Please read this blog
http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/
before shriking your data files. You have to know that the shrink operation fragments the index. As this blog describes: "The data file shrink also generates a lot of I/O, uses a lot of CPU, and generates *loads* of transaction log..."
Best regards,
Nicolas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In MSsql once you delete the data you need to shrink the database.
can you please let us know which table and what functionality is used in that sap system.
Is it solman system?
Please read the below blog.
http://technet.microsoft.com/en-us/library/ms189035.aspx
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.