Maclean Liu(刘相兵

*** 2013-08-12 15:12:37.486
Warning: log write time 12500ms, size 23KB
*** 2013-08-12 15:12:55.200
Warning: log write time 3290ms, size 21KB
*** 2013-08-12 15:13:01.120
Warning: log write time 4060ms, size 2KB
*** 2013-08-12 15:13:07.211
Warning: log write time 6090ms, size 6KB
*** 2013-08-12 15:13:10.206
Warning: log write time 2990ms, size 110KB
*** 2013-08-12 15:13:29.960
Warning: log write time 19710ms, size 1KB
*** 2013-08-12 15:13:35.212
Warning: log write time 5250ms, size 88KB
*** 2013-08-12 15:13:44.329
Warning: log write time 670ms, size 1KB
*** 2013-08-12 15:13:57.198
Warning: log write time 6850ms, size 2KB
*** 2013-08-12 15:14:17.210
Warning: log write time 19940ms, size 10KB
*** 2013-08-12 15:14:21.031
Warning: log write time 3820ms, size 8KB
*** 2013-08-12 15:14:46.196
Warning: log write time 25170ms, size 1KB



才 几十的iops而已

Maclean Liu(刘相兵

用orion 工具证明 该存储性能极差

Maclean Liu(刘相兵

FROM swgsw:

swgsw

SQL>  alter database add logfile group  99 size 1024M;

Database altered.

Elapsed: 00:04:23.75

===>

263s  1024/263 =3.89mb/s