Can anyone recommend what Performance Log Counters they would configure their Win2k server to monitor its disk, RAID controller, and other hardware / software settings that supports a server?s data storage and transfer of data (e.g. SCSI card, Hard Drive, Paging, I/O, etc.)?
I have to set up a hard drive performance counter on a Win2k SP4 with SQL 2k. For a while now, the server has been putting out the following error:
Event Source: dpti2o
Event ID: 9
Description: The device, DeviceScsidpti2o2, did not respond within the timeout period.
The server has three drives in RAID 5 using an Adaptec 2000s RAID card (driver v. 3.01) that is causing the dpti2o2 error.
I have determined what is causing these error messages has something to do with this RAID card. According to Adaptec, to fix this you need to install the latest and greatest driver, in this case, version of 3.10. However, my boss wants to put start some performance monitoring of the SCSI hard drives to really see what is going on, and why is the card getting a time-out issue. Even what he is asking is ?ridiculous,? I still need to set some type of performance monitoring to see what is going on.
Therefore, can anyone recommend what counters I should turn on, on what item, and what specific counter within each item? There are a lot of counters to choose from (e.g.: Paging, Physical Disk, Cache, Memory Counters, Job Object, Process, Processor, Physical Disk, etc.) and a lot of items to choose from within each of those counters. I would like some help on what would you recommend I start monitoring to see what I can find out about the dpti2o error message.
Thanks for any input,