SQL JOB taking more space

  • arooj300

    Hall of Fame

    Points: 3433

    Hi All,

    One SQL SERVER job has scheduled for morning 3:00 AM , that job is taking 3 to 5 hour to execute. Yesterday C:/ drive space was 28 GB free but today i have checked c:/ having only 13 GB free space.

    Anyone , please help me on this and also tell me what are thing is taking more space in C:/ drive because when I restart the server the drive space reached 28 GB.

    Thanks

  • Koen Verbeeck

    SSC Guru

    Points: 258888

    How are you sure the space issue is linked to the job?

    What does the job do?

    Are your databases stored on the C: drive?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • arooj300

    Hall of Fame

    Points: 3433

    Job has scheduled for updating the data from source to target. For that one we have created SSIS package.

    Databse backup we used to take in other drive.

  • Koen Verbeeck

    SSC Guru

    Points: 258888

    Is it possible tempdb used a lot of space? (is tempdb stored on the c drive?)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • arooj300

    Hall of Fame

    Points: 3433

    tempdb is located to the other drive and we have lot of space on that drive.

  • arooj300

    Hall of Fame

    Points: 3433

    Windows folder is occupied 14.9 GB space. I am not able to find , why that folder is taking more space.

  • free_mascot

    One Orange Chip

    Points: 27168

    You mean due to SSIS package database size is growing on C:?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • arooj300

    Hall of Fame

    Points: 3433

    I am not sure. I think , because of SSIS package C:/drive is growing. I read some article about this one to change the SSIS package temp file location in BLOBTEmpStorage Path and BufferTempStorage path. So Iahve changed the path also but still the issue is remain..

  • Koen Verbeeck

    SSC Guru

    Points: 258888

    The package itself will not take that much space.

    It all depends on what the ssis package is doing exactly.

    Without more info, we're just guessing here.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • arooj300

    Hall of Fame

    Points: 3433

    Hi All,

    Thanks for the reply, I got the problem the System file is taking 13 GB space.

    Could you please tell me , is there any alternative ways to release the space from the drive.

  • free_mascot

    One Orange Chip

    Points: 27168

    What kind of System File?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply