dbTalk Databases Forums  

%Disk Time

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss %Disk Time in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
Linchi Shea
 
Posts: n/a

Default RE: %Disk Time - 05-16-2008 , 02:03 PM






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.

Linchi

"Balaji" wrote:

Quote:
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.

Regards
Balaji


Reply With Quote
  #22  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM






Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #23  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #24  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #25  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #26  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #27  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #28  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #29  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
  #30  
Old   
Balaji
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 04:03 PM



Guys,

Thanks for your suggestion. How do I findout is it sql server causing
the i/o or some other process on the server.

Regards
Balaji

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.