Free working space on primary hard disc

15 pts.
Tags:
Hard disks
SQL Server
VS 2005 and .NET 2.0
Windows Server 2003
Windows XP
when large files (*.mdb, *.mdf) stored on server are opened on client PC - where do they open - client's memory or server memory? - I check properties of C: to check free space available - but after opening few large files, I do not see any change in property window of C: for free space avaialble. Does OS provide any utility to find out such statistics?

As an example I have a 80 GB HDD on my client PC. Now 20GB is still free. I know for defragmentation one need atleas 15% of free space. Other wise what is the ideal scenario to have what percentage of primary hard disc to be free?

 



Software/Hardware used:
Win 2003 server, winxp client , MS access, SQL server, VS 2005
ASKED: February 24, 2010  10:45 PM
UPDATED: February 25, 2010  2:23 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Disk and RAM (memory) are different things.

When you open a remote file, it is opened using client’s <b>memory </b>(not disk), so in normal situations your free disk space is not affected. You can use the Windows Task Manager (Performance and Processes tabs) to see statistics about resources usage.

The OS may use disk space to temporary store information as well (see <a href=”http://kb.iu.edu/data/ahbb.html”>In Windows, what is a swap file?</a>)

-CarlosDL

————————

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Vinodmerch
    Thanks CarlosDL, But ... My PC RAM is 2GB Which has to store part of OS, applications I have opened, along with so many other processes. SQL server files are very large. E.G. aspnet.mdf it self is 1 gb or more , MS Access uncoldensed file is upto 2 GB. I do not see how 2 GB ram or even Swap files can accomodate all these. Take for exampl I am converting a MS Access databse to SQL database. And a part of my question as to best scenario what percentage of primary hard disc should be free still remains unanswered.
    15 pointsBadges:
    report
  • carlosdl
    When you open or connect to the database, the OS does not keep the complete file in memory. It keeps portions of the files in memory as needed, and when it needs to show information to you that is not in memory it reads it from disk (in this case, from the server's disk). As for your second question, I don't have a well-founded answer, but I don't think it should be measured as a 'percentage' of the total size of the disk since you could have really big disks or really small ones. Some people say that when the utilized space is over 60% of the total, performance will start degrading, but I have never corroborated that. The free disk space needed would depend on the operations you need to perform on the machine. For example, the disk defragmentator requires some disk space to be able to run; If you want to re-size a virtual machine's disk you will need at least as much free space as the size of the virtual disk, and so on. Windows XP shows a warning when free disk space is less than 200 MB, so definitely having less than that is not recommended, but I would try to keep much more than that. I would also like to hear what others have to say about this topic.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following