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
autocribAsked:
Who is Participating?
 
it_saigeDeveloperCommented:
Process Explorer or File Explorer from sysinternals could assist you.

http://technet.microsoft.com/en-us/sysinternals

HTH,

-saige-
0
 
autocribAuthor Commented:
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
0
 
autocribAuthor Commented:
Ok I used process mon and "show file system activity" is that correct?  So is this the best I can get?

Thanks
0
 
it_saigeDeveloperCommented:
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-
0
 
autocribAuthor Commented:
My comment narrows it down further on what to use.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.