Question for sysmon output

[Taylor]

Hi,

ULC Flushes to Xact Log per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
by Full ULC 0.0 0.0
6 0.2 %
by End Transaction 2.0 0.8
1173 35.5 %
by Change of Database 0.0 0.0
22 0.7 %
by Single Log Record 2.4 0.9
1441 43.6 %
by Unpin 0.4 0.1
216 6.5 %
by Other 0.7 0.3
448 13.6 %

Here what is the meaning of 'by Single Log Record'? I only found 'by
System Log Record' in the document.
What does it mean if the percentage is high?


Task Context Switches Due To:
Voluntary Yields 3.0 1.2
1784 16.4 %
Cache Search Misses 0.8 0.3
493 4.5 %
System Disk Writes 0.3 0.1
191 1.8 %
I/O Pacing 2.0 0.8
1188 10.9 %
Logical Lock Contention 0.0 0.0
0 0.0 %
Address Lock Contention 0.0 0.0
0 0.0 %
Latch Contention 0.0 0.0
0 0.0 %
Log Semaphore Contention 0.0 0.0
0 0.0 %
PLC Lock Contention 0.0 0.0
0 0.0 %
Group Commit Sleeps 0.0 0.0
3 0.0 %
Last Log Page Writes 2.3 0.9
1407 13.0 %
Modify Conflicts 0.0 0.0
0 0.0 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 3.6 1.4
2137 19.7 %
Network Packet Sent 0.1 0.0
63 0.6 %
Other Causes 6.0 2.3
3584 33.0 %

Another question: what is 'Last Log Page Writes'? The document said
“Last Log Page Writes” reports the number of times a task was switched
out because it was put to sleep while writing the last log page.
But it doesn't explain what is the 'Last Log Page'.

Please help me out.

[unknown]

Last log page Writes
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00842.1502/html/spsysmon/X94488.htm
--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0
"Taylor" <***@hotmail.com> wrote in message news:83d22f53-3247-431f-a581-***@m3g2000yqf.googlegroups.com...
Hi,

ULC Flushes to Xact Log per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
by Full ULC 0.0 0.0
6 0.2 %
by End Transaction 2.0 0.8
1173 35.5 %
by Change of Database 0.0 0.0
22 0.7 %
by Single Log Record 2.4 0.9
1441 43.6 %
by Unpin 0.4 0.1
216 6.5 %
by Other 0.7 0.3
448 13.6 %

Here what is the meaning of 'by Single Log Record'? I only found 'by
System Log Record' in the document.
What does it mean if the percentage is high?


Task Context Switches Due To:
Voluntary Yields 3.0 1.2
1784 16.4 %
Cache Search Misses 0.8 0.3
493 4.5 %
System Disk Writes 0.3 0.1
191 1.8 %
I/O Pacing 2.0 0.8
1188 10.9 %
Logical Lock Contention 0.0 0.0
0 0.0 %
Address Lock Contention 0.0 0.0
0 0.0 %
Latch Contention 0.0 0.0
0 0.0 %
Log Semaphore Contention 0.0 0.0
0 0.0 %
PLC Lock Contention 0.0 0.0
0 0.0 %
Group Commit Sleeps 0.0 0.0
3 0.0 %
Last Log Page Writes 2.3 0.9
1407 13.0 %
Modify Conflicts 0.0 0.0
0 0.0 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 3.6 1.4
2137 19.7 %
Network Packet Sent 0.1 0.0
63 0.6 %
Other Causes 6.0 2.3
3584 33.0 %

Another question: what is 'Last Log Page Writes'? The document said
“Last Log Page Writes” reports the number of times a task was switched
out because it was put to sleep while writing the last log page.
But it doesn't explain what is the 'Last Log Page'.

Please help me out.

[SpeedyIQ]

You might want to investigate these two,

Cache Search Misses 0.8 0.3
493 4.5 %
System Disk Writes 0.3 0.1
191 1.8 %

Can you lower down Misses (1-2%) by better indexes less table scan or
with named caches?

Can you post sp_cacheconfig, sp_helpcache?

Post by Taylor
Hi,
ULC Flushes to Xact Log per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
by Full ULC 0.0 0.0
6 0.2 %
by End Transaction 2.0 0.8
1173 35.5 %
by Change of Database 0.0 0.0
22 0.7 %
by Single Log Record 2.4 0.9
1441 43.6 %
by Unpin 0.4 0.1
216 6.5 %
by Other 0.7 0.3
448 13.6 %
Here what is the meaning of 'by Single Log Record'? I only found 'by
System Log Record' in the document.
What does it mean if the percentage is high?
Voluntary Yields 3.0 1.2
1784 16.4 %
Cache Search Misses 0.8 0.3
493 4.5 %
System Disk Writes 0.3 0.1
191 1.8 %
I/O Pacing 2.0 0.8
1188 10.9 %
Logical Lock Contention 0.0 0.0
0 0.0 %
Address Lock Contention 0.0 0.0
0 0.0 %
Latch Contention 0.0 0.0
0 0.0 %
Log Semaphore Contention 0.0 0.0
0 0.0 %
PLC Lock Contention 0.0 0.0
0 0.0 %
Group Commit Sleeps 0.0 0.0
3 0.0 %
Last Log Page Writes 2.3 0.9
1407 13.0 %
Modify Conflicts 0.0 0.0
0 0.0 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 3.6 1.4
2137 19.7 %
Network Packet Sent 0.1 0.0
63 0.6 %
Other Causes 6.0 2.3
3584 33.0 %
Another question: what is 'Last Log Page Writes'? The document said
“Last Log Page Writes” reports the number of times a task was switched
out because it was put to sleep while writing the last log page.
But it doesn't explain what is the 'Last Log Page'.
Please help me out.