กำลังมีปัญหาเกี่ยวกับ I/O ของ Harddisk ครับ
Physical Disk: Avg. Disk Queue Length
Besides watching the Physical Disk: % Disk Time counter, you will also want to watch the Avg. Disk Queue Length counter as well. If it exceeds 2 for continuous periods (over 10 minutes or so during your 24 hour monitoring period) for each disk drive in an array, then you may have an I/O bottleneck for that array. Like the Physical Disk: % Disk Time counter, if this happens occasionally in your 24 hour monitoring period, I wouldn't worry too much, but if it happens often, then I would start looking into finding ways to increase the I/O performance on the server, as described previously.
You will need to calculate this figure because Performance Monitor does not know how many physical drives are in your array. For example, if you have an array of 6 physical disks, and the Avg. Disk Queue Length is 10 for a particular array, then the actual Avg. Disk Queue Length for each drive is 1.66 (10/6=1.66), which is well within the recommended 2 per physical disk.
Before using this counter under NT 4.0, be sure to manually turn it on by going to the NT Command Prompt and entering the following: "diskperf -y", and then rebooting your server. This is required to turn on the disk counters on for the first time under Windows NT 4.0. If you are running Windows 2000, this counter is turned on by default.
Use both the % Disk Time and the Avg. Disk Queue Length counters together to help you decide if your server is experiencing an I/O bottleneck. For example, if you see many time periods where the % Disk Time is over 55% and when the Avg. Disk Queue Length counter is over 2 per physical disk, you can be confident the server is having a I/O bottleneck.
http://databasediskperf.blogspot.com/2006/06/disk-queue-length-vs-disk-latency.htmlhttp://www.sql-server-performance.com/performance_monitor_counters_io.asphttp://www.sql-server-performance.com/sql_server_performance_audit2.aspตอนนี้เรา tune ทุกอย่างที่จะทำได้แล้วครับ เหลือแต่เพิ่ม Harddisk (SCSI)
หัวข้อ: server down (อ่าน 3299 ครั้ง)