Solved

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

Posted on 2011-03-01
5
255 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
  • 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Truncate vs Delete 63 102
How to query LOCK_ESCALATION 4 40
Why is the output of this function is like this? 4 29
Event ID: 1008 / Source: Microsoft-Windows-Perflib 2 131
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now