Solved

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

Posted on 2011-03-01
5
258 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 33

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 33

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
2003 File Server upgrade 11 74
Need suggestions from Upgrading the File server 5 53
How can I use this function? 3 34
SQL- GROUP BY 4 26
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

697 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