asked on

How can I tell what file is being constantly accessed on a server 2003?

One of our server has a very high disk usage. I have tried troublshooting with the performance monitors and have ruled out CPU, memory, virutal memory bottlenecks. I notice that its disk read usage is very high. Is there a way to find out what file is being accessed constantly? In the past we have always found the culprit to be to be sql db. Just need to find out which one. Thanks

ASKER CERTIFIED SOLUTION

it_saige

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

autocrib

ASKER

Well I already know what process is causing it. SQL.. Can you be more specific on what utility I will need in this case. The closest I found is DU disk usage but it seems to narrow it down to a directory which doesn't help me since all the databases are locate in the same directory.

Thanks

SOLUTION

autocrib

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

it_saige

I'll have to do some looking. Since a DB is accessed via a SQL connection, Process Monitor will give you the processes and *most of the time* the files that are used as a part of that process. I am just not 100% certain that it will translate the same when given the SQL Process and it's database access/usage.

-saige-

autocrib

ASKER

My comment narrows it down further on what to use.