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

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@gmail.com> wrote in message
news:13fe96ad-2a0a-43e4-aabb-90bb5ef88beb@j22g2000hsf.googlegroups.com...
> 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

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:

> 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
>

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

If you have other apps on the server doing I/O you are starting off on the
wrong foot to being with if performance is a goal. Again look at the files
stats to see how much physical I/O sql server is doing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Balaji" <tbalajiprabhu@gmail.com> wrote in message
news:09c361cb-e2d8-49ec-ab51-8f66575c15e5@34g2000hsh.googlegroups.com...
> 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