Solved

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

Posted on 2011-03-01
5
259 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:autocrib
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 34

Accepted Solution

by:
it_saige earned 500 total points
ID: 35010698
Process Explorer or File Explorer from sysinternals could assist you.

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

HTH,

-saige-
0
 

Author Comment

by:autocrib
ID: 35020891
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
 

Assisted Solution

by:autocrib
autocrib earned 0 total points
ID: 35021636
Ok I used process mon and "show file system activity" is that correct?  So is this the best I can get?

Thanks
0
 
LVL 34

Expert Comment

by:it_saige
ID: 35021871
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
 

Author Closing Comment

by:autocrib
ID: 35115311
My comment narrows it down further on what to use.
0

Featured Post

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question