SQL database expansion

aleix1979 · 2006-09-21

Hi,

I have speed problems because my SQL database is at 95%. I have it with Unrestricted Growth and 10% File Growth.

In the Installation manual it says that when the database expands, it will do it by this 10%. But.... do you know when it will trigger this expansion?

Regards,

:bug:

kriki · 2006-09-21

95% full in SQL will not create performance problems.
SQL will trigger it when it needs it, it is impossible to predict it. You can do it manually with File=>Database=>Alter and altering the sizes.

Check the topics for possible reasons of performance problems.
Some examples:
-No good SQL statistics
-No Re-indexing of the tables in SQL
-RAID5
-Etc...

DenSter · 2006-09-21

SQL Server will kick off the expansion when you least want it to happen. It is better to expand manually during off hours.

kriki · 2006-09-22

DenSter wrote:

SQL Server will kick off the expansion when you least want it to happen.

One of the consequences of Murphy's laws

soopervoice · 2006-09-23

If you have performance problem in SQL server, check the SQL Server log file size.. and try to clear the log file often. that will increase the performance.

bbrown · 2006-09-23

SQL expands its files (including log) when they reach 100% full. During this expansion the system queues all other disk request. Since the defult settings will add 10% to the database this can have a performance impact on a large database that expands often.

Do not rely on auto-expansion. Watch your file growth and expand manually during off-hours. Auto-expansion is there as a safety net.

SQL database expansion

Comments

Categories