Аномальное поведение AOS+БД

[demianimp]

Цитата:

Сообщение от Logger

По вопросу 1 - возможно у вас сама табличка фрагментирована. Поройте эту тему.

Если выполнить команды

DBCC SHOWCONTIG ('CUSTINVOICEJOUR')
DBCC SHOWCONTIG scanning 'CUSTINVOICEJOUR' table...
Table: 'CUSTINVOICEJOUR' (2067993127); index ID: 1, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 420067
- Extents Scanned..............................: 52536
- Extent Switches..............................: 57048
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 92.04% [52509:57049]
- Logical Scan Fragmentation ..................: 1.26%
- Extent Scan Fragmentation ...................: 64.65%
- Avg. Bytes Free per Page.....................: 1151.0
- Avg. Page Density (full).....................: 85.78%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC SHOWCONTIG ('CUSTINVOICETRANS')
DBCC SHOWCONTIG scanning 'CUSTINVOICETRANS' table...
Table: 'CUSTINVOICETRANS' (35531210); index ID: 1, database ID: 5
TABLE level scan performed.
- Pages Scanned................................: 2062292
- Extents Scanned..............................: 257851
- Extent Switches..............................: 258098
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.88% [257787:258099]
- Logical Scan Fragmentation ..................: 0.05%
- Extent Scan Fragmentation ...................: 56.01%
- Avg. Bytes Free per Page.....................: 1266.0
- Avg. Page Density (full).....................: 84.36%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Если я правильно прочитал результат, то у меня не все так плохо.