Skip to Content
0
Jan 19, 2011 at 07:47 AM

SQL Server auto growth

45 Views

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 ?