- 论坛徽章:
- 0
|
用户反映数据库慢,因为有问题,只抓了1分钟的sysmon,虽然时间短了点,但是应该也能看出点问题所在吧。希望高手指点一下
首先是CPU使用率 1个有99%,可是其他的却很低。放弃率有20%,不知道这个是不是正常
切换的原因就是 Network Packet Sent ,而且所有的 数据发送都在1个CPU上,别的CPU都没用到
这是为什么?
是不是因为Net IO过大,一直在等待,切换的原因导致数据库慢的阿?
我觉得有用的部分报告如下
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 99.3 %
Engine 1 37.8 %
Engine 2 37.3 %
Engine 3 36.1 %
Engine 4 34.2 %
Engine 5 37.6 %
----------- --------------- ----------------
Summary Total 282.3 % Average 47.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 7.3 2.6 870 19.2 %
Engine 2 7.7 2.8 928 20.5 %
Engine 3 7.7 2.7 922 20.4 %
Engine 4 7.8 2.8 932 20.6 %
Engine 5 7.3 2.6 875 19.3 %
------------------------- ------------ ------------ ----------
Total CPU Yields 37.7 13.5 4527
Network Checks
Non-Blocking 17873.2 6383.3 2144779 100.0 %
Blocking 7.1 2.5 846 0.0 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 17880.2 6385.8 2145625
Avg Net I/Os per Check n/a n/a 0.89338 n/a
Disk I/O Checks
Total Disk I/O Checks 90526.6 32330.9 10863188 n/a
Checks Returning I/O 29170.8 10418.1 3500490 32.2 %
Avg Disk I/Os Returned n/a n/a 0.00049 n/a
Task Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Connections Opened 0.2 0.1 22 n/a
Task Context Switches by Engine
Engine 0 259.0 92.5 31085 15.8 %
Engine 1 353.6 126.3 42427 21.6 %
Engine 2 290.3 103.7 34840 17.7 %
Engine 3 254.0 90.7 30476 15.5 %
Engine 4 197.7 70.6 23727 12.1 %
Engine 5 281.2 100.4 33745 17.2 %
------------------------- ------------ ------------ ----------
Total Task Switches: 1635.8 584.2 196300
Task Context Switches Due To:
Voluntary Yields 10.8 3.9 1299 0.7 %
Cache Search Misses 6.9 2.5 824 0.4 %
System Disk Writes 0.3 0.1 36 0.0 %
I/O Pacing 1.0 0.4 124 0.1 %
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.7 0.3 87 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.3 0.1 32 0.0 %
Last Log Page Writes 3.8 1.4 455 0.2 %
Modify Conflicts 0.5 0.2 65 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 29.6 10.6 3554 1.8 %
Network Packet Sent 15944.3 5694.4 1913315 974.7 %
Other Causes -14362.4 -5129.4 -1723491 -878 %
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 1348.7 481.7 161840 n/a
Network I/Os Delayed 0.0 0.0 0 0.0 %
Total TDS Packets Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 29.6 10.6 3554 100.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 0.0 0.0 0 0.0 %
Engine 3 0.0 0.0 0 0.0 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 29.6 10.6 3554
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 6380.2 2278.6 765618 100.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 0.0 0.0 0 0.0 %
Engine 3 0.0 0.0 0 0.0 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 6380.2 2278.6 765618
Avg Bytes Rec'd per Packet n/a n/a 215 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 15944.3 5694.4 1913315 100.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 0.0 0.0 0 0.0 %
Engine 3 0.0 0.0 0 0.0 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 15944.3 5694.4 1913315
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 8152957.2 2911770.5 978354862 100.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 0.0 0.0 0 0.0 %
Engine 3 0.0 0.0 0 0.0 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 8152957.2 2911770.5 978354862
Avg Bytes Sent per Packet n/a n/a 511 n/a
[ 本帖最后由 action929 于 2006-9-23 22:18 编辑 ] |
|