SQL database expansion

aleix1979aleix1979 Member Posts: 213
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:
Navision Developer

Comments

  • krikikriki Member, Moderator Posts: 9,118
    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...
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • DenSterDenSter Member Posts: 8,307
    SQL Server will kick off the expansion when you least want it to happen. It is better to expand manually during off hours.
  • krikikriki Member, Moderator Posts: 9,118
    DenSter wrote:
    SQL Server will kick off the expansion when you least want it to happen.
    One of the consequences of Murphy's laws :mrgreen:
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • soopervoicesoopervoice Member Posts: 1
    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.
  • bbrownbbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.
Sign In or Register to comment.