Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database Fragmentation
Message
De
08/09/2006 21:19:32
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
 
 
À
08/09/2006 20:55:51
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01151627
Message ID:
01152499
Vues:
37
>Hi Keith,
>
>I just found that the autogrowth of the MDF File is set to 1MB and the Log File is set to 10%. Would this be the cause of the fast growth of the database?
>
>Thanks...

Hi Mike.

It is minutely possible that a 10% growth on the log would account for the increase in size. How big is the log file to begin with and how many times has the file grown? If you have taken several measurements that all show an increase in the log file size over the previous measurement, then the 10% is not the problem.

As a side note, unless you expect your # of transactions to accelerate, it is better to set the the growth to a fixed amount rather than a percentage.

Have you checked the recovery model for the database and have you confirmed that there is a maintenance plan that includes backups or log shipping followed by a DBCC SHRINKDATABASE? This discussion is academic until those two settings are confirmed.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform