hello,

Alexey Kovyazin wrote:

>Also you may gather database statisctis and take a look on table size -
>the critical size is 36.6 gb.
>
>

it seems that this is a source of my problem :( what is the exact
limit? how to calculate it? i have 8192 page size. the current stat for
the critical table:

Primary pointer page: 143, Index root page: 144
Data pages: 4310775, data page slots: 4435591, average fill: 8%
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 0
60 - 79% = 0
80 - 99% = 4310771

what are the interesting values for me "data pages" or "data page slot"?
i suppose the difference is because of running sweep?
data pages = 35.3gb
data page slots = 36.3gb !!!

to solve the problem i deleted some records and started sweep process -
the stat is done after delete but before the sweep is finished btw. it's
still running :(.

i had also the idea to turn on full data page filling but i'm afraid
because i don't know the possible performance impact. what could i expect?

regards.,
...michal