dbTalk Databases Forums  

%Disk Time

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.server %Disk Time

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


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



Reply
Page 2 of 5 < 1 2 3 4 5 >
 
Thread Tools Display Modes
  #11  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: %Disk Time - 05-16-2008 , 01:33 PM





fn_virtual_filestats will tell you which file(s) are doing the physical
reads or writes and a trace will tell you what is doing it.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Balaji" <tbalajiprabhu (AT) gmail (DOT) com> 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
  #12  
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
  #13  
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
  #14  
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
  #15  
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
  #16  
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
  #17  
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
  #18  
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
  #19  
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
  #20  
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
Reply
Page 2 of 5 < 1 2 3 4 5 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top