question

acappelletti avatar image
0 Votes"
acappelletti asked ErlandSommarskog answered

Number of page into index for maintenance operation

Hi all,
I'm using a script for reorganize/rebuild but it work on a threshold for the number of pages present:

  • @MinNumberOfPages int = 1000

Naturally after the operation some of them aren't reorganized/rebuilt.
I would like to know more about this setting... it's correct or it is better to lower it a little bit 'til 500.
Also, are numbers like 10/20/30 ridiculous?

Thanks Alen Itay



sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I think 1000 pages is a magic number everyone has agreed on. If you want to do some testing to find out where it matters, well try it out.

Although I think the testing Tibor Karaszi did some time back is more interesting. The question he wanted to answer was: with SSDs does it matter at all? http://sqlblog.karaszi.com/category/indexes/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.