MasterZiv
komrad wrote:
> на вскидку - у вас высокий уровень Full ULC Flushes
А с чего ты это взял ? По мне так у них всё в сеть
упирается.
первый замер
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 362.6 3.1 5439 33.2 %
by End Transaction 148.5 1.3 2228 13.6 %
by Change of Database 0.3 0.0 5 0.0 %
by Single Log Record 435.4 3.7 6531 39.9 %
by Unpin 116.8 1.0 1752 10.7 %
by Other 28.3 0.2 425 2.6 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 1092.0 9.4 16380
ULC Log Records 19842.7 170.2 297640 n/a
Max ULC Size During Sample n/a n/a 4096 n/a
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 208.8 0.9 118997 24.9 %
by End Transaction 268.8 1.2 153220 32.0 %
by Change of Database 0.3 0.0 198 0.0 %
by Single Log Record 223.1 1.0 127195 26.6 %
by Unpin 115.4 0.5 65768 13.7 %
by Other 22.7 0.1 12957 2.7 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 839.2 3.7 478335
ULC Log Records 13212.9 57.5 7531339 n/a
Max ULC Size During Sample n/a n/a 4096 n/a
ну и рекомендации в обоих случаях :
Tuning Recommendations for Transaction Management
-------------------------------------------------
- Consider increasing the 'user log cache size'
configuration parameter.
Tuning Recommendations for Transaction Management
-------------------------------------------------
- Consider increasing the 'user log cache size'
configuration parameter.
К тому же, судя по наличию 4-Кб пула в кэшах, размер страницы на сервере составляет 4Кб.
+
тынц
цитатаWhen “Max ULC Size” equals the user log cache size, check the number of flushes due to transactions that fill the user log cache (see “By full ULC”). If the number of times that logs were flushed due to a full ULC is more than 20%, consider increasing the user log cache size configuration parameter.
Всё это и приводит к мысли о увеличении размера ULC.
Хотя, такой уровень может объясняться Mixed сегментами рабочей БД.
merphy9, покажите:
1.
2.
3.
4.
use mydb_2010
go
sp_helpdb mydb_2010
go
