Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    3

    Unanswered: Low disk space on C:

    I noticed something strange today. I was running a query using query analyzer on a large database (8.8 million records) and the disk space on the c: drive was dropping and eventually went to 0. Availalbe space on the c: drive is 10GB. The query did complete. SQL server and all the databases are on the d: drive. After closing the query results in query analyzer the disk space returned. Is this a concern and is there a way to change it to use the d: for whatever it is doing?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Where is your swap file residing?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Aug 2004
    Posts
    3
    It's on the c: drive. Must have overlooked that after the install. I will change that and see what happens. Thanks!

  4. #4
    Join Date
    Aug 2004
    Posts
    3
    Swap file didn't make a difference. I did find where the disk space was going though. QA was creating a temp file in c:\documents and settings\administrator\local settings\temp. I changed the TEMP and TMP variable to now point to e:\temp and that is much better.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •