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 ?