K
K
Konstantin Dashkevich2016-07-18 23:38:46
SQL Server
Konstantin Dashkevich, 2016-07-18 23:38:46

Why did the size of the mdf file grow when indexes were rebuilt?

Database size before operation ~4 GB
Rebuilt indexes on all database tables with the command:

ALTER INDEX ALL ON @TableName REBUILD WITH (FILLFACTOR = 10, SORT_IN_TEMPDB = ON)

The size of the mdf file has grown four times, if you run the operation again, the size continues to grow, although the indexes have already been rebuilt. With what it can be connected? Is it possible to avoid it?
When rebuilding indexes on "thick" tables, the size does not grow through the SQL Management Studio interface.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Андрей Скоржинский, 2016-07-19
@Vinchelo

все это дело повязано с опцией FILLFACTOR, глянте чего там MSSMS отправляет на сервер и можно почитать про описание коэффициента заполнения

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question