I would not put too much trust in % Disk Time. A large value of this counter
often doesn't mean a thing. Also check out % Idle Time, Avg Disk sec/Read,
adn Avg Disk sec/Write.
Dear All, |
I am doing a performance analysis for one of my customer. After
analysis of the perfmon logs I foundout average _Total %DiskTime is
around 140, when I did a details analysis I found the data drive
%DiskTime is 90% of the _Total %DiskTime.
Now how do I findout what is causing this huge disk activity in data
drive and how do I isolate the disk activity of SQL Server.