SQL database expansion

aleix1979

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

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

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

kriki

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

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

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.