cancel
Showing results for 
Search instead for 
Did you mean: 

SQL DB Growing

former_member183087
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Sriram2009
Active Contributor
0 Kudos

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

former_member183087
Participant
0 Kudos

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

Reagan
Advisor
Advisor
0 Kudos

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

former_member193518
Active Participant
0 Kudos

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

former_member183087
Participant
0 Kudos

Hi Benjamin

Thanks this note describes for Basis tables, but the solution we were looking is for the application related tables. Is there any note which describes the housekeeping of application related tables. We are SQL Server.

Regards

Sri

Former Member
0 Kudos

Hi,

Can you please the table name that you have identified as growing ...

Thanks

Rishi abrol

Reagan
Advisor
Advisor
0 Kudos

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

Nicolas
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

http://blogs.msdn.com/b/saponsqlserver/archive/2010/06/28/frequently-asked-questions-we-heard-on-the...

Thanks

Rishi Abrol