on 01-19-2011 7:47 AM
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 ?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.