This is a 41 second sample of LOG I/Os:
---
LOG
---
Log sequence number 29 3555351687
Log flushed up to 29 3555341154
Last checkpoint at 29 3549060068
0 pending log writes, 0 pending chkp writes
28826862 log i/o's done, 41.97 log i/o's/second
is that log i/o's/second too large? What should be adjusted? I see references everywhere that says "if you have alot of log i/o increase log buffer" which is a worthless statement without an idea of what "alot" is.
---
LOG
---
Log sequence number 29 3555351687
Log flushed up to 29 3555341154
Last checkpoint at 29 3549060068
0 pending log writes, 0 pending chkp writes
28826862 log i/o's done, 41.97 log i/o's/second
is that log i/o's/second too large? What should be adjusted? I see references everywhere that says "if you have alot of log i/o increase log buffer" which is a worthless statement without an idea of what "alot" is.
Comment