Como gerar um DBCC SHINKFILE automaticamente ?
Pergunta
Todas as Respostas
-
Autoshrink e AutoIncrement sao parametros que devem ser usados com muito cuidado. Eles degradam a performance do Banco.Veja maisEu vi a sugestao de varios DBAs para desligar esses parametros e controlar tudo manualmente. Veja a importancia do plano de manutençao ai,com relacao a quando ela ée ativada, a resposta é sempre! por isso a degradaçao de performacese vc ler neste ultimo link, nem a microsoft recomenda o uso do autoshrink
.gif)
Note:Shrinking database and log files can be set to occur automatically. However, we recommend against automatic shrinking, and the autoshrink database property is set to FALSE by default. If autoshrink is set to TRUE, automatic shrinking reduces the size of a file only when more than 25 percent of its space is unused. The file is shrunk either to the size at which only 25 percent of the file is unused space or to the original size of the file, whichever is larger. For information about changing the setting of the autoshrink property, see How to: View or Change the Properties of a Database (SQL Server Management Studio)—use the Auto Shrink property on the Options page—or ALTER DATABASE SET Options (Transact-SQL)—use the AUTO_SHRINK option. att
William John Adam Trindade
Analyste-programmeur
----------------------------------------------------------
SOGI INFORMATIQUE LTÉE (http://www.sogi.com)
