cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server auto growth

former_member105092
Participant
0 Kudos

Hi folks,

In the SQL Data files, when the free space is very less, the server became very slow. Even login also taking very huge time. I have 10% auto growth.

The issue is ... even 300 MB free space is there .. the server became very slow. The 10% auto growth will trigger once all the space is consumed ( I assume ). Till that, I cann't wait, because the server performance is very bad.

My question is .... If I keep the threshold for 1GB for free space? ( once the auto growth 10% = 3 GB for example ).. By continuously using the Data file meet the threshold of 1 GB free space and it trigger the auto growth 10%. So 1GB free space will provide the better performance of the SQL Server 2005.

Is there any option like threshold to keep the free space of 1 GB ?

Accepted Solutions (1)

Accepted Solutions (1)

clas_hortien
Active Contributor
0 Kudos

Hello,

the SQL Performance has nothing to do with the free space in the files.

You should open an OSS message when you want to get the bad performance analyzed by SAP support.

Best regards

Clas

former_member105092
Participant
0 Kudos

I already raised OSS msg. There is no more option like that.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can make the free space by increasing database file space.

Run SQL Interpese manager->go to Database (sid)-Right clickgo to propertygo to file.

Here you can increse the space in all database file.

Be sure, that free sapce should be in HDD.

Regd, Santosh Kumar Shakya

former_member105092
Participant
0 Kudos

This is manual type . Now I am doing the same way only. Am asking any automated process is there ?