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
Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Restore Script - Syntax Error 8 104
What is this Task? 4 130
2003 Server DNS/FS errors 6 65
Query to return total 6 21
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
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…

839 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